Version 2

    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



    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.