Sun Java System Message Queue 4.1 Administration Guide

JDBC-Based Persistence Properties

Table 14–6 lists the broker properties related to JDBC-based persistence. The imq.persist.jdbc.dbVendor property identifies the database vendor being used for the cluster’s persistent data store; all of the remaining properties are qualified by this vendor name.

Table 14–6 Broker Properties for JDBC-Based Persistence

Property 

Type 

Default Value 

Description 

imq.persist.jdbc.dbVendor

String 

derby

Name of database vendor for persistent data store:  

    hadb: HADB (Sun Microsystems, Inc.)


    derby: Java DB (Derby, Apache Software Foundation)


    oracle: Oracle Real Application Cluster (Oracle Corporation)


    mysql: MySQL (MySQL AB)


imq.persist.jdbc.vendorName.driver

String 

None 

Java class name of JDBC driver for connecting to database from vendor vendorName

imq.persist.jdbc.vendorName.opendburl

String 

None 

URL for connecting to existing database from vendor vendorName

imq.persist.jdbc.vendorName.createdburl [Optional]

String 

None 

URL for creating new database from vendor vendorName

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

imq.persist.jdbc.vendorName.closedburl

String 

None 

URL for closing connection to database from vendor vendorName

imq.persist.jdbc.vendorName.user

String 

None 

User name, if required, for connecting to database from vendor vendorName

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

imq.persist.jdbc.vendorName.needpassword

Boolean 

false

Does database from vendor vendorName 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.vendorName.password, [Should be used only in password files]

String 

None 

Password, if required, for connecting to database from vendor vendorName

imq.persist.jdbc.vendorName.property.propName

String 

None 

Vendor-specific property propName for database from vendor vendorName