Re: JDBC conncetion options on URL

[Simon Coulter <shc@xxxxxxxxxxxxxxxxx>]

On 17/09/2008, at 9:24 AM, Joe Pluta wrote:

> 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.


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

Just where one might expect to find it.

Examples of use are at:

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzahh/ 
jdbcdrvr.htm#jdbcdrvr

which is, admittedly, slightly obscure.

Regards,
Simon Coulter.
--------------------------------------------------------------------
   FlyByNight Software         OS/400, i5/OS Technical Specialists

   http://www.flybynight.com.au/
   Phone: +61 2 6657 8251   Mobile: +61 0411 091 400        /"\
   Fax:   +61 2 6657 8251                                   \ /
                                                             X
                 ASCII Ribbon campaign against HTML E-Mail  / \
--------------------------------------------------------------------