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]

_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to