[eclipselink-users] Some generated queries fail in PostgreSQL with pgjdb

[Andreas Joseph Krogh <andreak@xxxxxxxxxxxx>]

When I have JPQL-queries like this:

 

SELECT e FROM Entity e WHERE NOT EXISTS(SELECT ms FROM OtherEntity ms WHERE ...)

 

EL generates a query like:

 

SELECT ..... WHERE NOT EXISTS (SELECT $1 FROM my_entity WHERE ...)

 

EL inserts the value Integer(1) for $1.

 

This doesn't work well with the new pgjdbc-ng driver: https://github.com/kdubb/pgjdbc-ng/issues/8

 

The official driver works around the issue but it would be nice if EL generated queries like "SELECT ?::int" for this, instead of "SELECT ?".

 

This won't affect applications and should be a fully compatible change. Any chance to fix this?

 

Thanks.

 

--
Andreas Joseph Krogh <andreak@xxxxxxxxxxxx>      mob: +47 909 56 963
Senior Software Developer / CTO - OfficeNet AS - http://www.officenet.no
Public key: http://home.officenet.no/~andreak/public_key.asc