Steps to change from Hypersonic to Oracle DB in jboss4.2.3

[tcsjboss]

Hi All,

I am facing problems in production environment with Hypersonic DB. Please mention the steps to switch to Oracle DB.

The doc which i referred was http://www.jboss.org/community/docs/DOC-13175 but i have certain questions:

1. Where should the tables be created as used by JBOSS?

2. Are these to be manually created or JBOSS creates them?

3. How can we check if we have actually switched to Oracle DB?

I am also attaching the jboss server logs. Am not able to conclude anything from it. If you can find anything from the logs please let me know. Please help!!

Thanks & Regards,

Apoorva

[wdfink]

1 / 2)

If you deploy a Oracle -ds.xml file and name the datasource DefaultDS JBoss create the tables for you.

Except if you use a XA-Datasource, in this case it happen to me that an error raise during startup.

If you use a local-tx-datasource it will work (maybe you change to XA afterwards)

3)

If you remove the hsqldb-ds.xml JBoss will not start without error, if your oracle is in place the errors are solved

[peterj]

Deja vu!

http://www.coderanch.com/t/544042/JBoss/Steps-change-Hypersonic-Oracle-DB