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 the persistence.xml, located in either jbossesb-registry.sar/META-INF/ or jbossesb-registry.sar/juddi_config/META-INF/. hibernate.dialect property must be set to the type of database that is going to be used as the data source. (It may, for example, be org.hibernate.dialect.PostgreSQLDialect.)

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.

Procedure 1.2. Changing the database to DB2

• In addition to the standard procedure to change the database (listed above), you may need additional steps if you are changing to DB2 9.7 or above. You also need to configure the table space size - at least 8k page size table space is needed. Here are some sample settings:

  
  
  
  create bufferpool soabp immediate size 1000 pagesize 8k;
  
  create tablespace soats pagesize 8k managed by AUTOMATIC STORAGE BUFFERPOOL soabp;
  
  create temporary tablespace soatempts pagesize 8k managed by AUTOMATIC STORAGE BUFFERPOOL soabp;