Re: JDBC connection options on URL

Hi Joe,

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

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rzaha/transiso.htm


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'"
<java400-l@xxxxxxxxxxxx>
Sent: Tuesday, September 16, 2008 7:39 PM
Subject: RE: JDBC conncetion options on URL

The properties for v5r4 are here:

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzahh/jdbcproper
ties.htm#jdbcproperties

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

See
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzahh/jdbcdrvr.h
tm under "Example: Connecting to the server database and using a uniform
resource locator (URL) to specify properties" for specifying the
properties
on the URL.

HTH,
Gary

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx

[mailto: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.

Thanks!

Joe