Re: SQL Error - how to track

["Richard Dettinger" <cujo@xxxxxxxxxx>]

For the Native JDBC driver, properties available are similar but different
(sorry about that).  Our online manual has the properties you can use up to
the point that the manual gets put together.  The URL for that is
http://publib.boulder.ibm.com/pubs/html/as400/v5r1/ic2924/index.htm?info/rzaha/conprop.htm.

Because we do more work in the Native JDBC driver by PTF, this list can get
out of date over time.  There is an entry in the Native JDBC faq for which
connection properties are supported which ends up eventually becoming a
part of the next version of the manual.  I would suggest using the JDBC faq
for getting the most recent list always (and of course, then putting on the
latest JDBC PTFs so that you are sure to have the property).  The FAQ is at
http://www.as400.ibm.com/developer/jdbc/Faqs/JDBCFAQ.html.  Question B8
refers to the connection properties.

If you compare the two to get an idea of what is available in each place,
you will see that we have been pretty busy adding customization features to
v5r1 (the faq info always refers to the latest release of the product) and
that some of the properties that have existed in the last have been
enhanced (like the libraries property which now works more like its name
suggests).

Happy hunting to you.

Regards,

Richard D. Dettinger
AS/400 Java Data Access Team

"Biologists have a special word for stability -- dead"

                Larry Wall
                Open Source Developers Journal
                Issue 1, Jan  2000


Dave Wall/Rochester/IBM@IBMUS@midrange.com on 09/07/2001 09:22:29 AM

Please respond to java400-l@midrange.com

Sent by:  java400-l-admin@midrange.com


To:   java400-l@midrange.com
cc:
Subject:  Re: SQL Error - how to track




The JDBC section of the Toolbox programmers guide has a list of properties.
A direct link to the section is at

http://publib.boulder.ibm.com/pubs/html/as400/v5r1/ic2924/info/rzahh/javadoc/JDBCProperties.html#driver



David Wall
AS/400 Toolbox for Java




                    BMIROW@aol.com
                    Sent by:                 To:
<java400-l@midrange.com>
                    java400-l-admin@mi       cc:
                    drange.com               Subject:     Re: SQL Error -
how to track


                    09/07/2001 08:50
                    AM
                    Please respond to
                    java400-l





Is there documention of all the possible options that can be on the
DriverManager. ie errors=full, date=iso,etc.

Thanks Barry
_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.





_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.