Strange SQL generated

[torben]

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

[dsundstrom]

This is a bug and has been fixed in cvs.

The problem it you declare the identifier as a lowercase u and the use an uppercase u. This is perfectly legal according to the spec, but I implemented it wrong. In the meantime, just be consistent.