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
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.