Change the DefaultDS that JBossMQ uses

In this section we will be using "DefaultDS" as the jndi name for the datasource. Since all JBoss services using persistence are configured by default to use a datasource with jndi name "DefaultDs", the number of changes is reduced to a minimum.

Throughout the intructions we will be using an Oracle datasource as an

example.  You can find other example configurations for popular database systems in $JBOSS_HOME/docs/examples/jca and

$JBOSS_HOME/docs/examples/jms.

Installing the jdbc driver

JDBC drivers are provided in JAR archives by the database vendor or a third-party company.

 - Copy the jar file to server/[your server config]/lib

Deploying the datasource descriptor for your database

Datasource examples for the most popular databases are available in $JBOSS_HOME/docs/examples/jca.

 - Copy docs/examples/jca/oracle-ds.xml to deploy{-hasingleton}
 - Replace the <jndi-name> property value with "DefaultDS"
 - Configure the datasource (server url, user, password, etc...)
 - Remove deploy{-hasingleton}/hsqldb-ds.xml

Updating the Persistence Manager service

The persistence manager is using database-specific queries to create tables and other indexes.

Alternate persistence configurations can be found in $JBOSS_HOME/docs/examples/jms.

 - Copy docs/examples/jms/oracle-jdbc2-service.xml to deploy{-hasingleton}/jms
 - Remove deploy{-hasingleton}/hsqldb-jdbc2-service.xml

You may now restart the server instance.