3 Replies Latest reply on Feb 21, 2003 4:54 AM by Peter Landmann

    multiple oracle db connect pools

    Arthur Esclamada Newbie

      how can set multiple oracle connection pools with different username and passwords each?

      example;

      oraclepool1 user1/passw1
      oraclepool2 user2/passw2
      .. ..

      is it possible in jboss?

      thanks,

        • 1. Re: multiple oracle db connect pools
          jason poley Newbie

          oracle1-service.xml (for first one)
          oracle2-service.xml (for second one)

          make sure they have distinct DS + JNDI names

          -jp

          • 2. Re: multiple oracle db connect pools
            Arthur Esclamada Newbie

            I did what you recommended it's giving me this error..

            08:43:27,734 INFO [MainDeployer] Starting deployment of package: file:/C:/jboss
            -3.0.4_tomcat-4.1.12/server/default/deploy/oracle-service1.xml
            08:43:27,754 INFO [MainDeployer] deployment waiting for deployer: file:/C:/jbos
            s-3.0.4_tomcat-4.1.12/server/default/deploy/oracle-service1.xml
            08:43:27,754 INFO [MainDeployer] Deployment of package: file:/C:/jboss-3.0.4_to
            mcat-4.1.12/server/default/deploy/oracle-service1.xml is waiting for an appropri
            ate deployer.
            08:43:27,754 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean ope
            ration 'checkIncompleteDeployments()'
            Cause: Incomplete Deployment listing:
            Packages waiting for a deployer:
            [org.jboss.deployment.DeploymentInfo@3d08d30 { url=file:/C:/jboss-3.0.4_tomcat-4
            .1.12/server/default/deploy/oracle-service1.xml }
            deployer: null
            status: null
            state: INIT_WAITING_DEPLOYER
            watch: file:/C:/jboss-3.0.4_tomcat-4.1.12/server/default/deploy/oracle-service
            1.xml
            lastDeployed: 1045665807754
            lastModified: 1045665807734
            mbeans:
            ]Incompletely deployed packages:
            [org.jboss.deployment.DeploymentInfo@3d08d30 { url=file:/C:/jboss-3.0.4_tomcat-4
            .1.12/server/default/deploy/oracle-service1.xml }
            deployer: null
            status: null
            state: INIT_WAITING_DEPLOYER
            watch: file:/C:/jboss-3.0.4_tomcat-4.1.12/server/default/deploy/oracle-service
            1.xml
            lastDeployed: 1045665807754
            lastModified: 1045665807734
            mbeans:
            ]MBeans waiting for classes:

            MBeans waiting for other MBeans:





            I copied the oracle-service.xml in docs/examples/jca..is there something that I need to modify other than the connection URL, jndi name and username/password ?

            Please help, thanks..

            • 3. Re: multiple oracle db connect pools
              Peter Landmann Newbie

              The filename has to end with "service.xml". So just rename your "oracle-service1.xml" to "oracle1-service.xml" in order to get it to work.

              I had the same problem, it really took some time to find this out. :-/