1.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 ''). If you send user credentials in
the initialization parameters, consider encrypting the password using sqlf encrypt-password
with the external option. Your listener will need to use the
AsyncEventHelper.decryptPassword method to decrypt the password before sending
credentials to the outside data source.
The built-in DBSynchronizer requires an initialization string of the format:
'
db-driver-class,db-url[,user=user-name,[,password=plan-text-password|secret=encrypted-password[,transformation=tranformation-name][,keysize=size]]'
In this initialization string:
•
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 JDBC connection string to use to connect to the external database.
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;'.
Note: Any password that you specify in the JDBC URL (for example by
appending ?user=username&password=password) may appear in external
exception messages. 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. To prevent the password from appearing in external
exceptions, omit the username and password from the URL and instead specify
them using the remaining options.
•
[,user=user-name[,password=plan-text-password|secret=encrypted-password[,transformation=tranformation-name][,keysize=size]]'
optionally specifies the username and password to use for the connection. If you do not
specify these options, then SQLFire uses the db-url value is used as-is. If you use the
password option, specify the plaint-text password for the user.
To avoid storing plain-text passwords in scripts used to start DBSynchronizer, you can instead
specify the secret option with the encrypted password for the user. Use the sqlf
encrypt-password command with the external option to encrypt the password. When you
specify an encrypted password with the secret option, you can also include the
transformation and keysize options to match the transformation algorithm and key size that
you specified when encrypting the password with sqlf encrypt-password. If you do not include
these options, the default transformation is AES with a keysize of 128 bits.
477
SQL Language Reference