Author: sebawagner
Date: Wed Feb 20 08:09:26 2013
New Revision: 1448031
URL: http://svn.apache.org/r1448031
Log:
add lower() to JPQL to add case-insensitive comparison
Modified:
openmeetings/trunk/singlewebapp/src/org/apache/openmeetings/persistence/beans/user/State.java
Modified:
openmeetings/trunk/singlewebapp/src/org/apache/openmeetings/persistence/beans/user/State.java
URL:
http://svn.apache.org/viewvc/openmeetings/trunk/singlewebapp/src/org/apache/openmeetings/persistence/beans/user/State.java?rev=1448031&r1=1448030&r2=1448031&view=diff
==============================================================================
---
openmeetings/trunk/singlewebapp/src/org/apache/openmeetings/persistence/beans/user/State.java
(original)
+++
openmeetings/trunk/singlewebapp/src/org/apache/openmeetings/persistence/beans/user/State.java
Wed Feb 20 08:09:26 2013
@@ -36,7 +36,7 @@ import javax.persistence.Table;
"where c.state_id = :state_id AND c.deleted <>
:deleted"),
@NamedQuery(name = "getStates", query = "select c from State as c where
c.deleted <> :deleted"),
@NamedQuery(name = "getStateByName", query = "select c from State as c
" +
- "where c.name LIKE :name AND c.deleted <> :deleted")
+ "where lower(c.name) LIKE lower(:name) AND c.deleted <>
:deleted")
})
@Table(name = "state")
public class State implements Serializable {
