5 Replies Latest reply on Mar 24, 2005 2:34 PM by 666705

    Pointbase

    3004
      Hi,

      When I create a new workshop application, some JMS store and queue are
      created by default to handle the asynchronous calls. The cgpool is
      configured to use the embeded pointbase database. Can I change this pool to
      point to a Oracle database? Since there are tables created inside the
      pointbase database, are there any sql scripts to create those tables in
      Oracle database?

      Thanks,
      Bob Li
      Senior Consultant
      bli@verax.ca


        • 1. Re: Pointbase
          3004
          For new domains,

          1. Create your domain with Domain configuration Wizard and specify the JDBC
          properties as below.

          For existing domains,

          1. Start the Weblogic server.

          Steps are
          2. In Administration Console, http://localhost:7001/console
          3. Select services, JDBC select cgPool
          4. set the jdbc URL
          5. set the jdbc driver


          How to disable Pointbase

          1. In the startWeblogic.cmd script of your domain set the variable
          pointbaseflag to false
          2. change the file db_settings.properties to oracle properties with the
          above values.

          After this restart your server.

          Karthi.


          "Bob Li" <bli@verax.ca> wrote in message news:3fc4e555@newsgroups.bea.com...
          Hi,

          When I create a new workshop application, some JMS store and queue are
          created by default to handle the asynchronous calls. The cgpool is
          configured to use the embeded pointbase database. Can I change this pool
          to
          point to a Oracle database? Since there are tables created inside the
          pointbase database, are there any sql scripts to create those tables in
          Oracle database?

          Thanks,
          Bob Li
          Senior Consultant
          bli@verax.ca

          • 2. Re: Pointbase
            3004
            Hi Kathi,

            Please let me know how to specify the JDBC properties when I config a new
            domain.

            And I tried to follow the steps listed below to remove the pointbase server.
            I changed the JDBC URL and driver for the cbPool via console. And I set
            variable
            pointbaseflag to false in start scripts. But I could not find any
            db_settings.properties in my domain as my application is only a basic
            workshop application without Integration and Portal features.

            Then I tried to restart the server and got these exceptions without any
            tables created in my Oracle database.

            What's wrong? Is there any document talking about this?

            Thanks,
            Bob

            ####<Dec 1, 2003 5:09:31 PM GMT-05:00> <Alert> <JMS> <VERAX104> <cgServer>
            <main> <<WLS Kernel>> <> <BEA-040052> <JMSServer "cgJMSServer" store failed
            to open java.io.IOException: JMS JDBC store, connection pool = <cgPool>,
            prefix = <weblogic>: change state
            java.sql.SQLException: ORA-00942: table or view does not exist

            at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
            at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
            at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
            at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
            at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1094)
            at
            oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2132
            )
            at
            oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2015)
            at
            oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
            :2877)
            at
            oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
            ment.java:608)
            at
            weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java
            :95)
            at weblogic.jms.store.JDBCIOStream.changeState(JDBCIOStream.java:615)
            at weblogic.jms.store.JDBCIOStream.setVersion(JDBCIOStream.java:2057)
            at weblogic.jms.store.JDBCIOStream.open(JDBCIOStream.java:432)
            at weblogic.jms.store.JMSStore.open(JMSStore.java:224)
            at weblogic.jms.backend.BEStore.open(BEStore.java:262)
            at weblogic.jms.backend.BEStore.start(BEStore.java:151)
            at weblogic.jms.backend.BackEnd.openStores(BackEnd.java:1171)
            at weblogic.jms.backend.BackEnd.resume(BackEnd.java:1287)
            at weblogic.jms.JMSService.addJMSServer(JMSService.java:2167)
            at weblogic.jms.JMSService.addDeployment(JMSService.java:1938)
            at
            weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentT
            arget.java:330)
            at
            weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(Deployment
            Target.java:590)
            at
            weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(D
            eploymentTarget.java:568)
            at
            weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(Deploym
            entTarget.java:240)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at
            sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
            )
            at
            sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
            .java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at
            weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl
            .java:747)
            at
            weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:7
            26)
            at
            weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBea
            nImpl.java:458)
            at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
            at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
            at
            weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerI
            mpl.java:765)
            at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
            at
            weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java
            :481)
            at
            weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerM
            Bean_Stub.java:7271)
            at
            weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(Slave
            Deployer.java:1245)
            at
            weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:397
            )
            at
            weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(Deplo
            ymentManagerServerLifeCycleImpl.java:230)
            at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
            at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:964)
            at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:359)
            at weblogic.Server.main(Server.java:32)
            .
            java.io.IOException: JMS JDBC store, connection pool = <cgPool>, prefix =
            <weblogic>: change state
            java.sql.SQLException: ORA-00942: table or view does not exist

            at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
            at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
            at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
            at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
            at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1094)
            at
            oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2132
            )
            at
            oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2015)
            at
            oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
            :2877)
            at
            oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
            ment.java:608)
            at
            weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java
            :95)
            at weblogic.jms.store.JDBCIOStream.changeState(JDBCIOStream.java:615)
            at weblogic.jms.store.JDBCIOStream.setVersion(JDBCIOStream.java:2057)
            at weblogic.jms.store.JDBCIOStream.open(JDBCIOStream.java:432)
            at weblogic.jms.store.JMSStore.open(JMSStore.java:224)
            at weblogic.jms.backend.BEStore.open(BEStore.java:262)
            at weblogic.jms.backend.BEStore.start(BEStore.java:151)
            at weblogic.jms.backend.BackEnd.openStores(BackEnd.java:1171)
            at weblogic.jms.backend.BackEnd.resume(BackEnd.java:1287)
            at weblogic.jms.JMSService.addJMSServer(JMSService.java:2167)
            at weblogic.jms.JMSService.addDeployment(JMSService.java:1938)
            at
            weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentT
            arget.java:330)
            at
            weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(Deployment
            Target.java:590)
            at
            weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(D
            eploymentTarget.java:568)
            at
            weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(Deploym
            entTarget.java:240)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at
            sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
            )
            at
            sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
            .java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at
            weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl
            .java:747)
            at
            weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:7
            26)
            at
            weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBea
            nImpl.java:458)
            at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
            at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
            at
            weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerI
            mpl.java:765)
            at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
            at
            weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java
            :481)
            at
            weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerM
            Bean_Stub.java:7271)
            at
            weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(Slave
            Deployer.java:1245)
            at
            weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:397
            )
            at
            weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(Deplo
            ymentManagerServerLifeCycleImpl.java:230)
            at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
            at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:964)
            at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:359)
            at weblogic.Server.main(Server.java:32)

            at weblogic.jms.store.JDBCIOStream.throwIOException(JDBCIOStream.java:369)
            at weblogic.jms.store.JDBCIOStream.changeState(JDBCIOStream.java:636)
            at weblogic.jms.store.JDBCIOStream.setVersion(JDBCIOStream.java:2057)
            at weblogic.jms.store.JDBCIOStream.open(JDBCIOStream.java:432)
            at weblogic.jms.store.JMSStore.open(JMSStore.java:224)
            at weblogic.jms.backend.BEStore.open(BEStore.java:262)
            at weblogic.jms.backend.BEStore.start(BEStore.java:151)
            at weblogic.jms.backend.BackEnd.openStores(BackEnd.java:1171)
            at weblogic.jms.backend.BackEnd.resume(BackEnd.java:1287)
            at weblogic.jms.JMSService.addJMSServer(JMSService.java:2167)
            at weblogic.jms.JMSService.addDeployment(JMSService.java:1938)
            at
            weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentT
            arget.java:330)
            at
            weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(Deployment
            Target.java:590)
            at
            weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(D
            eploymentTarget.java:568)
            at
            weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(Deploym
            entTarget.java:240)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at
            sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
            )
            at
            sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
            .java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at
            weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl
            .java:747)
            at
            weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:7
            26)
            at
            weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBea
            nImpl.java:458)
            at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
            at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
            at
            weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerI
            mpl.java:765)
            at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
            at
            weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java
            :481)
            at
            weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerM
            Bean_Stub.java:7271)
            at
            weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(Slave
            Deployer.java:1245)
            at
            weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:397
            )
            at
            weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(Deplo
            ymentManagerServerLifeCycleImpl.java:230)
            at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
            at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:964)
            at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:359)
            at weblogic.Server.main(Server.java:32)
            >
            ####<Dec 1, 2003 5:09:31 PM GMT-05:00> <Error> <JMS> <VERAX104> <cgServer>
            <main> <<WLS Kernel>> <> <BEA-040123> <Failed to start JMS Server
            "cgJMSServer" due to weblogic.jms.common.JMSException: JMS can not open
            store cgJMSStore.
            weblogic.jms.common.JMSException: JMS can not open store cgJMSStore
            at weblogic.jms.backend.BEStore.start(BEStore.java:163)
            at weblogic.jms.backend.BackEnd.openStores(BackEnd.java:1171)
            at weblogic.jms.backend.BackEnd.resume(BackEnd.java:1287)
            at weblogic.jms.JMSService.addJMSServer(JMSService.java:2167)
            at weblogic.jms.JMSService.addDeployment(JMSService.java:1938)
            at
            weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentT
            arget.java:330)
            at
            weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(Deployment
            Target.java:590)
            at
            weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(D
            eploymentTarget.java:568)
            at
            weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(Deploym
            entTarget.java:240)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at
            sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
            )
            at
            sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
            .java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at
            weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl
            .java:747)
            at
            weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:7
            26)
            at
            weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBea
            nImpl.java:458)
            at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
            at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
            at
            weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerI
            mpl.java:765)
            at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
            at
            weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java
            :481)
            at
            weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerM
            Bean_Stub.java:7271)
            at
            weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(Slave
            Deployer.java:1245)
            at
            weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:397
            )
            at
            weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(Deplo
            ymentManagerServerLifeCycleImpl.java:230)
            at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
            at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:964)
            at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:359)
            at weblogic.Server.main(Server.java:32)
            Caused by: java.io.IOException: JMS JDBC store, connection pool = <cgPool>,
            prefix = <weblogic>: change state
            java.sql.SQLException: ORA-00942: table or view does not exist

            at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
            at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
            at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
            at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
            at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1094)
            at
            oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2132
            )
            at
            oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2015)
            at
            oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
            :2877)
            at
            oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
            ment.java:608)
            at
            weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java
            :95)
            at weblogic.jms.store.JDBCIOStream.changeState(JDBCIOStream.java:615)
            at weblogic.jms.store.JDBCIOStream.setVersion(JDBCIOStream.java:2057)
            at weblogic.jms.store.JDBCIOStream.open(JDBCIOStream.java:432)
            at weblogic.jms.store.JMSStore.open(JMSStore.java:224)
            at weblogic.jms.backend.BEStore.open(BEStore.java:262)
            at weblogic.jms.backend.BEStore.start(BEStore.java:151)
            at weblogic.jms.backend.BackEnd.openStores(BackEnd.java:1171)
            at weblogic.jms.backend.BackEnd.resume(BackEnd.java:1287)
            at weblogic.jms.JMSService.addJMSServer(JMSService.java:2167)
            at weblogic.jms.JMSService.addDeployment(JMSService.java:1938)
            at
            weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentT
            arget.java:330)
            at
            weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(Deployment
            Target.java:590)
            at
            weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(D
            eploymentTarget.java:568)
            at
            weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(Deploym
            entTarget.java:240)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at
            sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
            )
            at
            sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
            .java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at
            weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl
            .java:747)
            at
            weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:7
            26)
            at
            weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBea
            nImpl.java:458)
            at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
            at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
            at
            weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerI
            mpl.java:765)
            at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
            at
            weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java
            :481)
            at
            weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerM
            Bean_Stub.java:7271)
            at
            weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(Slave
            Deployer.java:1245)
            at
            weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:397
            )
            at
            weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(Deplo
            ymentManagerServerLifeCycleImpl.java:230)
            at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
            at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:964)
            at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:359)
            at weblogic.Server.main(Server.java:32)

            at weblogic.jms.store.JDBCIOStream.throwIOException(JDBCIOStream.java:369)
            at weblogic.jms.store.JDBCIOStream.changeState(JDBCIOStream.java:636)
            at weblogic.jms.store.JDBCIOStream.setVersion(JDBCIOStream.java:2057)
            at weblogic.jms.store.JDBCIOStream.open(JDBCIOStream.java:432)
            at weblogic.jms.store.JMSStore.open(JMSStore.java:224)
            at weblogic.jms.backend.BEStore.open(BEStore.java:262)
            at weblogic.jms.backend.BEStore.start(BEStore.java:151)
            ... 28 more
            >



            --
            Bob Li
            Senior Consultant
            bli@verax.ca
            "Karthi" <bkarthi@etnoteam.it> wrote in message
            news:3fc6195a$1@newsgroups.bea.com...
            For new domains,

            1. Create your domain with Domain configuration Wizard and specify the
            JDBC
            properties as below.

            For existing domains,

            1. Start the Weblogic server.

            Steps are
            2. In Administration Console, http://localhost:7001/console
            3. Select services, JDBC select cgPool
            4. set the jdbc URL
            5. set the jdbc driver


            How to disable Pointbase

            1. In the startWeblogic.cmd script of your domain set the variable
            pointbaseflag to false
            2. change the file db_settings.properties to oracle properties with the
            above values.

            After this restart your server.

            Karthi.


            "Bob Li" <bli@verax.ca> wrote in message
            news:3fc4e555@newsgroups.bea.com...
            Hi,

            When I create a new workshop application, some JMS store and queue are
            created by default to handle the asynchronous calls. The cgpool is
            configured to use the embeded pointbase database. Can I change this pool
            to
            point to a Oracle database? Since there are tables created inside the
            pointbase database, are there any sql scripts to create those tables in
            Oracle database?

            Thanks,
            Bob Li
            Senior Consultant
            bli@verax.ca

            • 3. Re: Pointbase
              3004
              Hi bob,

              I think only the servers in the portal domain and integration domains uses
              some pre-configured
              connection pools, datasources and JMS Servers.So you will find the
              db_settings.properties file only in the

              So it is necessary when you start the server that all the DB resources are
              present and the communication from your
              App server and DB Server is correct.

              Check all the Connection Pools in your server that they are using Oracle
              instead of Pointbase. Its possible that some
              connection pools which you don't use in your application pointing to
              pointbase.

              Table will not be created during the Server startup. They will be created
              only during the domain creation or
              you explicity lanuch them in SQL*Plus.

              Hope this helps you.
              Karthi.

              "Bob Li" <bli@verax.ca> wrote in message news:3fcbbde3@newsgroups.bea.com...
              Hi Kathi,

              Please let me know how to specify the JDBC properties when I config a new
              domain.

              And I tried to follow the steps listed below to remove the pointbase
              server.
              I changed the JDBC URL and driver for the cbPool via console. And I set
              variable
              pointbaseflag to false in start scripts. But I could not find any
              db_settings.properties in my domain as my application is only a basic
              workshop application without Integration and Portal features.

              Then I tried to restart the server and got these exceptions without any
              tables created in my Oracle database.

              What's wrong? Is there any document talking about this?

              Thanks,
              Bob

              ####<Dec 1, 2003 5:09:31 PM GMT-05:00> <Alert> <JMS> <VERAX104> <cgServer>
              <main> <<WLS Kernel>> <> <BEA-040052> <JMSServer "cgJMSServer" store
              failed
              to open java.io.IOException: JMS JDBC store, connection pool = <cgPool>,
              prefix = <weblogic>: change state
              java.sql.SQLException: ORA-00942: table or view does not exist

              at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
              at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
              at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
              at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
              at
              oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1094)
              at
              oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2132
              )
              at
              oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2015)
              at
              oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
              :2877)
              at
              oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
              ment.java:608)
              at
              weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java
              :95)
              at weblogic.jms.store.JDBCIOStream.changeState(JDBCIOStream.java:615)
              at weblogic.jms.store.JDBCIOStream.setVersion(JDBCIOStream.java:2057)
              at weblogic.jms.store.JDBCIOStream.open(JDBCIOStream.java:432)
              at weblogic.jms.store.JMSStore.open(JMSStore.java:224)
              at weblogic.jms.backend.BEStore.open(BEStore.java:262)
              at weblogic.jms.backend.BEStore.start(BEStore.java:151)
              at weblogic.jms.backend.BackEnd.openStores(BackEnd.java:1171)
              at weblogic.jms.backend.BackEnd.resume(BackEnd.java:1287)
              at weblogic.jms.JMSService.addJMSServer(JMSService.java:2167)
              at weblogic.jms.JMSService.addDeployment(JMSService.java:1938)
              at
              weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentT
              arget.java:330)
              at
              weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(Deployment
              Target.java:590)
              at
              weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(D
              eploymentTarget.java:568)
              at
              weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(Deploym
              entTarget.java:240)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at
              sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
              )
              at
              sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
              .java:25)
              at java.lang.reflect.Method.invoke(Method.java:324)
              at
              weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl
              .java:747)
              at
              weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:7
              26)
              at
              weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBea
              nImpl.java:458)
              at
              com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
              at
              com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
              at
              weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerI
              mpl.java:765)
              at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
              at
              weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java
              :481)
              at
              weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerM
              Bean_Stub.java:7271)
              at
              weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(Slave
              Deployer.java:1245)
              at
              weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:397
              )
              at
              weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(Deplo
              ymentManagerServerLifeCycleImpl.java:230)
              at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
              at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:964)
              at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:359)
              at weblogic.Server.main(Server.java:32)
              .
              java.io.IOException: JMS JDBC store, connection pool = <cgPool>, prefix =
              <weblogic>: change state
              java.sql.SQLException: ORA-00942: table or view does not exist

              at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
              at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
              at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
              at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
              at
              oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1094)
              at
              oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2132
              )
              at
              oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2015)
              at
              oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
              :2877)
              at
              oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
              ment.java:608)
              at
              weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java
              :95)
              at weblogic.jms.store.JDBCIOStream.changeState(JDBCIOStream.java:615)
              at weblogic.jms.store.JDBCIOStream.setVersion(JDBCIOStream.java:2057)
              at weblogic.jms.store.JDBCIOStream.open(JDBCIOStream.java:432)
              at weblogic.jms.store.JMSStore.open(JMSStore.java:224)
              at weblogic.jms.backend.BEStore.open(BEStore.java:262)
              at weblogic.jms.backend.BEStore.start(BEStore.java:151)
              at weblogic.jms.backend.BackEnd.openStores(BackEnd.java:1171)
              at weblogic.jms.backend.BackEnd.resume(BackEnd.java:1287)
              at weblogic.jms.JMSService.addJMSServer(JMSService.java:2167)
              at weblogic.jms.JMSService.addDeployment(JMSService.java:1938)
              at
              weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentT
              arget.java:330)
              at
              weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(Deployment
              Target.java:590)
              at
              weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(D
              eploymentTarget.java:568)
              at
              weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(Deploym
              entTarget.java:240)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at
              sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
              )
              at
              sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
              .java:25)
              at java.lang.reflect.Method.invoke(Method.java:324)
              at
              weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl
              .java:747)
              at
              weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:7
              26)
              at
              weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBea
              nImpl.java:458)
              at
              com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
              at
              com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
              at
              weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerI
              mpl.java:765)
              at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
              at
              weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java
              :481)
              at
              weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerM
              Bean_Stub.java:7271)
              at
              weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(Slave
              Deployer.java:1245)
              at
              weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:397
              )
              at
              weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(Deplo
              ymentManagerServerLifeCycleImpl.java:230)
              at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
              at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:964)
              at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:359)
              at weblogic.Server.main(Server.java:32)

              at
              weblogic.jms.store.JDBCIOStream.throwIOException(JDBCIOStream.java:369)
              at weblogic.jms.store.JDBCIOStream.changeState(JDBCIOStream.java:636)
              at weblogic.jms.store.JDBCIOStream.setVersion(JDBCIOStream.java:2057)
              at weblogic.jms.store.JDBCIOStream.open(JDBCIOStream.java:432)
              at weblogic.jms.store.JMSStore.open(JMSStore.java:224)
              at weblogic.jms.backend.BEStore.open(BEStore.java:262)
              at weblogic.jms.backend.BEStore.start(BEStore.java:151)
              at weblogic.jms.backend.BackEnd.openStores(BackEnd.java:1171)
              at weblogic.jms.backend.BackEnd.resume(BackEnd.java:1287)
              at weblogic.jms.JMSService.addJMSServer(JMSService.java:2167)
              at weblogic.jms.JMSService.addDeployment(JMSService.java:1938)
              at
              weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentT
              arget.java:330)
              at
              weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(Deployment
              Target.java:590)
              at
              weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(D
              eploymentTarget.java:568)
              at
              weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(Deploym
              entTarget.java:240)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at
              sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
              )
              at
              sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
              .java:25)
              at java.lang.reflect.Method.invoke(Method.java:324)
              at
              weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl
              .java:747)
              at
              weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:7
              26)
              at
              weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBea
              nImpl.java:458)
              at
              com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
              at
              com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
              at
              weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerI
              mpl.java:765)
              at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
              at
              weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java
              :481)
              at
              weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerM
              Bean_Stub.java:7271)
              at
              weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(Slave
              Deployer.java:1245)
              at
              weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:397
              )
              at
              weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(Deplo
              ymentManagerServerLifeCycleImpl.java:230)
              at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
              at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:964)
              at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:359)
              at weblogic.Server.main(Server.java:32)
              >
              ####<Dec 1, 2003 5:09:31 PM GMT-05:00> <Error> <JMS> <VERAX104> <cgServer>
              <main> <<WLS Kernel>> <> <BEA-040123> <Failed to start JMS Server
              "cgJMSServer" due to weblogic.jms.common.JMSException: JMS can not open
              store cgJMSStore.
              weblogic.jms.common.JMSException: JMS can not open store cgJMSStore
              at weblogic.jms.backend.BEStore.start(BEStore.java:163)
              at weblogic.jms.backend.BackEnd.openStores(BackEnd.java:1171)
              at weblogic.jms.backend.BackEnd.resume(BackEnd.java:1287)
              at weblogic.jms.JMSService.addJMSServer(JMSService.java:2167)
              at weblogic.jms.JMSService.addDeployment(JMSService.java:1938)
              at
              weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentT
              arget.java:330)
              at
              weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(Deployment
              Target.java:590)
              at
              weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(D
              eploymentTarget.java:568)
              at
              weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(Deploym
              entTarget.java:240)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at
              sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
              )
              at
              sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
              .java:25)
              at java.lang.reflect.Method.invoke(Method.java:324)
              at
              weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl
              .java:747)
              at
              weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:7
              26)
              at
              weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBea
              nImpl.java:458)
              at
              com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
              at
              com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
              at
              weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerI
              mpl.java:765)
              at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
              at
              weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java
              :481)
              at
              weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerM
              Bean_Stub.java:7271)
              at
              weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(Slave
              Deployer.java:1245)
              at
              weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:397
              )
              at
              weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(Deplo
              ymentManagerServerLifeCycleImpl.java:230)
              at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
              at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:964)
              at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:359)
              at weblogic.Server.main(Server.java:32)
              Caused by: java.io.IOException: JMS JDBC store, connection pool =
              <cgPool>,
              prefix = <weblogic>: change state
              java.sql.SQLException: ORA-00942: table or view does not exist

              at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
              at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
              at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
              at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
              at
              oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1094)
              at
              oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2132
              )
              at
              oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2015)
              at
              oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
              :2877)
              at
              oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
              ment.java:608)
              at
              weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java
              :95)
              at weblogic.jms.store.JDBCIOStream.changeState(JDBCIOStream.java:615)
              at weblogic.jms.store.JDBCIOStream.setVersion(JDBCIOStream.java:2057)
              at weblogic.jms.store.JDBCIOStream.open(JDBCIOStream.java:432)
              at weblogic.jms.store.JMSStore.open(JMSStore.java:224)
              at weblogic.jms.backend.BEStore.open(BEStore.java:262)
              at weblogic.jms.backend.BEStore.start(BEStore.java:151)
              at weblogic.jms.backend.BackEnd.openStores(BackEnd.java:1171)
              at weblogic.jms.backend.BackEnd.resume(BackEnd.java:1287)
              at weblogic.jms.JMSService.addJMSServer(JMSService.java:2167)
              at weblogic.jms.JMSService.addDeployment(JMSService.java:1938)
              at
              weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentT
              arget.java:330)
              at
              weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(Deployment
              Target.java:590)
              at
              weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(D
              eploymentTarget.java:568)
              at
              weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(Deploym
              entTarget.java:240)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at
              sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
              )
              at
              sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
              .java:25)
              at java.lang.reflect.Method.invoke(Method.java:324)
              at
              weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl
              .java:747)
              at
              weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:7
              26)
              at
              weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBea
              nImpl.java:458)
              at
              com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
              at
              com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
              at
              weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerI
              mpl.java:765)
              at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
              at
              weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java
              :481)
              at
              weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerM
              Bean_Stub.java:7271)
              at
              weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(Slave
              Deployer.java:1245)
              at
              weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:397
              )
              at
              weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(Deplo
              ymentManagerServerLifeCycleImpl.java:230)
              at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
              at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:964)
              at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:359)
              at weblogic.Server.main(Server.java:32)

              at
              weblogic.jms.store.JDBCIOStream.throwIOException(JDBCIOStream.java:369)
              at weblogic.jms.store.JDBCIOStream.changeState(JDBCIOStream.java:636)
              at weblogic.jms.store.JDBCIOStream.setVersion(JDBCIOStream.java:2057)
              at weblogic.jms.store.JDBCIOStream.open(JDBCIOStream.java:432)
              at weblogic.jms.store.JMSStore.open(JMSStore.java:224)
              at weblogic.jms.backend.BEStore.open(BEStore.java:262)
              at weblogic.jms.backend.BEStore.start(BEStore.java:151)
              ... 28 more
              >



              --
              Bob Li
              Senior Consultant
              bli@verax.ca
              "Karthi" <bkarthi@etnoteam.it> wrote in message
              news:3fc6195a$1@newsgroups.bea.com...
              For new domains,

              1. Create your domain with Domain configuration Wizard and specify the
              JDBC
              properties as below.

              For existing domains,

              1. Start the Weblogic server.

              Steps are
              2. In Administration Console, http://localhost:7001/console
              3. Select services, JDBC select cgPool
              4. set the jdbc URL
              5. set the jdbc driver


              How to disable Pointbase

              1. In the startWeblogic.cmd script of your domain set the variable
              pointbaseflag to false
              2. change the file db_settings.properties to oracle properties with the
              above values.

              After this restart your server.

              Karthi.


              "Bob Li" <bli@verax.ca> wrote in message
              news:3fc4e555@newsgroups.bea.com...
              Hi,

              When I create a new workshop application, some JMS store and queue are
              created by default to handle the asynchronous calls. The cgpool is
              configured to use the embeded pointbase database. Can I change this
              pool
              to
              point to a Oracle database? Since there are tables created inside the
              pointbase database, are there any sql scripts to create those tables
              in
              Oracle database?

              Thanks,
              Bob Li
              Senior Consultant
              bli@verax.ca

              • 4. Re: Pointbase
                3004
                Karthi,

                The aynchronous Control method and web services will use JMS queue behind
                the scene.

                Bob Li
                Senior Consultant
                bli@verax.ca

                "Karthi" <bkarthi@etnoteam.it> wrote in message
                news:3fccd553@newsgroups.bea.com...
                Hi bob,

                I think only the servers in the portal domain and integration domains uses
                some pre-configured
                connection pools, datasources and JMS Servers.So you will find the
                db_settings.properties file only in the

                So it is necessary when you start the server that all the DB resources are
                present and the communication from your
                App server and DB Server is correct.

                Check all the Connection Pools in your server that they are using Oracle
                instead of Pointbase. Its possible that some
                connection pools which you don't use in your application pointing to
                pointbase.

                Table will not be created during the Server startup. They will be created
                only during the domain creation or
                you explicity lanuch them in SQL*Plus.

                Hope this helps you.
                Karthi.

                "Bob Li" <bli@verax.ca> wrote in message
                news:3fcbbde3@newsgroups.bea.com...
                Hi Kathi,

                Please let me know how to specify the JDBC properties when I config a
                new
                domain.

                And I tried to follow the steps listed below to remove the pointbase
                server.
                I changed the JDBC URL and driver for the cbPool via console. And I set
                variable
                pointbaseflag to false in start scripts. But I could not find any
                db_settings.properties in my domain as my application is only a basic
                workshop application without Integration and Portal features.

                Then I tried to restart the server and got these exceptions without any
                tables created in my Oracle database.

                What's wrong? Is there any document talking about this?

                Thanks,
                Bob

                ####<Dec 1, 2003 5:09:31 PM GMT-05:00> <Alert> <JMS> <VERAX104>
                <cgServer>
                <main> <<WLS Kernel>> <> <BEA-040052> <JMSServer "cgJMSServer" store
                failed
                to open java.io.IOException: JMS JDBC store, connection pool = <cgPool>,
                prefix = <weblogic>: change state
                java.sql.SQLException: ORA-00942: table or view does not exist

                at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
                at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
                at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
                at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
                at
                oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1094)
                at
                oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2132
                )
                at
                oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2015)
                at
                oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
                :2877)
                at
                oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
                ment.java:608)
                at
                weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java
                :95)
                at weblogic.jms.store.JDBCIOStream.changeState(JDBCIOStream.java:615)
                at weblogic.jms.store.JDBCIOStream.setVersion(JDBCIOStream.java:2057)
                at weblogic.jms.store.JDBCIOStream.open(JDBCIOStream.java:432)
                at weblogic.jms.store.JMSStore.open(JMSStore.java:224)
                at weblogic.jms.backend.BEStore.open(BEStore.java:262)
                at weblogic.jms.backend.BEStore.start(BEStore.java:151)
                at weblogic.jms.backend.BackEnd.openStores(BackEnd.java:1171)
                at weblogic.jms.backend.BackEnd.resume(BackEnd.java:1287)
                at weblogic.jms.JMSService.addJMSServer(JMSService.java:2167)
                at weblogic.jms.JMSService.addDeployment(JMSService.java:1938)
                at
                weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentT
                arget.java:330)
                at
                weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(Deployment
                Target.java:590)
                at
                weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(D
                eploymentTarget.java:568)
                at
                weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(Deploym
                entTarget.java:240)
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                at
                sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
                )
                at
                sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
                .java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at
                weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl
                .java:747)
                at
                weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:7
                26)
                at
                weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBea
                nImpl.java:458)
                at
                com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
                at
                com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
                at
                weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerI
                mpl.java:765)
                at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
                at
                weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java
                :481)
                at
                weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerM
                Bean_Stub.java:7271)
                at
                weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(Slave
                Deployer.java:1245)
                at
                weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:397
                )
                at
                weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(Deplo
                ymentManagerServerLifeCycleImpl.java:230)
                at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
                at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:964)
                at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:359)
                at weblogic.Server.main(Server.java:32)
                .
                java.io.IOException: JMS JDBC store, connection pool = <cgPool>, prefix
                =
                <weblogic>: change state
                java.sql.SQLException: ORA-00942: table or view does not exist

                at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
                at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
                at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
                at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
                at
                oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1094)
                at
                oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2132
                )
                at
                oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2015)
                at
                oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
                :2877)
                at
                oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
                ment.java:608)
                at
                weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java
                :95)
                at weblogic.jms.store.JDBCIOStream.changeState(JDBCIOStream.java:615)
                at weblogic.jms.store.JDBCIOStream.setVersion(JDBCIOStream.java:2057)
                at weblogic.jms.store.JDBCIOStream.open(JDBCIOStream.java:432)
                at weblogic.jms.store.JMSStore.open(JMSStore.java:224)
                at weblogic.jms.backend.BEStore.open(BEStore.java:262)
                at weblogic.jms.backend.BEStore.start(BEStore.java:151)
                at weblogic.jms.backend.BackEnd.openStores(BackEnd.java:1171)
                at weblogic.jms.backend.BackEnd.resume(BackEnd.java:1287)
                at weblogic.jms.JMSService.addJMSServer(JMSService.java:2167)
                at weblogic.jms.JMSService.addDeployment(JMSService.java:1938)
                at
                weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentT
                arget.java:330)
                at
                weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(Deployment
                Target.java:590)
                at
                weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(D
                eploymentTarget.java:568)
                at
                weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(Deploym
                entTarget.java:240)
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                at
                sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
                )
                at
                sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
                .java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at
                weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl
                .java:747)
                at
                weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:7
                26)
                at
                weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBea
                nImpl.java:458)
                at
                com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
                at
                com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
                at
                weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerI
                mpl.java:765)
                at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
                at
                weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java
                :481)
                at
                weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerM
                Bean_Stub.java:7271)
                at
                weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(Slave
                Deployer.java:1245)
                at
                weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:397
                )
                at
                weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(Deplo
                ymentManagerServerLifeCycleImpl.java:230)
                at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
                at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:964)
                at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:359)
                at weblogic.Server.main(Server.java:32)

                at
                weblogic.jms.store.JDBCIOStream.throwIOException(JDBCIOStream.java:369)
                at weblogic.jms.store.JDBCIOStream.changeState(JDBCIOStream.java:636)
                at weblogic.jms.store.JDBCIOStream.setVersion(JDBCIOStream.java:2057)
                at weblogic.jms.store.JDBCIOStream.open(JDBCIOStream.java:432)
                at weblogic.jms.store.JMSStore.open(JMSStore.java:224)
                at weblogic.jms.backend.BEStore.open(BEStore.java:262)
                at weblogic.jms.backend.BEStore.start(BEStore.java:151)
                at weblogic.jms.backend.BackEnd.openStores(BackEnd.java:1171)
                at weblogic.jms.backend.BackEnd.resume(BackEnd.java:1287)
                at weblogic.jms.JMSService.addJMSServer(JMSService.java:2167)
                at weblogic.jms.JMSService.addDeployment(JMSService.java:1938)
                at
                weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentT
                arget.java:330)
                at
                weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(Deployment
                Target.java:590)
                at
                weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(D
                eploymentTarget.java:568)
                at
                weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(Deploym
                entTarget.java:240)
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                at
                sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
                )
                at
                sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
                .java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at
                weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl
                .java:747)
                at
                weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:7
                26)
                at
                weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBea
                nImpl.java:458)
                at
                com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
                at
                com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
                at
                weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerI
                mpl.java:765)
                at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
                at
                weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java
                :481)
                at
                weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerM
                Bean_Stub.java:7271)
                at
                weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(Slave
                Deployer.java:1245)
                at
                weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:397
                )
                at
                weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(Deplo
                ymentManagerServerLifeCycleImpl.java:230)
                at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
                at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:964)
                at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:359)
                at weblogic.Server.main(Server.java:32)
                >
                ####<Dec 1, 2003 5:09:31 PM GMT-05:00> <Error> <JMS> <VERAX104>
                <cgServer>
                <main> <<WLS Kernel>> <> <BEA-040123> <Failed to start JMS Server
                "cgJMSServer" due to weblogic.jms.common.JMSException: JMS can not open
                store cgJMSStore.
                weblogic.jms.common.JMSException: JMS can not open store cgJMSStore
                at weblogic.jms.backend.BEStore.start(BEStore.java:163)
                at weblogic.jms.backend.BackEnd.openStores(BackEnd.java:1171)
                at weblogic.jms.backend.BackEnd.resume(BackEnd.java:1287)
                at weblogic.jms.JMSService.addJMSServer(JMSService.java:2167)
                at weblogic.jms.JMSService.addDeployment(JMSService.java:1938)
                at
                weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentT
                arget.java:330)
                at
                weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(Deployment
                Target.java:590)
                at
                weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(D
                eploymentTarget.java:568)
                at
                weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(Deploym
                entTarget.java:240)
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                at
                sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
                )
                at
                sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
                .java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at
                weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl
                .java:747)
                at
                weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:7
                26)
                at
                weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBea
                nImpl.java:458)
                at
                com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
                at
                com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
                at
                weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerI
                mpl.java:765)
                at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
                at
                weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java
                :481)
                at
                weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerM
                Bean_Stub.java:7271)
                at
                weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(Slave
                Deployer.java:1245)
                at
                weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:397
                )
                at
                weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(Deplo
                ymentManagerServerLifeCycleImpl.java:230)
                at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
                at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:964)
                at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:359)
                at weblogic.Server.main(Server.java:32)
                Caused by: java.io.IOException: JMS JDBC store, connection pool =
                <cgPool>,
                prefix = <weblogic>: change state
                java.sql.SQLException: ORA-00942: table or view does not exist

                at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
                at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
                at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
                at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
                at
                oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1094)
                at
                oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2132
                )
                at
                oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2015)
                at
                oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
                :2877)
                at
                oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
                ment.java:608)
                at
                weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java
                :95)
                at weblogic.jms.store.JDBCIOStream.changeState(JDBCIOStream.java:615)
                at weblogic.jms.store.JDBCIOStream.setVersion(JDBCIOStream.java:2057)
                at weblogic.jms.store.JDBCIOStream.open(JDBCIOStream.java:432)
                at weblogic.jms.store.JMSStore.open(JMSStore.java:224)
                at weblogic.jms.backend.BEStore.open(BEStore.java:262)
                at weblogic.jms.backend.BEStore.start(BEStore.java:151)
                at weblogic.jms.backend.BackEnd.openStores(BackEnd.java:1171)
                at weblogic.jms.backend.BackEnd.resume(BackEnd.java:1287)
                at weblogic.jms.JMSService.addJMSServer(JMSService.java:2167)
                at weblogic.jms.JMSService.addDeployment(JMSService.java:1938)
                at
                weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentT
                arget.java:330)
                at
                weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(Deployment
                Target.java:590)
                at
                weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(D
                eploymentTarget.java:568)
                at
                weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(Deploym
                entTarget.java:240)
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                at
                sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
                )
                at
                sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
                .java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at
                weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl
                .java:747)
                at
                weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:7
                26)
                at
                weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBea
                nImpl.java:458)
                at
                com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
                at
                com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
                at
                weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerI
                mpl.java:765)
                at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
                at
                weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java
                :481)
                at
                weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerM
                Bean_Stub.java:7271)
                at
                weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(Slave
                Deployer.java:1245)
                at
                weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:397
                )
                at
                weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(Deplo
                ymentManagerServerLifeCycleImpl.java:230)
                at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
                at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:964)
                at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:359)
                at weblogic.Server.main(Server.java:32)

                at
                weblogic.jms.store.JDBCIOStream.throwIOException(JDBCIOStream.java:369)
                at weblogic.jms.store.JDBCIOStream.changeState(JDBCIOStream.java:636)
                at weblogic.jms.store.JDBCIOStream.setVersion(JDBCIOStream.java:2057)
                at weblogic.jms.store.JDBCIOStream.open(JDBCIOStream.java:432)
                at weblogic.jms.store.JMSStore.open(JMSStore.java:224)
                at weblogic.jms.backend.BEStore.open(BEStore.java:262)
                at weblogic.jms.backend.BEStore.start(BEStore.java:151)
                ... 28 more
                >



                --
                Bob Li
                Senior Consultant
                bli@verax.ca
                "Karthi" <bkarthi@etnoteam.it> wrote in message
                news:3fc6195a$1@newsgroups.bea.com...
                For new domains,

                1. Create your domain with Domain configuration Wizard and specify the
                JDBC
                properties as below.

                For existing domains,

                1. Start the Weblogic server.

                Steps are
                2. In Administration Console, http://localhost:7001/console
                3. Select services, JDBC select cgPool
                4. set the jdbc URL
                5. set the jdbc driver


                How to disable Pointbase

                1. In the startWeblogic.cmd script of your domain set the variable
                pointbaseflag to false
                2. change the file db_settings.properties to oracle properties with
                the
                above values.

                After this restart your server.

                Karthi.


                "Bob Li" <bli@verax.ca> wrote in message
                news:3fc4e555@newsgroups.bea.com...
                Hi,

                When I create a new workshop application, some JMS store and queue
                are
                created by default to handle the asynchronous calls. The cgpool is
                configured to use the embeded pointbase database. Can I change this
                pool
                to
                point to a Oracle database? Since there are tables created inside
                the
                pointbase database, are there any sql scripts to create those tables
                in
                Oracle database?

                Thanks,
                Bob Li
                Senior Consultant
                bli@verax.ca

                • 5. Re: Pointbase
                  666705
                  Did you find the solution to this issue? We are seeing the exact same problem with our integration domain production configuration using Oracle database.

                  It seems that there are tables missing in Oracle that get created automatically in the Pointbase database when running a development domain.

                  Stephen Cross
                  MetaSolv Software