Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@openjpa.apache.org
Message-ID: <1677432166.1252711077454.JavaMail.jira@brutus>
Date: Fri, 11 Sep 2009 16:17:57 -0700 (PDT)
From: "Fay Wang (JIRA)" <jira@apache.org>
To: dev@openjpa.apache.org
Subject: [jira] Resolved: (OPENJPA-1295) Query with Escape '\' fails in
 MySQL
In-Reply-To: <1144171242.1252710717758.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/OPENJPA-1295?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Fay Wang resolved OPENJPA-1295.
-------------------------------

    Resolution: Fixed

> Query with Escape '\' fails in MySQL
> ------------------------------------
>
>                 Key: OPENJPA-1295
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1295
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: jdbc
>    Affects Versions: 2.0.0
>            Reporter: Fay Wang
>             Fix For: 2.0.0
>
>
> The following jpql fails in MySQL: 
> Select e from Employee e where e.name LIKE :name ESCAPE '\'
> The exception trace:
> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''\')' at line 1 {prepstmnt 1239002810 SELECT t0.empId, t0.hireDate, t0.hireTime, t0.hireTimestamp, t0.name, t0.someLong, t0.statusId FROM SUBQ_EMPLOYEE t0 WHERE (t0.name LIKE ? ESCAPE '\') [params=(String) M\%%]} [code=1064, state=42000]
> at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4587)
> at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4540)
> The test case is org.apache.openjpa.persistence.query.TestQueryEscapeCharacters.testEscapedQuery  

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.