Connect to the database from Interactive SQL.

Ensure the JDBCExample class has been installed.

For more information about installing the Java examples classes, see Preparing for the JDBC examples.

Define a stored procedure named JDBCInsert that acts as a wrapper for the JDBCExample.Insert method in the class:

CREATE PROCEDURE JDBCInsert(IN arg1 INTEGER, IN arg2 CHAR(50))
  EXTERNAL NAME 'JDBCExample.Insert(ILjava/lang/String;)V'
  LANGUAGE JAVA;

Call the JDBCExample.Insert method as follows:

CALL JDBCInsert( 202, 'Southeastern Sales' );

The Insert method causes the InsertDynamic method to be invoked.

Confirm that a row has been added to the Departments table.

SELECT * FROM Departments;

The example program displays the updated contents of the Departments table in the database server messages window.

There is a similar method in the example class called DeleteDynamic that shows how to delete the row that has just been added.

Define a stored procedure named JDBCDelete that acts as a wrapper for the JDBCExample.Delete method in the class:

CREATE PROCEDURE JDBCDelete(IN arg1 INTEGER)
  EXTERNAL NAME 'JDBCExample.Delete(I)V'
  LANGUAGE JAVA;

Call the JDBCExample.Delete method as follows:

CALL JDBCDelete( 202 );

The Delete method causes the DeleteDynamic method to be invoked.

Confirm that the row has been deleted from the Departments table.

SELECT * FROM Departments;

The example program displays the updated contents of the Departments table in the database server messages window.