JPA native query parsing


stephane
 

Hi,

It seems DN parse the native queries before execution. I found 2 cases:

-1- Query with * projection on flat inheritance model
The model (ex: Client -|> Person) mapped on one single table PERSON (ID, DISC, NAME)
In such situation when executing a query on the top persistent class, DN requires to have the discriminator column in the SELECT. (so far it's right)
ex: SELECT ID, DISC ... FROM PERSON
But if the query is (at least applicable on MySQL) "SELECT entity.* FROM PERSON entity ..." DN also requires to have the discriminator while it is returned by the query.

-2- Query comparing dates with > operator
SELECT P.* FROM PERSON P WHERE P.CREATION > P.DELETION
This works fine on the database but DN claims not supporting this > operator on temporals.


Are there any solution to desactivate the native query parsing ?


--
Stephane


Andy
 

http://www.datanucleus.org:15080/products/accessplatform_5_2/jpa/query.html#sql_syntax_checks