DefaultDS in Jboss 5

[newbee07]

Hi ALL,

I have one general question regarding the DefaultDS.

Currently JBoss 5 comes with hsqlDB with a DefaultDS data source. As we are trying to use the ORcale 10g xe, How can we change the default data source pointing to our Oracle XE.

Can any one provide me with the steps to completely remove the HSQL DB depedency and add the DefaultDS specific to Oracle xe.

[peterj]

See if this helps:

http://community.jboss.org/message/544610#544610

[wdfink]

Simple is to replace DefaultDS with an Oracle-ds. You would become trouble if you use a XAdatasource.

Because JBoss messaging cant create the tables during startup because of transaction handling.

If you change deploy/messaging/hsqldb-persistence-service.xml with oracle one (see docs/examples) you should can create the tables with the SQL statements inside.

Other dependencies to DefaultDS I remove, see http://community.jboss.org/wiki/JBoss5xTuningSlimming