I recently tried to build a JMS Server with database backend. The chosen product was the TIBCO EMS Server. The Server brings its own database support over hibernate.
Unfortunately TIBCO supports only Oracle,Mysql and DB2 by default. Lucky me, I needed an installation for Postgres but this shouldn’t be a big deal, because hibernate supports postgres as well. You just have to modify the hibernate config.
First you should install the EMS server and hibernate (version provided by Tibco). After that let’s start configuring.
To have everything in the database you need 3 databases (3 separate EMS stores). For me I used the following 3 stores:
- emsmeta -> for metadata content
- emsnf -> for nonfailsafe data
- emsf -> for failsafe data
I used the same account for all 3 databases (just easier for testing purposes).
Setup the stores in the stores.conf in the EMS folder:
After that you have to change you tibemsd.conf file.The following line is a sample what you should add. Additionally you should add the path to your jdbc driver (in this sample the last parameter – change it to your config). You also have to add the path to your JVM (here it is the debian lenny default).
As you can see changing databases is easy. You just have to change the driver_name and driver_dialect of hibernate.
After that you have the basic configuration ready. Next thing to do is to initialize the database. For that task Tibco provides a tool which generates the proper sql-statements.
You can run the following command in your shell and get the sql as output.
For some reason the create sql-statements had no ‘;’ at the end of every command. So you can’t just pipe the output to pgsql. You have to do it old school.
After that you can start the EMS Server and it stores all data to the selected database.
- searching for hash strings in postgres
- why sub-selects can be faster than inner joins
- get hostname from url as stored procedure in plpgsql
- copy a table across databases via dblink
- BusinessEvents 4: using Scorecards in a clustered environment
- handling a few thousand simultaneous connections in TIBCO BusinessWorks
- TIBCO Designer Panel too small
- init script for the TIBCO Administrator
- adding IP-restriction to BusinessWorks processes
- writing Unicode characters to Oracle with TIBCO BusinessWorks
- TIBCO Designer with external memory window
- improve TIBCO Designer tester performance under linux
- installing TIBCO TRA 5.6 on a debian 64bit