imq.persist.jdbc.dbVendor
|
String
|
None
|
Name of database vendor for persistent data store:
hadb: HADB (Oracle Corporation)
derby: Java DB (Oracle Corporation)
oracle: Oracle (Oracle Corporation)
mysql: MySQL (Oracle Corporation)
postgresql: postgreSQL
|
imq.persist.jdbc.connection.reaptime
|
Integer
|
300
|
The interval in seconds between attempts to close unnecessary database
connections.
|
imq.persist.jdbc.max_connections
|
Integer
|
5
|
The maximum number of connections that should be opened to the database.
The Message Queue database connection pool manager uses this value as a guide
when creating new connections to the database.
|
imq.persist.jdbc.min_connections
|
Integer
|
5
|
The number of connections that are opened to the database when the Message Queue database
connection pool is initialized, and the minimum number of connections that
are to be kept open when unnecessary connections are closed.
|
imq.persist.jdbc.connection.timeoutIdle
|
Boolean
|
true
|
Should the Message Queue database connection pool manager considers
the age of a connection in the pool?
When true, the pool manager operates as follows:
-
When closing unnecessary database connections at each imq.persist.jdbc.connection.reaptime interval, the pool manager destroys any connections in the pool
that have been idle for a period longer than imq.persist.jdbc.connection.reaptime seconds, and attempts to replace them with new connections.
-
When getting a connection from the pool, the pool manager
destroys the connection if it has been idle for a period longer than imq.persist.jdbc.connection.reaptime seconds and replaces it with a new connection.
|
imq.persist.jdbc.connection.validateOnGet
|
Boolean
|
true for brokers in enhanced clusters; otherwise, false
|
Should the Message Queue database connection pool manager perform extra
validation when it gets a connection from the pool?
Normally, the pool manager validates a connection it gets from the pool
by checking whether the connection is closed and, if possible, by checking
whether a connection error has occurred on the connection.
When this property is set to true, the pool manager
performs these additional validation checks:
-
For JDBC 4 connections, check whether the connection
is valid.
-
Make the validation query specified
by imq.persist.jdbc.connection.validationQuery on the
connection.
|
imq.persist.jdbc.connection.validationQuery
|
String
|
per vendor
|
The validation query for the Message Queue database connection pool
manager to use when imq.persist.jdbc.connection.validateOnGet is
set to true.
|
imq.persist.jdbc.connection.limit
|
Integer
|
5
|
The maximum number of connections that can be opened to the database.
This property is deprecated and may become unsupported in a future release
of Message Queue.
|
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.
|