The ESB uses database for persisting Registry services, and the Message-Store.
Database scripts for each of these can be found under:
Service Registry: ESB_ROOT/install/juudi-registry/sql
Message-Store: ESB_ROOT/install/message-store/sql
A few database types and their scripts are provided, and you should be able to easily create one for your particular database.
For the Message-Store you will need to also update the properties in the main ESB config file jbossesb-properties.xml. The following are settins you will need to change, based on the database and connection information appropriate to your environment – these settings are found in the DBSTORE section of the file.
|
Property |
Setting |
|
org.jboss.soa.esb.persistence.db.connection.url this is the url for your database. |
|
|
org.jboss.soa.esb.persistence.db.jdbc.driver |
JDBC Driver |
|
org.jboss.soa.esb.persistence.db.user |
db user |
|
org.jboss.soa.esb.persistence.db.pwd |
db password |
|
org.jboss.soa.esb.persistence.db.pool.initial.size |
initial size of db connection pool |
|
org.jboss.soa.esb.persistence.db.pool.min.size |
minimum size of db connection pool |
|
org.jboss.soa.esb.persistence.db.pool.max.size |
maximun size of db connection pool |
|
org.jboss.soa.esb.persistence.db.pool.test.table |
A table name (created dynamically by pool manager) to test for valid connections in the pool |
|
org.jboss.soa.esb.persistence.db.pool.timeout.millis |
timeout period to wait for connection requests from pool |
The Service Registry database information is contained in the juudi.properties file. You should consult the Service Registry section of this document for more detailed information on what settings and their values and how they effect the behaviour of the ESB.
JBESB-GS-