Bug 900356 (JBPAPP6-971)

project_key: JBPAPP6

The stacktrace is as follows:

org.hibernate.exception.GenericJDBCException: [jcc][10429][12554][4.12.55] A processing error occurred on the server which resulted in an unrecoverable error.
Please set deferPrepares property to false and re-establish the connection.  If the problem still persists, please contact support. ERRORCODE=-4225, SQLSTATE=24514
	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)

But as per log the original Error message should be:

11:26:21,025  WARN SqlExceptionHelper:143 - SQL Error: -401, SQLState: 42818
11:26:21,026 ERROR SqlExceptionHelper:144 - DB2 SQL Error: SQLCODE=-401, SQLSTATE=42818, SQLERRMC==, DRIVER=4.12.55



Query at error for example:

select componentt0_.id as id2953_0_, componentt0_.REV as REV2953_0_, sequenceid1_.REV as REV2954_1_, componentt0_.REVTYPE as REVTYPE2953_0_, componentt0_.str1 as str4_2953_0_, componentt0_.str2 as str5_2953_0_, componentt0_.comp1_MOD as comp6_2953_0_, sequenceid1_.REVTSTMP as REVTSTMP2954_1_ from CompTest_AUD componentt0_, REVINFO sequenceid1_ where componentt0_.id=? and componentt0_.comp1_MOD=? and componentt0_.REV=sequenceid1_.REV order by componentt0_.REV asc

Always this issue happens while trying to select/load a resultset from the DB (mostly from the XYZ_AUD table that was created by Envers)


Marking that the exception always occurs at StandardSQLExceptionConverter.java:54 not sure if the following is actual reason:
w.r.t http://publib.boulder.ibm.com/infocenter/wsdoc400/v6r0/index.jsp?topic=/com.ibm.websphere.iseries.doc/info/ae/ae/rtrb_db2probs.html
"To avoid receiving this exception, choose one of the following options:

    * Set the deferPrepares property to false in the data source configuration.
    * Do not use the DB2 universal JDBC type 4 driver if your table has any VARCHAR FOR BIT DATA or LONG VARCHAR FOR BIT DATA columns. Use the DB2 legacy CLI-based JDBC driver to persist the data. Refer to DB2 V8.1 readme for more details."---We can't change the driver but will tweaking the data type help?