Hibernate version: Not sure
database: DB2 for Linux V9.5
Other: jboss-4.2.2

Excuse my ignorance regarding Hibernate, but I am a DBA not a developer. The applicaiton I support is sumitting SQL syntax via Hibernate that is slightly different for each applicaton server. The basic SQL tables and columns are the same, but the column "labels" are sometimes different.

For example :

SELECT EMPNO AS EMPNO83_3 FROM EMPLOYEE from one app server
SELECT EMPNO AS EMPNO83_4 FROM EMPLOYEE from a different app server

This causes DB2 to have to store a different cache of each SQL that is not identical in syntax. In our case we have over 50 applicaiton servers, so that means I have to have 50 times as much SQL package cache to be able to reuse the compiled SQL.

When working at other companies using Hibernate, I never saw this. Does anyone know how to fix this so that every SQL is the exactly the same (if it really is the same) regardless of what app server it comes from?

My developers don't know why this is happening.

Someone posted a very simlar problem here:

http://forum.hibernate.org/viewtopic.ph ... 16#2398516