Albert Lee created OPENJPA-2376:
-----------------------------------
Summary: Escape character in JPQL with parameter substitution
generates incorrect SQL
Key: OPENJPA-2376
URL: https://issues.apache.org/jira/browse/OPENJPA-2376
Project: OpenJPA
Issue Type: Bug
Components: jdbc
Affects Versions: 2.2.1, 2.1.1, 2.2.2, 2.2.1.1
Reporter: Albert Lee
Assignee: Albert Lee
Escape character in JPQL/SQL with parameter substitution generates incorrect
SQL. E.g.
"SELECT 'TRUE' AS VAL FROM DUAL WHERE '\\' = ?"
or
"SELECT * FROM ( SELECT FOLDER_ID, SYS_CONNECT_BY_PATH(NAME,'\\') AS PATH FROM
PROJECT_FOLDER START WITH PARENT_ID IS NULL CONNECT BY PRIOR FOLDER_ID =
PARENT_ID ) WHERE PATH LIKE ?"
the '\\' will be transformed to '' and causes SQLException when send to the db
server.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
