My problem was some select SQL's in the application were required to have the DB2 specific "WITH UR" (uncomitted/dirty reads) clause to avoid deadlocks. It is only a few of the transactions of course that uses this. However all transactions use the same connectionpool, so I could not just set the isolation level in the properties since this then would apply to all connections.

On a Query object I added so additional SQL will be appended to the end of the SQL. So it can be used with other vendor specific SQL that is added to the end of an SQL.

Query
public Query setAdditionalSQLToAppend(String additionalSQL);

It is quite similar to the comment field that is added to the front of the SQL, but without the /* */

My question is if this would have any interest to the community if I submit this patch to 3.2 ?