Unable to execute native queries which start with the WITH keyword.
--------------------------------------------------------------------
Key: OPENJPA-511
URL: https://issues.apache.org/jira/browse/OPENJPA-511
Project: OpenJPA
Issue Type: Bug
Components: jdbc
Affects Versions: 1.0.1
Environment: DB2
Reporter: Michael Dick
Assignee: Michael Dick
Fix For: 1.1.0
Some databases support using WITH ${var} AS (SELECT . . .) SELECT ${var}, . . .
The variable may be used in a future select statement.
Currently OpenJPA checks whether a native query begins with "select" (case
insensitive) and throws an exception if an application calls getSingleResult()
or getResultList() if select isn't found. As I understand it the WITH
statement may only be used in conjunction with a SELECT statement, so it should
be safe to treat the WITH statement as a select.
I'm not sure how many databases support this syntax so it might be best to
limit the support to specific databases.
The only database to support the WITH statement that I know of is DB2, but this
may apply to other databases too. Additional documentation can be found in the
DB2 infocenter :
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.datatools.sqlbuilder.doc/topics/ruisqlbldrwth.html.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
