Kbase 21681: Configuring SonicMQ to Use Progress DB as a Message Store
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
31/01/2002 |
|
SUMMARY:
This Solution applies to SonicMQ 4.x and Progress Database 9.1C14.
It discusses configuration considerations for using SonicMQ with a Progress Database as the message store.
SOLUTION:
After installing SonicMQ, edit the database-related parameters in the broker.ini file. Comment out the set of parameters for Cloudscape Database and edit the ones for the Progress Database as follows:
DB_USER=user-name
DB_PASSWORD=user-password
JDBC_DRIVER=com.progress.sql.jdbc.JdbcProgressDriver
DB_CONNECT=jdbc:jdbcprogress:T:db-host:db-port:db-name
DB_PROPERTIES=progress_jdbc.cfg
user-name must be the same name that is used in the grant resource command. If there are no _USER records, it must be the designated DBA. Otherwise, it must one of the user names registered in the _USER table.
user_password is a password for user-name. If there are no _USER records, is can be an arbitrary non-empty string.
db-host is the name of the computer that is running the Progress Database Server.
db-port is the port number specified with the -S parameter of the PROSERVE command.
db-name is the name of the Progress database.
Set the following environment variables in <sonic-install-dir>\bin\setenv, before running either dbtool.bat or startbr.bat:
set DLC=Progress Database installation directory
set SONICMQ_DBCLASS=%DLC%\java\jdbc.zip
set PATH=%DLC%\bin;%PATH%
If the PATH is not set or is not correct, an attempt to run either the
startbr or dbtool scripts will result in the following error:
java.sql.SQLException: No suitable driver
If the Progress Database Server isn't running or if the DB_CONNECT setting in the broker.ini file isn't correct, an attempt to run either the startbr or dbtool scripts will result in the following error:
[JDBC Progress Driver]: Error in Network Daemon
If the RESOURCE privilege has not been granted for the user specified in the DB_USER parameter, an attempt to run the dbtool script will result in the error message:
[JDBC Progress Driver]: No RESOURCE privileges
When the dbtool script is executed, it has to acquire an exclusive lock on the database schema. If the SonicMQ broker, the Progress sqlexp utility, or any other database application is connected to the database at that time, the lock can't be acquired and will result in the error:
[JDBC Progress Driver]:Failure to acquire exclusive schema lock for
DDL operation.
References to Written Documentation:
Progress Knowledge Base Solution 21680, "Configuring the Progress Database as a SonicMQ Message Store"