How to Configure EMS 5.x Server with Database Datastore?

EMS 5.x can be configured to use a database to store messages. The following steps have been tested on a Windows host to configure EMS 5.x with a database. For other platforms, the steps will be similar.

Setup Steps:

1. Install EMS 5.x

2. Download and install JDK 1.5 or later

3. Download and install Hibernate from the link provided at the EMS 5.x download on http:
download.tibco.com.

4. Download the corresponding database JDBC drivers. They can be found on the Internet. The corresponding jar files for the JDBC need to be added to dbstore_classpath in EMS main configuration file.

For example:

1). MySQL InnoDB

MySQL Connector:

mysql-connector-java-5.0.6-bin.jar

2). Microsoft SQL Server

Microsoft JDBC Driver for SQL Server:

sqljdbc.jar

3). Oracle 9i and 10g

Oracle JDBC Thin Driver:

ojdbc14.jar or ojdbc5.jar

4). IBM DB2 Server 8.1 and 9.1

DB2 Universal JDBC Driver:

db2jcc.jar and db2jcc_license_cu.jar

5. Modify the sample EMS main configuration file used for database: c:\tibco\ems\5.0\samples\config\tibemsd-db.conf:

Modify the variables: dbstore_classpath, dbstore_driver_name, dbstore_driver_dialect, jar_library to reflect your own settings and database.

Here is an example which uses the Oracle 10g database:

==============================================

dbstore_classpath = c:\tibco\components\eclipse\plugins\com.tibco.tpcl.org.hibernate_3.2.5.001\hibe rnate3.jar;c:\tibco\components\eclipse\plugins\com.tibco.tpcl.org.com.mchange.c3 p0_0.9.1.001\c3p0-0.9.1.jar;c:\tibco\EMS\5.0\bin\antlr-2.7.6.jar;c:\tibco\EMS\5. 0\bin\asm-attrs.jar;c:\tibco\EMS\5.0\bin\asm.jar;c:\tibco\EMS\5.0\bin\cglib-2.1. 3.jar;c:\tibco\EMS\5.0\bin\commons-collections-2.1.1.jar;c:\tibco\EMS\5.0\bin\co mmons-logging-1.0.4.jar;c:\tibco\EMS\5.0\bin\dom4j-1.6.1.jar;c:\tibco\EMS\5.0\bi n\ehcache-1.2.3.jar;c:\tibco\EMS\5.0\bin\jta.jar;C:\tibco\EMS\5.0\databaselib\oj dbc14.jar;C:\tibco\EMS\5.0\bin\ojdbc14.jar

dbstore_driver_name = oracle.jdbc.driver.OracleDriver

dbstore_driver_dialect = org.hibernate.dialect.Oracle10gDialect

jre_library = C:\jdk1.5.0_06\jre\bin\server\jvm.dll

==============================================

6. Create database users for EMS usage in the database. The users should have permissions to create, alter, delete, update for table, index and sequence.

7. Modify c:\tibco\ems\5.0\samples\config\stores-db.conf to put your own database store information:

Example, in stores-db.conf, defines oracle database information:

$sys.failsafe


dbstore_driver_url=jdbc:oracle:thin:adminfs/admin123@//osrv_1:1521/orclperf

dbstore_driver_username=adminfs

dbstore_driver_password=admin123

8. Modify the file queues.conf or topics.conf to define where the messages will be stored:

Example, in the file queues.conf:

TIBCO.quotes maxbytes=10MB,trace,store=$sys.failsafe

9. Use the schema export tool to export the EMS schema into database:

Example:

java -jar c:\tibco\ems\5.0\bin\tibemsd_util.jar -tibemsdconf c:\tibco\ems\5.0\samples\config\tibemsd-db.conf -createall -export
See the TIBCO Enterprise Message Service User’s Guide, Chapter 5, entitled “Running the EMS Server” for details about the schema export tool.

10. Start the EMS server using c:\tibco\ems\5.0\samples\config\tibemsd-db.conf




For training on TIBCO EMS mail us at [email protected]