1 Reply Latest reply on Dec 11, 2001 12:32 AM by Dain Sundstrom

    Strange SQL generated

    Torben Norling Newbie

      Hi,
      I'm new to JBoss (Using JB 3.0.0a + mySQL) and can't get my finders to work. Seems like the generated SQL is kindof strange...

      I have a query defined like this:


      Find a user by the name.

      <query-method>
      <method-name>findByName</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(U) FROM User u WHERE U.userName = ?1</ejb-ql>


      In the log it indicates that the SQL is translated into following:
      findByName command executing: SELECT FROM Users t1_u

      I guess I can have lots of faults in my ejb-jar.xml and jbosscmp-jdbc but have anyone else seen anything like above?!?

      Thanks // Torben