-
1. Re: jboss 3.0.6: connection pool which oracle oci
ter_d Dec 16, 2004 10:27 AM (in response to sscheuring)Hello!
I read you were able to configure Jboss with oracle thin driver. Would you mind explaining me what you did or where i can find this information?
Thanks!
Esther -
2. Re: jboss 3.0.6: connection pool which oracle oci
sscheuring Dec 20, 2004 5:21 AM (in response to sscheuring)Hi,
what exactly you want to know?
First of all you have to install the oracle client software on the system where your jboss is installed. Then there is a file where are the data sources configured, it is named tnsnames.ora. This file contains all database which can be accessed via OCI. If this file is empty or not existing, your DBA should provideyou with this.
Than you can configure you connection pool, the URL are like this:
jdbc:oracle:oci:@DATASOURCE (the DATASOURCE is in tnsnames.ora)
Further the oracle parameters ORACLE_SID, TWO_TASK, ORACLE_HOME must be set in your environment.
Hope this helps you.