Re: svn commit: r1448031 - /openmeetings/trunk/singlewebapp/src/org/apache/openmeetings/persistence/beans/user/State.java

[Maxim Solodovnik <so...@gmail.com>]

Have you tried this?

according to this
http://www.mail-archive.com/users@openjpa.apache.org/msg01218.html link it
should not work :(


On Wed, Feb 20, 2013 at 3:09 PM, <se...@apache.org> wrote:

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


-- 
WBR
Maxim aka solomax