How to use Jboss & Tomcat with Oracle Thick driver

[hhit]

Hi All,

Currently we are using Oracle thin driver i.e. Type 4, and I would like to use Oracle Thick driver i.e. Type 2.
I need this in order to make the usage of the Oracle network TAF ability with Oracle RAC.

I'm runnig Oracle 9.2.0.4.

I'm looking to have a connect string like this:

TAF Basic/Preconnect

url="jdbc:oracle:oci:@Net_Service_Alias"

Where the Net_Service_Alias will be my Oracle service name.

What changes I need to perform in my JBOSS config in order to make this happen?

Thanks.

[jae77]

modify the nukes-ds.xml to use the connection string and that's it.

also make sure the oracle libraries are available on your path so jboss picks them up.