Why should it be a dot instead of an underscore? JBossCMP does not support a column name that contains a dot.
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
select * from department where department.no > 1
will both work fine.
...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?
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/>
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!