1.1.1

Restrictions for Managing JAR Files Using System Procedures
To use the SQLJ.INSTALL_JAR or SQLJ.REPLACE_JAR procedure, the JAR file path must be available on
the specific SQLFire data store to which the client is connected. If the client connects directly to a known SQLFire
server, then only that server requires the JAR file to be available at the specified path when the procedure executes.
However, if the client connects using a locator then it may be connected to any available server in the distributed
system. In this case, the JAR file path should be available to all members of the SQLFire cluster (for example,
from a fileshare location such as z:\) to ensure that the procedure can execute.
Note: If you cannot provide a common JAR location to ensure that SQLJ.INSTALL_JAR or
SQLJ.REPLACE_JAR executes, use the sqlf commands described in Manage JAR Files in SQLFire on
page 126 or manually inject the JAR file into the SQLFire system as described in Installing a JAR File
Directly into SYS.JARS on page 128 .
Installing a JAR File with SQLJ.INSTALL_JAR
To install a JAR file to SQLFire, connect to a SQLFire member and execute the install_jar procedure. For
example, the following procedure installs the tours.jar file to the APP schema, from a fileshare location:
call sqlj.install_jar(
'z:\tours.jar', 'APP.Sample1', 0)
Note: The final integer argument specifies an alias for the JAR file. However, SQLFire ignores this
argument, so it is normally set to 0.
The second argument defines an identifier for the JAR file in the SQLFire system. You must include a schema
name to qualify the identifier. You can use the JAR identifier at a later time with the SQLJ.REPLACE_JAR and
SQLJ.REMOVE_JAR procedures.
You can optionally specify a quoted identifier for the SQLFire JAR name:
call sqlj.install_jar(
'z:\tours.jar', 'APP."Sample2"', 0)
After installing the JAR, SQLFire automatically loads the JAR file classes into its class loader; you do not need
to explicitly load classes after installing the JAR. The JAR and its classes are available to all members of the
SQLFire distributed system, including those that later join the cluster.
Note: After you install a JAR file, you cannot modify any of the individual classes or resources within
the JAR file. Instead, you must replace the entire JAR file to update a class.
Installing a JAR File Directly into SYS.JARS
If the JAR file to install is not available to every data store member in the SQLFire cluster, inject the JAR file
directly from the client into the SQLFire system using Java code.
The SYS.JARS table stores installed JAR files, and you can insert a new JAR into this table as a byte[] value.
For example, an application can use code similar to the following to add a JAR to the SYS.JARS table:
byte[] jarBytes = getJarBytes(myjar);
String sql = "insert into SYS.JARS values(?, ?)";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, "app.sample1");
ps.setBytes(2, jarBytes);
ps.executeUpdate();
vFabric SQLFire User's Guide128
Developing Applications with SQLFire