imq.persist.jdbc.brokerid

Not required for PointBase embedded version 

(Optional) Broker instance identifier

Must be an alphanumeric string of no more thann - 12 characters, where n is the maximum table name length allowed by the database.

This identifier is appended to database table names to make them unique in the case where more than one broker instance is using the same database as a persistent data store. It is usually unnecessary for an embedded database, which stores data for only one broker instance.  

imq.persist.jdbc.driver

com.pointbase.jdbc.jdbcUniversalDriver

Java class name of JDBC driver for connecting to database

imq.persist.jdbc.opendburl

jdbc:pointbase:embedded:dbName;

database.home=

   .../instances/instanceName/dbstore

URL for opening connection to existing database

imq.persist.jdbc.createdburl

jdbc:pointbase:embedded:dbName;

new,database.home=

   .../instances/instanceName/dbstore

(Optional) URL for creating new database

Needed only if the database will be created using the Message Queue Database Manager utility (imqdbmgr).

imq.persist.jdbc.closedburl

Not required for PointBase 

(Optional) URL for closing database connection

imq.persist.jdbc.user

(Optional) User name for opening database connection, if required

For security reasons, the value can instead be specified using command line options imqbrokerd -dbuser and imqdbmgr -u.

imq.persist.jdbc.needpassword

(Optional) Does database require a password for broker access?

If true, the imqbrokerd and imqdbmgr commands will prompt for a password, unless you use the -passfile option to specify a password file containing it.

imq.persist.jdbc.password [Should be used only in password files]

(Optional) Password for opening database connection

imq.persist.jdbc.table.IMQSV35

CREATE TABLE ${name}

(STOREVERSION INTEGER NOT NULL,

 BROKERID VARCHAR(100))

SQL command to create version table

imq.persist.jdbc.table.IMQCCREC35

CREATE TABLE ${name}

(RECORDTIME BIGINT NOT NULL,

 RECORD BLOB(10k))

SQL command to create configuration change record table

imq.persist.jdbc.table.IMQDEST35

CREATE TABLE ${name}

(DID VARCHAR(100) NOT NULL,

 DEST BLOB(10k),

 primaryKey(DID))

SQL command to create destination table

imq.persist.jdbc.table.IMQINT35

CREATE TABLE ${name}

(CUID BIGINT NOT NULL,

 INTEREST BLOB(10k),

 primaryKey(CUID))

SQL command to create interest table

imq.persist.jdbc.table.IMQMSG35

CREATE TABLE ${name}

(MID VARCHAR(100) NOT NULL,

 DID VARCHAR(100),

 MSGSIZE BIGINT,

 MSG BLOB(1m),

 primaryKey(MID))

SQL command to create message table

The default maximum length for the MSG column is 1 megabyte (1m). If you expect to have messages larger than this, set the length accordingly. If the tables have already been created, you must re-create them to change the maximum message length.

imq.persist.jdbc.table.IMQPROPS35

CREATE TABLE ${name}

(PROPNAME VARCHAR(100) NOT NULL,

 PROPVALUE BLOB(10k),

 primaryKey(PROPNAME))

SQL command to create property table

imq.persist.jdbc.table.IMQILIST35

CREATE TABLE ${name}

(MID VARCHAR(100) NOT NULL,

 CUID BIGINT,

 DID VARCHAR(100),

 STATE INTEGER,

 primaryKey(MID, CUID))

SQL command to create interest state table

imq.persist.jdbc.table.IMQTXN35

CREATE TABLE ${name}

(TUID BIGINT NOT NULL,

 STATE INTEGER,

 TSTATEOBJ BLOB(10K),

 primaryKey(TUID))

SQL command to create transaction table

imq.persist.jdbc.table.IMQTACK35

CREATE TABLE ${name}

(TUID BIGINT NOT NULL,

 TXNACK BLOB(10k))

SQL command to create transaction acknowledgment table