Need a guide how to connect JBoss 3.2.5 to Oracle 9i

[Tony Evans]

I have downloaded JBoss 3.2.5 what I want to do is connect it to my Oracle 9i database.

What I would like is a step by step guide is there is one about.

I guess I would add the classes12.zip to the C:\jboss-3.2.5\lib directory, would I need to set any config files.

Thanks for any help Tony

[Jeff Shelley]

Hi Tony,
in docs/examples/jca, there should be an oracle-ds.xml datasource configuration file. To set this up as a datasource, copy/paste it to your deploy directory, then go in there and edit all the connection specific stuff. Also, you should be able to paste your classes zip file in the deploy directory of the configuration you're using. if you haven't messed with anything, it's server/default/deploy/

After that, you're in! Best of luck!
--Jeff

[Tony Evans]

Thanks Jeff,
Not being an Oracle DBA type

for this code :
<connection-url>jdbc racle ci:@youroracle-tns-name</connection-url>
or
<connection-url>jdbc racle ci:@(description=(address=(host=youroraclehost)(protocol=tcp)(port=1521))(connect_data=(SERVICE_NAME=yourservicename)))</connection-url>


Where can I find my oracle-tns-name and servicename:

And would you know what sql code goes in here:
<!-- sql to call when connection is created
<new-connection-sql>some arbitrary sql</new-connection-sql>
-->

<!-- sql to call on an existing pooled connection when it is obtained from pool - the OracleValidConnectionChecker is prefered
<check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>


Thanks again Tony