Database access from Java programs
Java™ programs can access database files in several ways.
- Accessing your IBM i database with the Java JDBC driver
The Java JDBC driver, also known as the "native" driver, provides programmatic access to IBM i database files. Using the Java Database Connectivity (JDBC) API, applications written in the Java language can access JDBC database functions with embedded Structured Query Language (SQL), run SQL statements, retrieve results, and propagate changes back to the database. The JDBC API can also be used to interact with multiple data sources in a distributed, heterogeneous environment. - Accessing databases using DB2 SQLJ support
DB2® Structured Query Language for Java (SQLJ) support is based on the SQLJ ANSI standard. The DB2 SQLJ support is contained in the IBM Developer Kit for Java. DB2 SQLJ support allows you to create, build, and run embedded SQL for Java applications. - Java SQL routines
Your system provides the ability to access Java programs from SQL statements and programs. This can be done using Java stored procedures and Java user-defined functions (UDFs). The IBM i supports both the DB2 and SQLJ conventions for calling Java stored procedures and Java UDFs. Both Java stored procedures and Java UDFs can use Java classes that are stored in JAR files. The IBM i uses stored procedures defined by the SQLJ Part 1 standard to register JAR files with the database.
Parent topic: IBM Developer Kit for Java