Hi,
I am a user not a GlassFish developer. please accept my apologies.
There are a few bugs on the topic of case sensitivity with native
queries. Some are closed, others still open. The overall status
appears to be inconsistent to me.
The dilemma can possibly be best understood by reading a 2008 post:
http://kr.forums.oracle.com/forums/thread.jspa?threadID=612380
"primary key detected to be null, but it isn't" (I can really
understand Adam's frustration and I feel sorry for him)
I have hit these issues myself multiple times while working only with
two popular database engines in different ways (Derby and Postgresql).
I found that bugs were closed as duplicates of
https://glassfish.dev.java.net/issues/show_bug.cgi?id=1442
which was closed fixed in 2006.
Example:
https://glassfish.dev.java.net/issues/show_bug.cgi?id=1507
"Native query fails using PostgreSQL"
Three years later I am hitting this closed bug id=1507 with the Java
EE bundled with the latest NetBeans 6.7.1. In fact nothing works as
expected in this area. It is a minefield.
I hope that someone can shed some light on this. I applied for
observer status on these bugs but it hasn't worked for me yet.
Best regards
Bernard