Begin changeAS400JDBCConnection class

The AS400JDBCConnection class provides a JDBC connection to a specific DB2 UDB for iSeries database. Use DriverManager.getConnection() to create new AS400JDBCConnection objects. For more information, see AS400JDBCDriver.

There are many optional properties that can be specified when the connection is created. Properties can be specified either as part of the URL or in a java.util.Properties object. See JDBC properties for a complete list of properties supported by the AS400JDBCDriver.

Note: A connection may contain at most 9999 open statements.

AS400JDBCConnection includes support for savepoints and statement-level holdability, and limited support for returning auto-generated keys. For more information about these and other enhancements, see Enhancements to Toolbox for Java JDBC support.

To use Kerberos tickets, set only the system name (and not the password) on your JDBC URL object. The user identity is retrieved through the Java Generic Security Services (JGSS) framework, so you also do not need to specify a user on your JDBC URL. You can set only one means of authentication in an AS400JDBCConnection object at a time. Setting the password clears any Kerberos ticket or profile token. For more information, see the AS400 class and J2SDK, v1.4 Security Documentation Link outside information center.

Using the AS400JDBCConnection class, you can do the following:

If you are using JDBC 3.0 and connecting to a server running the release after OS/400 V5R1, you can use AS400JDBCConnection to perform the following actions: