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