3 Replies Latest reply: Jul 22, 2005 4:36 PM by 807581 RSS

    URGENT: RAI - AS7.0-beta: Oracle connectivity [796195]

    807581
      @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
      i had some new requirements and could not find any docs for it.

      How do i create a Connection Pool for a Oracle 8i
      Using the Following Parameters.

      Name= RAiRepositoryPool
      Description=RAiRepositoryPool
      Datasource Classname=oracle.jdbc.driver.OracleDriver
      URL=jdbc:oracle:thin:user/user@ECLIPSE:1521:ECLIPSE

      The following is the snapshot of the Configurations Of

      Connection Pool in Weblogic6.1sp3

      <JDBCConnectionPool DriverName="oracle.jdbc.driver.OracleDriver"
      Name="RAiRepositoryPool" Properties="dll=ocijdbc8;protocol=thin"
      Targets="myserver"
      URL="jdbc:oracle:thin:user/user@ECLIPSE:1521:ECLIPSE"/>

      DataSource in Weblogic6.1sp3

      <JDBCDataSource JNDIName="jdbc/Repository" Name="jdbc/Repository"
      PoolName="RAiRepositoryPool" Targets="myserver"/>

      Please provide some documentation as the JDBC Resource section at
      http://docs.sun.com/source/816-7156-10/agj2eres.html#33267
      says
      (This module is not available for Beta refresh)

      @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
        • 1. Re: URGENT: RAI - AS7.0-beta: Oracle connectivity [796195]
          807581
          Here's a snippet of a server.xml file that includes a connection pool definition for an Oracle 8.1.x client interacting with an Oracle 8.1.6 server:

          <resources>
          <jdbc-resource enabled="true" pool-name="OraclePool" jndi-name="jdbc/jdbc-simple"/>
          <jdbc-connection-pool steady-pool-size="8" max-pool-size="32" max-wait-time-in-millis="60000" pool-resize-quantity="2" idle-timeout-in-seconds="300" is-isolation-level-guaranteed="false" is-connection-validation-required="false" connection-validation-method="auto-commit" fail-all-connections="false" datasource-classname="oracle.jdbc.pool.OracleDataSource" name="OraclePool">
          <property value="jdbc:oracle:thin:@ias.red.iplanet.com:1521:orcl" name="URL"/>
          <property value="scott" name="user"/>
          <property value="tiger" name="password"/>
          </jdbc-connection-pool>
          </resources>

          You can copy the driver JAR file to the <instance_root>/lib/ directory and restart the server instance to add the driver to the server instance's classpath.

          Alternatively, you can use the admin console to add the driver path to the Classpath Suffix field under the JVM Settings area for the instance.

          (If using a Type 2 driver, the native library path can be added to the Native Library Path field in the same are of the console).
          • 2. Re: URGENT: RAI - AS7.0-beta: Oracle connectivity [796195]
            807581
            Any pointer on below's cust outcome after trying the following suggestion based on the initial proposal:

            @@@@@@@@@@@@@@@@@@@@@@@@
            Here's a snippet of a server.xml file that includes a connection pool definition for an Oracle 8.1.x
            client containing your requirement specifics which interacts with an Oracle 8.1.6 server:

            <resources>
            <jdbc-resource enabled="true" pool-name="OraclePool" jndi-name="jdbc/jdbc-simple"/>
            <jdbc-connection-pool steady-pool-size="8" max-pool-size="32" max-wait-time-in-millis="60000"
            pool-resize-quantity="2" idle-timeout-in-seconds="300"
            is-isolation-level-guaranteed="false" is-connection-validation-required="false"
            connection-validation-method="auto-commit" fail-all-connections="false"
            datasource-classname="oracle.jdbc.pool.OracleDataSource" name="RAIRepositoryPool">
            <property value="jdbc:oracle:thin:user/user@ECLIPSE:1521:ECLIPSE" name="URL"/>
            <property value="user" name="user"/>
            <property value="user" name="password"/>
            </jdbc-connection-pool>
            </resources>

            You will then copy the driver JAR file to the <instance_root>/lib/ directory and restart the
            server instance to add the driver to the server instance's classpath.

            Regards,

            Gaetan

            @@@@@@@@@@@@@@@@@@@@@@@@@@@@@








            @@@@@@@@@@@@@@@ cust's results @@@@@@@@@@@@@@@@@@@@@@@@@@@

            Here is the stack Trace of the error i get after i use the Jdbc Datasource .

            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - In constructor
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - in ejbCreate
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - In constructor
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - In constructor
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - In JDBCHandler in initialize
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - in setDataSourceJndiName jdbc/Repository
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - in setUserID raiuser
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - in setPassword raiuser
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - in setXmlURL /RAI_SUNONE/xml
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - in setXsdURL /RAI_SUNONE/schema
            WARNING: CORE3283: stderr: java.sql.SQLException: Operation not allowed
            under global transaction context
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - leaving initialize
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - In constructor
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - In constructor
            WARNING: CORE3283: stderr: at
            com.sun.enterprise.resource.JdbcXAConnection$JdbcConnection.setAutoCommit(Un
            known Source)
            WARNING: CORE3283: stderr: at
            com.rai.raiid.repository.JDBCHandler.getConnection(Unknown Source)
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - In JDBCHandler in initialize
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - in setDataSourceJndiName jdbc/Repository
            WARNING: CORE3283: stderr: at
            com.rai.raiid.repository.JDBCHandler.getConnection(Unknown Source)
            WARNING: CORE3283: stderr: at
            com.rai.raiid.repository.JDBCBusinessRepositoryHandler.prepareSelectALLSQL(U
            nknown Source)
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - in setUserID raiuser
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - in setPassword raiuser
            WARNING: CORE3283: stderr: at
            com.rai.raiid.repository.JDBCBusinessRepositoryHandler.loadAll(Unknown
            Source)
            WARNING: CORE3283: stderr: at
            com.rai.raiid.repository.BusinessRepositoryManagerBean.getAllBusinessReposit
            ories(Unknown Source)
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - in setXmlURL /RAI_SUNONE/xml
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - in setXsdURL /RAI_SUNONE/schema
            WARNING: CORE3283: stderr: at
            com.rai.raiid.repository.BusinessRepositoryManagerBean_EJBObjectImpl.getAllB
            usinessRepositories(BusinessRepositoryManagerBean_EJBObjectImpl.java:437)
            WARNING: CORE3283: stderr: at
            com.rai.raiid.repository._BusinessRepositoryManager_Stub.getAllBusinessRepos
            itories(Unknown Source)
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - leaving initialize
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - Entering getAllBusinessRepositories
            WARNING: CORE3283: stderr: at
            com.rai.raiid.session.RAISessionManagerBean.getAllBusinessRepositories(Unkno
            wn Source)
            WARNING: CORE3283: stderr: at
            com.rai.raiid.session.RAISessionManagerBean_EJBObjectImpl.getAllBusinessRepo
            sitories(RAISessionManagerBean_EJBObjectImpl.java:1269)
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - in loadAll
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - LoadAll Start Time :: Thu Sep 05 13:03:52 PDT 2002
            WARNING: CORE3283: stderr: at
            com.rai.raiid.session._RAISessionManagerBean_EJBObjectImpl_Tie._invoke(Unkno
            wn Source)
            WARNING: CORE3283: stderr: at
            com.sun.corba.ee.internal.POA.GenericPOAServerSC.dispatchToServant(Unknown
            Source)
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - in prepareSelectALLSQL
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - in getConnection
            WARNING: CORE3283: stderr: at
            com.sun.corba.ee.internal.POA.GenericPOAServerSC.internalDispatch(Unknown
            Source)
            WARNING: CORE3283: stderr: at
            com.sun.corba.ee.internal.POA.GenericPOAServerSC.dispatch(Unknown Source)
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - in getConnection(String,String,String)
            INFO: CORE3282: stdout: ERROR [05 Sep 2002 13:03:52] [RAI.RAIID.REPOSITORY]
            [Thread-7] (?:?) - Exception Message is : java.sql.SQLException: Operation
            not allowed under global transaction context
            WARNING: CORE3283: stderr: at
            com.sun.corba.ee.internal.iiop.ORB.process(Unknown Source)
            WARNING: CORE3283: stderr: at
            com.sun.corba.ee.internal.iiop.RequestProcessor.process(Unknown Source)
            INFO: CORE3282: stdout: ERROR [05 Sep 2002 13:03:52] [RAI.RAIID.SESSION]
            [Thread-7] (?:?) - Class RAISessionManagerBean:: Method::
            getAllBusinessRepositories Exception
            javax.transaction.TransactionRolledbackException: CORBA
            TRANSACTION_ROLLEDBACK 9998 Maybe; nested exception is:
            INFO: CORE3282: stdout: org.omg.CORBA.TRANSACTION_ROLLEDBACK:
            vmcid: 0x2000 minor code: 1806 completed: Maybe
            WARNING: CORE3283: stderr: at
            com.iplanet.ias.corba.ee.internal.iiop.ServicableWrapper.service(Unknown
            Source)
            WARNING: CORE3283: stderr: at
            com.iplanet.ias.util.threadpool.FastThreadPool$ThreadPoolThread.run(Unknown
            Source)
            WARNING: CORE3283: stderr: at java.lang.Thread.run(Thread.java:536)
            INFO: CORE3282: stdout: DEBUG [05 Sep 2002 13:03:54] [RAI.RAIID.GUI]
            [Thread-11] (?:?) - tree in brtree handler is null

            Why is java.sql.SQLException: Operation not allowed under global transaction
            context thrown

            - Rajinder
            @@@@@@@@@@@@@@@
            • 3. Re: URGENT: RAI - AS7.0-beta: Oracle connectivity [796195]
              807581
              I had the same error about 45 minutes ago. I got past it though. I believe it was a nested SQL exception. Double check all of your SQL statements for errors. Look for missing and/or extraneous spaces and/or punctuation. Also, go in and catch some more exceptions at a lower level.