[jboss-user] [Datasource Configuration] - Configure Oracle datasource

[Mike Nebel]

Mike Nebel [https://community.jboss.org/people/kneebull] created the discussion

"Configure Oracle datasource"

To view the discussion, visit: https://community.jboss.org/message/722941#722941

--------------------------------------------------------------
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
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/722941#722941]

Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120309/8fc47d4b/attachment-0001.html