jboss 3.0.6: connection pool which oracle oci

[sscheuring]

Hello,
I am using JBOSS 3.0.6 since a few months, I was able use it and configure it without problems - till now. I have configured some connection pools using the oracle thin driver. Now I want to use the OCI driver with gives me more debugging support.

Unfortunately I can not configure JBOSS to do it this way. I think I have to set some important parameters in the environment, like ORACLE_SID, TWO_TASK, ORACLE_HOME but these are not recognized by JBOSS.

For testing I wrote a simple Java programm which only creates a database connection using the OCI driver. Without these parameters in the environment, it didn't work. If these parameters are set correctly it worked perfektly.

Does anyone know how I can configure JBOSS to work with the OCI driver?

Thanx
Steffen

Here is a part on my connection pool configuration, but it well be not completely displayed:


OracleRealm_DBKnown
<depends optional-attribute-name="ManagedConnectionFactoryName">

DBKnown


<config-property name="ConnectionURL" type="java.lang.String">jdbc:oracle:oci:@BETA</config-property>
<config-property name="DriverClass" type="java.lang.String">oracle.jdbc.driver.OracleDriver</config-property>


<depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper


<depends optional-attribute-name="ManagedConnectionPool">

0
50
5000
15
ByContainer


<depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager
<depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager
java:/TransactionManager

[ter_d]

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

[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.