JBoss 3.0.3 - Oracle - OCI driver

[sayers]

Is there any way to configure the OCI driver to work with an oracle DB? We are currently using the thin driver but I am running into some problems with large data retrieval errors.


Thanks,

[msnair]

Hello,

Here are a few points for the migration (OCI->Thin):

1. JDBC Driver is same
2. For OCI to work, you will need Oracle Client Installation on the same machine where you are intending to run JBoss
3. Setup a TNS name for the Oracle instance (required if trying to connect to a remote Oracle instance)
4. Change the JDBC URL to the following syntax:
jdbc:oracle:oci8:@tnsname. For local Oracle, just use jdbc:oracle:oci8:@
NOTE: The URL syntax may differ depending on the Oracle version used.

HTH
regards
MS

[sayers]

Thanks,

I will try this today.

Let you know.