"svadu" wrote : "WebSel" wrote : For the XDoclet users here's my 5$ | | | | This is the finder in jboss | | | | | | | | | | * @jboss.query | | | * query="SELECT OBJECT(o) FROM Person o WHERE LCASE(o.lastName) = LCASE(?1) ORDER BY o.foreName" | | | * signature="java.util.Collection findByInitialsLastNameBirthDate(java.lang.String lastName)" | | | | | | | As was written above the UCASE and LCASE did the trick | | | | Thanks! | | Wessel | | I confirm that this works. For some unknown to me reason UCASE didn't work but LCASE did the trick (jboss 3.2.3)...
Unfortunately I found that this works only if the fiild value in the database i s in lowercase (that's why LCASE worked for me). Unfrotunately I am not sure how else to make it working (not sure if changing the mapping is the best solution. Was anyone else successfull in this? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3846871#3846871 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3846871 ------------------------------------------------------- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_id=5047&alloc_id=10808&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
