0 Replies Latest reply on Mar 19, 2003 2:49 AM by Dheeraj

    Jboss CMR extra column name problem

    Dheeraj Newbie

      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