RE: INSERT fails using JDBC native driver

[Buck Calabro <buck.calabro@xxxxxxxxxxxxxxxxx>]

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: joe@zappie.net
+---