Chapter 12. Java Programming

Java's “write once run anywhere” philosophy allows you to distribute your application over multiple Intel and UNIX platforms. Java programs can access DB2 databases from standalone applications, applets running within a Web browser, and servlets running from powerful Web application servers such as IBM WebSphere. DB2 also has both static and dynamic SQL programming support for Java, allowing you to maximize your performance, and offering you flexibility as needed.

DB2 provides JDBC drivers to write dynamic SQL programs in Java. Similarly, DB2 comes with an SQLj driver so that you can embed static SQL statements into your Java code. The beauty of SQLj is that it uses JDBC for all of its run-time operations. This allows you to easily write mixed applications that use both JDBC and SQLj. You also can write stored procedures for DB2 using either of these interfaces, as well as external UDFs that you can call in your SQL queries from any client program.