1.1

Example
The following code adds an example listener implementation to a table. Example Listener
Implementation on page 192 shows the listener code.
Connection conn = getConnection();
CallableStatement cs = conn
.prepareCall("CALL SYS.ADD_LISTENER(?,?,?,?,?,?)");
cs.setString(1, “id”);
cs.setString(2, “test”);
cs.setString(3, “table”);
cs.setString(4, “testpackage.EventCallBackListenerImpl”);
cs.setString(5, “emp.ftable:3”);
cs.setString(6, null);
cs.execute();
SYS.ATTACH_LOADER
Attach a rowloader implementation to a table.
Syntax
SYS.ATTACH_LOADER
(
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()
)
SCHEMA_NAME
The schema of the table where the loader will be attached.
TABLE_NAME
The table name to which the loader will be attached.
FUNCTION_STRING
The fully-qualified class name of the Using a RowLoader to Load Existing Data implementation.
INIT_INFO_STR
A string of initialization parameter values to pass to the init method of the loader implementation
after calling its default constructor.
Example
The following code adds an example loader implementation to a table.
Connection conn = getConnection();
CallableStatement cs = conn
.prepareCall("CALL SYS.ATTACH_LOADER(?,?,?,?)");
cs.setString(1, “test”);
cs.setString(2, “table”);
cs.setString(3, “testpackage.RowLoaderImpl”);
cs.setString(4, null);
cs.execute();
SYS.ATTACH_WRITER
Attach a writer to a table.
vFabric SQLFire User's Guide598
vFabric SQLFire Reference