[jboss-user] [jBPM] - Re: [JDBCExceptionReporter] Large Objects may not be used in auto-commit mode.

Nick Tan [http://community.jboss.org/people/missedone] created the discussion "Re: [JDBCExceptionReporter] Large Objects may not be used in auto-commit mode." To view the discussion, visit: http://community.jboss.org/message/611957#611957 -------------------------------------------------------------- Thanks, this change bypass the "Large Objects' Error but I currently encounter another issue about "JPA, @Lob and PostgreSQL oid", I mean with the JPA, what the 'workItemByteArray' returned actually is the oid bytearray, but not the raw content data bytearray, i'm still investigate on it.. some reference: [1] http://virgo47.wordpress.com/2008/06/13/jpa-postgresql-and-bytea-vs-oid-t... http://virgo47.wordpress.com/2008/06/13/jpa-postgresql-and-bytea-vs-oid-t... [2] http://jdbc.postgresql.org/documentation/publicapi/org/postgresql/largeob... http://jdbc.postgresql.org/documentation/publicapi/org/postgresql/largeob... [3] http://snipplr.com/view/53917/postgres-how-to-read-oid-value-using-jdbc-api/ http://snipplr.com/view/53917/postgres-how-to-read-oid-value-using-jdbc-api/ the bottom line is, use the PostgreSQL JDBC driver to access the real data bytearray with oid, i think -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/611957#611957] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]