Data Direct DB2 JDBC driver should allow update/insert SQL statement for tables in AS400 which are not journalled. - Forum - DataDirect Connect - Progress Community

Data Direct DB2 JDBC driver should allow update/insert SQL statement for tables in AS400 which are not journalled.

 Forum

Data Direct DB2 JDBC driver should allow update/insert SQL statement for tables in AS400 which are not journalled.

  • Data Direct DB2 JDBC driver should allow update/insert SQL statement for tables in AS400 which are not journalled.. IBM JDBC driver jt400 does provide this functionality. I request this enhancement on JDBC driver for DB2 by Data Direct.

  • In order to execute update/insert SQL to non-journalled tables with the DataDirect DB2 JDBC driver, you'll need to set the transaction isolation on the connection to TRANSACTION_NONE.  The IBM documentation makes a note on how the JDBC defined transaction isolation levels do not exactly line up with the way transaction isolation levels are defined for iSeries. See the section titled "Transaction isolation levels between the JDBC specification and the iSeries platform" in the following link: publib.boulder.ibm.com/.../index.jsp


    Please let us know if you continue to experience a problem with this functionality after setting this transaction isolation level.