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&...]