-
1. Re: CMR bug?
dsundstrom Apr 30, 2002 10:23 AM (in response to cnsxxx09)Why should it be a dot instead of an underscore? JBossCMP does not support a column name that contains a dot.
-
2. Re: CMR bug?
cnsxxx09 Apr 30, 2002 10:59 AM (in response to cnsxxx09)Quite simple because 'employee' is the name of the table and 'no' is the name of the column....therefore
select * from employee where employee.no > 1
or
select * from department where department.no > 1
will both work fine.
Chris
-=-=-= -
3. Re: CMR bug?
cnsxxx09 Apr 30, 2002 11:07 AM (in response to cnsxxx09)...looking at it in more detail....I cannot figure out where it is getting "employee_no" from anyway.
The statement is:
select addno from Address where employee_no = ?
The Foreign Key column is actually called 'employee' (there is no 'employee_no' column anywhere ) and refers to the Primary Key column 'no' in the 'Employee' table.
None of my columns or fields have an underscore.
Maybe there is an error in my jbosscmp-jdbc.xml file?
Where does the underscore come from? how is it built up?
TIA
Chris
-=-=- -
4. Re: CMR bug?
dsundstrom Apr 30, 2002 12:51 PM (in response to cnsxxx09)My guess is you have foreign keys in both tables. Take a close look at your create table statements. If you are not allowing JBossCMP to create the tables, make sure that the employee side of the relationship has an empty key-fields element. <key-fields/>
-
5. Re: CMR bug?
cnsxxx09 May 2, 2002 3:49 AM (in response to cnsxxx09)the problem was thaI had a column for my foreign key in my entity bean...as I remember some time ago that WebLogic complained if it wasn't there...I removed it and it works!
Thanks
Chris
-=-=-