Add the jar file or files to the database

Use a set of procedures to install, replace, and remove jar files in a database. When you install a jar file in a database, you give it a Derby jar name, which is an SQL92Identifier.

Note:

Once a jar file has been installed, you cannot modify any of the individual classes or resources within the jar file. Instead, you must replace the entire jar file.

See the Derby Tools and Utilities Guide for reference information about the utility and complete syntax.

-- SQL  statement
CALL sqlj.install_jar(
    'tours.jar', 'APP.Sample1', 0)
 
-- SQL  statement
-- using a quoted identifier for the 
-- Derby  jar name
CALL sqlj.install_jar(
    'tours.jar', 'APP."Sample2"', 0)

-- SQL  statement
CALL sqlj.remove_jar(
    'APP.Sample1', 0)

-- SQL  statement
CALL sqlj.replace_jar(
    'c:\myjarfiles\newtours.jar', 'APP.Sample1')