1.1.1

Table Of Contents

Note: Because the associated listener conﬁguration does not have to be available at the time you

create the table, SQLFire does not display an error message if the speciﬁed listener name does not yet

exist. Make sure that you use the same listener name with both the CREATE ASYNCEVENTLISTNER

command and the CREATE TABLE command.

8. Execute DML and verify synchronization

After you associate the table with a DBSynchronizer implementation, SQLFire queues DML operations that

are executed against the table to the third-party database speciﬁed in the DBSynchronizer INITPARAMS

argument. For example, while still in sqlf, execute:

sqlf> insert into sqlftest values (1, '1st Entry');

Then return to the mysql client and verify that the DML was propagated to your database:

mysql> select * from sqlfdb.sqlftest;

vFabric SQLFire User's Guide208

Caching Data with vFabric SQLFire