Application Building Guide

Chapter 4. Building Java Applets and Applications

You can develop Java programs to access DB2 databases with the appropriate Java Development Kit (JDK) for your platform. The JDK includes Java Database Connectivity (JDBC), a dynamic SQL API for Java.

DB2 JDBC support is provided as part of the Java Enablement option on DB2 clients and servers. With this support, you can build and run JDBC applications and applets. These contain dynamic SQL only, and use a Java call interface to pass SQL statements to DB2.

DB2 Java embedded SQL (SQLJ) support is provided as part of the DB2 Software Developer's Kit (DB2 SDK). With DB2 SQLJ support, in addition to DB2 JDBC support, you can build and run SQLJ applets and applications. These contain static SQL and use embedded SQL statements that are bound to a DB2 database.

The SQLJ support provided by the DB2 SDK includes:

• The DB2 SQLJ translator, sqlj, which replaces embedded SQL statements in the SQLJ program with Java source statements, and generates a serialized profile which contains information about the SQL operations found in the SQLJ program.

• The DB2 SQLJ profile customizer, db2profc, which precompiles the SQL statements stored in the serialized profile, customizes them into runtime function calls, and generates a package in the DB2 database. For more information on the db2profc command, see the Command Reference.

• The DB2 SQLJ profile printer, db2profp, which prints the contents of a DB2 customized version of a profile in plain text.

For more information on DB2 programming in Java, refer to the "Programming in Java" chapter in the Application Development Guide.

For the latest, updated DB2 Java information, visit the Web Page at:

   

http://www.software.ibm.com/data/db2/java

[ DB2 List of Books | Search the DB2 Books ]