[JBoss-dev] [ jboss-Bugs-706799 ] Jboss CMR extra column name problem

[SourceForge.net <no...@so...>]

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: austin chau (austinchau)
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



----------------------------------------------------------------------

Comment By: Alexey Loubyansky (loubyansky)
Date: 2003-03-20 11:26

Message:
Logged In: YES 
user_id=543482

Could you provide more info?
What EJB-QL statement? What is the expected SQL?

Thanks,
alex

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=706799&group_id=22866