Overall there are two options: DRDA/DB2 Connect, and the Java Toolbox.
DRDA/DB2 Connect JDBC driversThree different ones for different situations.
Where the Java is running on IBM i itselfNative DRDA JDBC driver:
- no need to put a jar or zip file in your classpath
If database is *LOCAL (and potentially if database is on another IBM i system, depending on WRKRDBDIRE configuration) there is no need to specify userid/password.
Where the Java is running on other platforms (chargeable)
If DB2 Connect client installed
- COM.ibm.db2.jdbc.app.DB2Driver [note subtle distinction between this and the driver class name mentioned above]
- db2jcc.jar plus separate licence jar
Wherever the Java is runningServed on IBM i by the *DDM TCP/IP server, unless *LOCAL (and unless WRKRDBDIRE is configured to use SNA).
IBM i Toolbox for Java JDBC driver
- com.ibm.as400.access.AS400JDBCDriver [sorry, it really is still called that]