Because external Java stored routines are based on the architecture of running a normal Java program on a DBMS server, the methods of testing and debugging them are the same as for Java applications.

After creating a Java program, you need to test it and debug it so that the Java program runs successfully as a stored procedure or stored function. This section describes the points to be observed when testing and debugging a Java program.

Organization of this section

9.5.1 Java program for a Java stored procedure

9.5.2 Java program for a Java stored function