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