Writing a Java User-Defined Routine

Java UDRs can use the following packages, interfaces, classes, and methods:

• Java packages

  UDRs can use all the basic nongraphic Java packages that are in the JDK. That is, UDRs can use java.util.*, java.io.*, java.net.*, java.rmi.*, and so on. UDRs cannot use java.awt.*, java.applet.* and other user-interface packages. For more information on these packages, see the JDK documentation.

• Java Database Connectivity (JDBC) 1.0 API

  UDRs can use the JDBC 1.0 API to access the database. For more information, see JDBC 1.0 API.

  The $INFORMIXDIR/extend/krakatoa/examples.tar file of online examples includes a sample of JDBC in a UDR in JDBC.java.

• Informix JDBC extensions

  UDRs can also use Informix extensions to JDBC 1.0 to access some JDBC 2.0 functionality. For more information, see The IBM Informix JDBC Driver.

• Informix extensions for UDRs written in Java code

  Certain Informix extensions are available to applications that need to exploit the capabilities of the database server. The Informix extensions reside in the com.informix.udr package.

The Informix com.informix.udr package provides extensions to SQLJ that allow applications to exploit the capabilities of Dynamic Server. Such extensions include logging, tracing, iterator support, and invocation-state management.