How does the SQL look like? Is it correct? If so, it's not a JBoss problem.
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3846983#3846983
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3846983
-
"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"
| | |
I like the UCASE solutions posted here better, but what I'm doing for MySQL has been
working:
I changed the standardjbosscmp-jdbc.xml file, changing the java.lang.String mapping
from a "VARCHAR(250) BINARY" to just "VARCHAR(250)", and MySQL does a case-insensitive
compare by default I guess.
"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
findByIn
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
It seems like there is no...
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3842907#3842907
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3842907
---
This SF.Net emai
I have a similar problem in the order clause. JBossQL seems to not support ucase
there. Is there a workaround for it?
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3842879#3842879
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=
You can use ucase and lcase in JBossQL. select object(o) from O o where lcase(o.name)
= lcase(?1)
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3840881#3840881
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3840881
--