John Caruso wrote: >Can anyone tell me why the following code works when the table is >created in an SQL collection, but not in a normal library? It fails >on the INSERT. It appears that the native JDBC driver is using >a transaction isolation level other than the default of NONE. I've >tried specifically setting it to NONE (see commented out code) > only to receive this error: An SQL collection has the SQL catalog built in it by default. When you create a file in an SQL collection it is journalled by default. I believe that if you start journalling for the file in the DB2 library (is there a better name?) your INSERT will work OK. Commitment control requires journalling. Buck Calabro Aptis; Albany, NY +--- | This is the JAVA/400 Mailing List! | To submit a new message, send your mail to JAVA400-L@midrange.com. | To subscribe to this list send email to JAVA400-L-SUB@midrange.com. | To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com. | Questions should be directed to the list owner: firstname.lastname@example.org +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.