I have a very simple relationship. UserBean <---- Login This is 1:1 relationship. I am trying to load UserBean from LoginBean. At the database level It is Login.UserId [FK] = User.Id In LoginBean I have setUserBean and getUserBean methods. I have written a EJB-QL, Where I fecth the Object of LoginBean.
It compiles and installs very decently. However, when I try to invoke the EJB-QL. I get the following error in the log file.
select id,username.....,userBean from Login where username = ? and password = ?
This is a wrong SQL as there is no userBean in the Login Table.
I tried to use this in Jboss3.0.x plus on jboss3.2.0 with Tomcat.
Can someone please explain, why Jboss is creating a worng SQL.