How to change Hypersonic configuration to Oracle database co

[shweta21]

Hi,

I am running Duke's bank application in jboss. I want to use Oracle data base.
Can anybody tell me, How to change Hypersonic configuration to Oracle database configuration in jboss?
What files i need to update to do this?

Thanks in advance.

Regards,
Shweta

[visolvejboss]

Hello,

You need to add the oracle-ds.xml file in the

<JBOSS_HOME>/server/default/deploy

folder.

You can find the example file oracle-ds.xml from the location

<JBOSS_HOME>/docs/examples/jca/

And do the changes as required for

<connection-url>,<user-name> and <password> fields etc.,

Hope, this might help you.

[rabbiaqaswar]

Hello

I am also trying to use Oracle with NetBeans 5.5.

As you said I have copied the oracle-ds.xml file to the server\default\deploy directory.

Created the Database Connection with the database and also Execute Command to see if i can get the data from any table. It is all working fine.

Now I am trying to make a Entity Class from Database. But after I select the DataSource, there is a Table in the screen which should be populated with the database tables but it is not showing any tables from my database.

What should I do to see the tables so that I can select the one for which I want to create an entity?

Thanks