JDBC-Based Persistence Properties (Sun GlassFish Message Queue 4.4 Administration Guide)

Sun GlassFish Message Queue 4.4 Administration Guide

JDBC-Based Persistence Properties

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

Table 17–7 Broker Properties for JDBC-Based Persistence


Property	Type	Default Value	Description
`imq.persist.jdbc.dbVendor`	String	None	Name of database vendor for persistent data store: `hadb`: HADB (Sun Microsystems, Inc.) `derby`: Java DB (Sun Microsystems, Inc.) `oracle`: Oracle (Oracle Corporation) `mysql`: MySQL (Sun Microsystems, Inc.) `postgresql`: postgreSQL
`imq.persist.jdbc.connection.limit`	Integer	`5`	The maximum number of connections that can be opened to the database.
`imq.persist.jdbc.vendorName.driver`	String	per vendor	Java class name of JDBC driver, if needed, for connecting to database from vendor `vendorName`
`imq.persist.jdbc.vendorName.opendburl`	String	None	URL for connecting to existing database from vendor `vendorName` Applicable when driver is used to connect to database.
`imq.persist.jdbc.vendorName.createdburl` [Optional]	String	None	URL for creating new database from vendor `vendorName` Applies for embedded database, such as Java DB.
`imq.persist.jdbc.vendorName.closedburl`	String	None	URL for closing connection to database from vendor `vendorName` Applies for some embedded databases, such as Java DB.
`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`
`imq.persist.jdbc.vendorName.tableoption`	String	None	Vendor-specific options passed to the database when creating the table schema.