1.1

INITPARAMS
Specify initialization parameters to pass to the init() method of the AsyncEventListener
implementation. SQLFire passes the single string of initialization parameters when you execute
the CREATE ASYNCEVENTLISTENER statement. You must include the INITPARAMS
argument, even if it defines no parameters (INITPARAMS '').
The built-in DBSynchronizer requires two comma-separated parameters and has two optional
parameters. The initialization string uses the format: 'db-driver-class,db-url[,user,password]':
• db-driver-class specifies the fully-qualified class name of the JDBC driver to use for
connecting to the external database.
• db-url specifies the connection string to use to connect to the external database.
• [,user,password] optionally specifies the username and password to use for the connection.
Specify the ,user,password parameters to ensure that the password value never appears in
external exception messages.
If instead you include the username and password as part of the db-url (for example by
appending ?user=username&password=password), SQLFire attempts to mask password
values in exception messages by matching common patterns such as password=..., password=..,
or pwd=... However, the actual value may appear in exception messages under certain
circumstances.
For example, to connect to an external Apache derby database, you would specify a
DBSynchronizer INITPARAMS string similar to
'org.apache.derby.jdbc.EmbeddedDriver,jdbc:derby:newDB;create=true;'.
MANUALSTART
A boolean value that specifies whether you need to manually start the listener with
SYS.START_ASYNC_EVENT_LISTENER on page 601. If you do not supply a value, the
default is "true" and you must start the listener manually using
SYS.START_ASYNC_EVENT_LISTENER on page 601.
ENABLEBATCHCONFLATION
A Boolean value that determines whether SQLFire should conflate messages. The default is
false.
BATCHSIZE
The maximum number of messages that a batch can contain. The default is 100 messages.
BATCHTIMEINTERVAL
The maximum number of milliseconds that can elapse between sending batches. The default
is 1000 milliseconds.
ENABLEPERSISTENCE
A Boolean value that determines whether SQLFire persists the event queue to disk for high
availability. The default is "False."
DISKSTORENAME
The named disk store to use for persisting the event queue. If you specify a value, the named
disk store must exist. If you specify a null value, SQLFire uses the default disk store for
persistence.
MAXQUEUEMEMORY
The maximum amount of memory in megabytes that the queue can consume before overflowing
to disk. The default is 100 megabytes.
ALERTTHRESHOLD
463
SQL Language Reference