Bug 296791

Description Rodrigo Hjort 2009-12-03 06:45:48 EST

When using native queries with PostgreSQL, we need to invoke the following command in order to prevent the error shown in the stack trace.

PostgreSQLPlatform.setShouldIgnoreCaseOnFieldComparisons(true);

Is it possible to initially set "shouldIgnoreCaseOnFieldComparisons" to true in PostgreSQLPlatform class, according to this DBMS behavior?

PS: JPA 1.0's EntityManager.createNativeQuery(String, Class) is being called.


Failing stack trace:

[EL Fine]: 2009-12-02 17:58:53.063--ServerSession(9296972)--Connection(20870565)--Thread(Thread[main,5,main])--select * from auctions where status = ? order by creation desc limit ?
	bind => [0, 20]
[EL Warning]: 2009-12-02 17:58:53.079--UnitOfWork(7437713)--Thread(Thread[main,5,main])--Exception [EclipseLink-6044] (Eclipse Persistence Services - 1.2.0.v20091016-r5565): org.eclipse.persistence.exceptions.QueryException
Exception Description: The primary key read from the row [DatabaseRecord(
	 => 27
	 => 7.7
	 => 2009-11-06 17:04:36.528
	 => null
	 => 0
	 => 2009-11-27 06:50:48.837
	 => 3912.2
	 => 0
	 => 21
	 => 905)] during the execution of the query was detected to be null.  Primary keys must not contain null.
Query: ReadAllQuery(name="newestAuctions" referenceClass=Auction sql="select * from auctions where status = ? order by creation desc limit ?")