Hi Joe,

In addition to the links Gary sent, you might also review
"Considerations" under "Transaction isolation levels" at:


Joe Sam

Joe Sam Shirah - http://www.conceptgo.com
conceptGO - Consulting/Development/Outsourcing
Java Filter Forum: http://www.ibm.com/developerworks/java/
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International? http://www.jguru.com/faq/I18N
Que Java400? http://www.jguru.com/faq/Java400

----- Original Message ----- From: "Gary L Peskin" <garyp@xxxxxxxxxxxx>
To: "'Java Programming on and around the iSeries / AS400'"
Sent: Tuesday, September 16, 2008 7:39 PM
Subject: RE: JDBC conncetion options on URL

The properties for v5r4 are here:


Have a look at "transaction isolation" to see if that's what you're after.

tm under "Example: Connecting to the server database and using a uniform
resource locator (URL) to specify properties" for specifying the
on the URL.


-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
On Behalf Of Joe Pluta
Sent: Tuesday, September 16, 2008 4:24 PM
To: Java Programming on and around the iSeries / AS400
Subject: JDBC conncetion options on URL

Does anybody have a list of or a link to the various options you can
specify on the connection URL for connecting to DB2 on the i? I'm
specifically talking about the jdbc:as400 URL. I remember there were
things like naming (system vs. SQL) and some others. Specifically I'd
like the option to turn off commitment control, but even more I'd like
to see some examples and a list of the options.



Return to Archive home page | Return to MIDRANGE.COM home page