Bugs item #706799, was opened at 2003-03-20 10:31 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=706799&group_id=22866
Category: JBossCMP Group: v3.2 Status: Open Resolution: None >Priority: 3 Submitted By: Dheeraj Srivastava (dheeraj_s) Assigned to: Nobody/Anonymous (nobody) Summary: Jboss CMR extra column name problem Initial Comment: Hi : 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. Cheers Dheeraj ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=706799&group_id=22866 ------------------------------------------------------- This SF.net email is sponsored by: Tablet PC. Does your code think in ink? You could win a Tablet PC. Get a free Tablet PC hat just for playing. What are you waiting for? http://ads.sourceforge.net/cgi-bin/redirect.pl?micr5043en _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development