1 Reply Latest reply: Mar 10, 2012 10:35 AM by Wolf-Dieter Fink RSS

    Configure Oracle datasource

    kneebull Newbie

      Hello,

       

      I am new to jboss and am trying to get my system running properly. I am running JBoss 5.10 on RHEL5  in a cluster and have an Oracle 11i RAC database. I have searched and not seen this issue in any discussions.

       

      I have successfully set up oracle-ds.xml and it is connecting properly.  My question is that I want to replace Hypersonic with a different Oracle DB that has been created for this purpose.  In my oracle-ds.xml, I have created a second datasource to replace the Hypersonic with Oracle.  So I have:

      <datasources>

         <local-tx-datasource>

           <jndi-name>jdbc/datasource1</jndi-name>         <!--  This is the big Oracle DB  -->

           .... { first Oracle user/pw }

         </local-tx-datasource>

         <local-tx-datasource>

           <jndi-name>DefaultDS</jndi-name>                <!--  This is the minimal Oracle DB to replace Hypersonic  -->

          .....  { second Oracle user/pw  }

         </local-tx-datasource>

      </datasources>

       

      I have removed hsqldb-ds.xml and added /messaging/oracle-persistence-service.xml.

       

      I do not see any errors in the logs. 

       

      Is this the correct approach?  Anything I missed?  Should I see entries in this new Oracle table I have to replace Hypersonic?  How do I know it is working.

       

      Thanks,

      Mike

        • 1. Re: Configure Oracle datasource
          Wolf-Dieter Fink Master

          The DefaultDS will be used for EJB2 CMP (Entity) persistence, JEE timers and JBossMessaging.

           

          So after starting Server you should have a table TIMERS and several JMS tables.

          You might change the persistence plugin for deploy/ejb2-timer-service.xml from GeneralPurpose to Oracle (example within the file)

           

          If you have a example for timers and for JMS you might try this, otherwise I would say it will be ok if you don't see errors during startup