The AS400JDBCConnection class provides a JDBC connection to a specific DB2® for IBM® i database.
Use DriverManager.getConnection() to create new AS400JDBCConnection objects. For more information, see Registering the JDBC driver.
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 IBM Toolbox for Java JDBC properties for a complete list of properties supported by the AS400JDBCDriver.
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 JDBC support for Version 5 Release 3.
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
.
Using the AS400JDBCConnection class, you can do the following:
If you use JDBC 3.0 and connect to a server running IBM i 5.2 or later, you can use AS400JDBCConnection to perform the following actions: