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

    Strange SQL generated

    Torben Norling Newbie

      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.

      <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