2 Replies Latest reply on Nov 22, 2002 3:15 PM by Manoj Nair

    JBoss 3.0.4 and Oracle 8.1.7 Problem - Please help

    Manoj Nair Newbie

      Hello All,

      I am trying to configure an Oracle datasource using:
      JBOSS 3.0.4
      Oracle 8.1.7 (running on a remote host)
      Platform is WinNT

      Here are is the procedure:
      1. Put Oracle JDBC driver zip file classes12.zip in $JBOSS_HOME/server/default/lib
      2. Modified oracle-service.xml from $JBOSS/docs/examples/jca
      a. URL
      b. UserName
      c. Password
      3. Copied oracle-service.xml to $JBOSS_HOME/server/default/deploy

      Results:
      1. JBOSS seemed to have done its work. The display on the console was:
      13:37:07,175 INFO [MainDeployer] Starting deployment of package: file:/Q:/jboss
      -3.0.4/jboss-3.0.4/server/default/deploy/oracle-service.xml
      13:37:07,472 WARN [ServiceController] jboss.jca:service=LocalTxDS,name=Ora8DS d
      oes not implement any Service methods
      13:37:07,504 INFO [JBossManagedConnectionPool] Creating
      13:37:07,504 INFO [JBossManagedConnectionPool] Created
      13:37:07,504 INFO [LocalTxConnectionManager] Creating
      13:37:07,519 INFO [LocalTxConnectionManager] Created
      13:37:07,519 INFO [JBossManagedConnectionPool] Starting
      13:37:07,519 INFO [JBossManagedConnectionPool] Started
      13:37:07,535 INFO [LocalTxConnectionManager] Starting
      13:37:07,629 INFO [OracleDataSource] Bound connection factory for resource adap
      ter 'JBoss LocalTransaction JDBC Wrapper' to JNDI name 'java:/OracleDataSource'
      13:37:07,629 INFO [LocalTxConnectionManager] Started
      13:37:07,629 INFO [MainDeployer] Deployed package: file:/Q:/jboss-3.0.4/jboss-3
      .0.4/server/default/deploy/oracle-service.xml

      Problem:
      I could see no Oracle database connections being taken. For verifying I did a netstat and it shows no connections.

      Any help on resolving this issue would be highly appreciated.

      Thanks
      MS

        • 1. Re: JBoss 3.0.4 and Oracle 8.1.7 Problem - Please help
          Alexander Lepekhine Newbie

          netstat will show connection when you really get connection from datasource. See also MinSize and MaxSize attributes in oracle-service.xml

          • 2. Re: JBoss 3.0.4 and Oracle 8.1.7 Problem - Please help
            Manoj Nair Newbie

            Hello,

            Thanks for finding some time for answering my question.

            The value of Min and Max are 5 and 20 respectively.

            thanks
            MS

            oracle-service.xml file is enclosed inline:

            <?xml version="1.0" encoding="UTF-8"?>


            <!--uncomment out this line if you are using the OracleDbRealm above
            OracleDbRealm
            -->
            <depends
            optional-attribute-name="ManagedConnectionFactoryName">
            <!--embedded mbean-->


            OracleDataSource



            <config-property name="ConnectionURL" type="java.lang.String">jdbc:oracle:thin:mstest/mstest@maui.plx.com:1523:ifam817</config-property>
            <config-property name="DriverClass" type="java.lang.String">oracle.jdbc.driver.OracleDriver</config-property>
            <config-property name="UserName" type="java.lang.String">mstest</config-property>
            <config-property name="Password" type="java.lang.String">mstest</config-property>



            <!--Below here are advanced properties -->
            <!--hack-->
            <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper
            <!--
            jboss:service=Hypersonic
            -->


            <!-- Connection pool Setting ... -->
            <depends optional-attribute-name="ManagedConnectionPool">
            <!--embedded mbean-->


            5
            20
            5000
            15
            <!--criteria indicates if Subject (from security domain) or app supplied
            parameters (such as from getConnection(user, pw)) are used to distinguish
            connections in the pool. Choices are
            ByContainerAndApplication (use both),
            ByContainer (use Subject),
            ByApplication (use app supplied params only),
            ByNothing (all connections are equivalent, usually if adapter supports
            reauthentication)-->
            ByContainer





            <depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager

            <depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager

            java:/TransactionManager

            <!--make the rar deploy! hack till better deployment-->
            jboss.jca:service=RARDeployer