1.1

The SQLFire name of the JAR file, qualified by the schema name. (This should
correspond to the name that you specified in the SQLJ.INSTALL_JAR command.)
Two examples:
MYSCHEMA.Sample1
-- a delimited identifier.
MYSCHEMA."Sample2"
QUALIFIED_JAR_NAME
Example
-- SQL statement
CALL sqlj.replace_jar('c:\myjarfiles\newtours.jar', 'APP.Sample1')
SQLFire unloads the JAR classes that were associated with the "APP.Sample1" installation, then installs and
loads the classes in c:\myjarfiles\newtours.jar.
Callback Configuration Procedures
Callback configuration procedures are SQLFire-specific procedures for configuring listeners.
SYS.ADD_LISTENER
Attach an event listener (an implementation of the EventCallBack interface) to a table.
Syntax
SYS.ADD_LISTENER
(
IN ID VARCHAR(128) NOT NULL,
IN SCHEMA_NAME VARCHAR(128) NOT NULL,
IN TABLE_NAME VARCHAR(128) NOT NULL,
IN FUNCTION_STRING VARCHAR() NOT NULL,
IN INIT_INFO_STR VARCHAR(),
IN SERVER_GROUPS VARCHAR()
)
ID
A unique identifier for this listener.
SCHEMA_NAME
The schema of the table to which the listener is added.
TABLE_NAME
Table name to which the listener is added.
FUNCTION_STRING
The fully-qualified class name of the EventCallback implementation.
INIT_INFO_STR
A string of initialization parameter values to pass to the init method of the listener
implementation after calling its default constructor.
SERVER_GROUPS
A comma-separated list of server groups on which SQLFire installs the listener. If this parameter
is null, SQLFire installs the listener to all data stores (SQLFire members that host data).
597
SQL Language Reference