Administration Guide

Procedure 1.1. Changing the database to PostgreSQL

1. Remove deploy/hsqldb-ds.xml and add the following in a file named deploy/postgres-ds.xml:

   
   <?xml version="1.0" encoding="UTF-8"?>
   
   <datasources>
   
       <local-tx-datasource>
   
           <jndi-name>DefaultDS</jndi-name>
   
           <connection-url>jdbc:postgresql://host:port/database</connection-url>
   
           <driver-class>org.postgresql.Driver</driver-class>
   
           <user-name>username</user-name>
   
           <password>password</password>
   
           <metadata>
   
               <type-mapping>PostgreSQL 7.2</type-mapping>
   
           </metadata>
   
           <check-valid-connection-sql>
   
               select count(*) from jbm_user
   
           </check-valid-connection-sql>
   
       </local-tx-datasource>
   
   </datasources>
   
   

   Modify the above to suite your needs, connection parameters and such. Make sure the name of the DS is the same though (DefaultDS)

2. Replace deploy/jbossesb-registry.sar/juddi-ds.xml with the same configuration in the previous step (change the database name if needed).
Again make sure the keep the jndi-name(juddiDB). 


3. Replace deploy/jbossesb.esb/message-store-ds.xml with the same configuration in step one (change the database name if needed).
Again make sure the keep the jndi-name(JBossESBDS).

4. Replace the database name in the 'message-store-sql' element in deploy/jbossesb.esb/jbossesb-service.xml:

   
   <?xml version="1.0" encoding="UTF-8"?>
   
   <server>
   
       <mbean code="org.jboss.internal.soa.esb.dependencies.DatabaseInitializer"
   
           name="jboss.esb:service=MessageStoreDatabaseInitializer">
   
           <attribute name="Datasource">java:/JBossESBDS</attribute>
   
           <attribute name="ExistsSql">select * from message</attribute>
   
           <attribute name="SqlFiles">
   
               message-store-sql/postgresql/create_database.sql
   
           </attribute>
   
           <depends>jboss.jca:service=DataSourceBinding,name=JBossESBDS</depends>
   
       </mbean>
   
   </server>
   
   

5. Edit jbossesb-registry.sar/META-INF/persistence.xml. The hibernate.dialect property must be set to the type of database that you are using in your datasource (org.hibernate.dialect.PostgreSQLDialect for example).

6. Replace deploy/jboss-messaging/hsqldb-persistence-service.xml with the postgres-persistence-service.xml from the version of JBM that you are running.

   This needs to match the same version and might not work it the versions mismatch. These files can be found in src/etc/server/default/deploy of a JBM distribution.

7. Copy the database driver to the servers lib directory and fire up the server.