2 Replies Latest reply on Dec 20, 2004 5:21 AM by Steffen Scheuring

    jboss 3.0.6: connection pool which oracle oci

    Steffen Scheuring Newbie

      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