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

Buck Calabro
Aptis; Albany, NY
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to
| To subscribe to this list send email to
| To unsubscribe from this list send email to
| Questions should be directed to the list owner:

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.