openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jakob Braeuchi (JIRA)" <>
Subject [jira] Created: (OPENJPA-80) Bad Escaping for LIKE in MySQL
Date Mon, 13 Nov 2006 20:02:39 GMT
Bad Escaping for LIKE in MySQL

                 Key: OPENJPA-80
             Project: OpenJPA
          Issue Type: Bug
          Components: query
         Environment: openJPA 0.9.7 
MySQL 5.0.15
            Reporter: Jakob Braeuchi

the following query :

em.createQuery("select k from KategorieGruppe k  where k.bezeichnung like ?1 order by k.bezeichnung

generates an sql-statement with a bad escaping character '\' for MySQL :

SELECT, t0.bezeichnung FROM ekv2kategoriegruppe t0 WHERE (t0.bezeichnung LIKE ? ESCAPE
'\') ORDER BY t0.bezeichnung ASC

the correct escaping would be '\\'.

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
For more information on JIRA, see:


View raw message