<JDBCConnectionPool
DriverName="weblogic.jdbc.oci.Driver"
Name="oracleOCIPool"
Password="{3DES}C3xDZIWIABA="
Properties="user=SYSTEM;server=SID"
Targets="GServer"
TestTableName="OID"
URL="jdbc:weblogic:oracle"/>
<JDBCConnectionPool
DriverName="oracle.jdbc.driver.OracleDriver"
Name="oracleThinPool"
Password="{3DES}C3xDZIWIABA="
Properties="user=SYSTEM"
Targets="GServer"
TestTableName="OID"
URL="jdbc:oracle:thin:@localhost:1521:SID"/>
<JDBCDataSource
JNDIName="oracleDS"
Name="oracleDS"
PoolName="oracleOCIPool"
Targets="GServer"/>
<JDBCTxDataSource
JNDIName="oracleThinTxDS"
Name="oracleThinTxDS"
PoolName="oracleThinPool"
Targets="GServer"/>
Here is the error I still get:
####<Apr 1, 2003 11:09:42 AM MST> <Info> <JDBC> <blue> <GServer> <main> <kernel identity> <> <001090> <Pool
"oracleThinPool" will not be periodically tested once connected.>
####<Apr 1, 2003 11:09:42 AM MST> <Info> <JDBC> <blue> <GServer> <main> <kernel identity> <> <001090> <Pool
"oracleOCIPool" will not be periodically tested once connected.>
####<Apr 1, 2003 11:09:45 AM MST> <Info> <JDBC> <blue> <GServer> <main> <kernel identity> <> <001068> <Connection
for pool "oracleOCIPool" created.>
####<Apr 1, 2003 11:09:45 AM MST> <Info> <JDBC> <blue> <GServer> <main> <kernel identity> <> <001082> <Creating Data
Source named oracleDS for pool oracleOCIPool>
####<Apr 1, 2003 11:09:45 AM MST> <Info> <JDBC> <blue> <GServer> <main> <kernel identity> <> <001070> <Checking
existence of connection pool oracleOCIPool requested by user principals=[kernel identity = 1873602152]>
####<Apr 1, 2003 11:09:45 AM MST> <Info> <JDBC> <blue> <GServer> <main> <kernel identity> <> <001071> <Creating TX
Data Source named oracleThinTxDS for pool oracleThinPool>
####<Apr 1, 2003 11:09:45 AM MST> <Info> <JDBC> <blue> <GServer> <main> <kernel identity> <> <001070> <Checking
existence of connection pool oracleThinPool requested by user principals=[kernel identity = 1873602152]>
####<Apr 1, 2003 11:09:45 AM MST> <Error> <JDBC> <blue> <GServer> <main> <kernel identity> <> <001059> <Error during
Data Source creation: weblogic.common.ResourceException: DataSource(oracleThinTxDS) can't be created with non-existent Pool
(connection or multi) (oracleThinPool)
at weblogic.jdbc.common.internal.JdbcInfo.validateConnectionPool(JdbcInfo.java:127)
at weblogic.jdbc.common.internal.JdbcInfo.startDataSource(JdbcInfo.java:189)
at weblogic.jdbc.common.internal.JDBCService.addDeploymentx(JDBCService.java:293)
at weblogic.jdbc.common.internal.JDBCService.addDeployment(JDBCService.java:270)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentTarget.java:375)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(DeploymentTarget.java:303)
at weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(DeploymentTarget.java:256)
at weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(DeploymentTarget.java:207)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:732)
at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:714)
at weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:417)
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(RemoteMBeanServerImpl.java:952)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:470)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:198)
at $Proxy36.updateDeployments(Unknown Source)
at weblogic.management.configuration.ServerMBean_CachingStub.updateDeployments(ServerMBean_CachingStub.java:4114)
at weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(SlaveDeployer.java:2257)
at weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:373)
at weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(DeploymentManagerServerLifeCycleImpl.java:235)
at weblogic.t3.srvr.ServerLifeCycleList.resume(ServerLifeCycleList.java:65)
at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:832)
at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:300)
at weblogic.Server.main(Server.java:32)
>
Which version of weblogic are you using?
Make sure your environment is set properly. You can check that by running the following command:
java utils.dbping ORACLE_THIN uname pwd mcname:port:dbname
If it is successful do following:
Add "Targets" attribute to the connection pool. You may
get an idea how it looks like by searching config.xml
for "targets". If target servers are not set, the pool won't be
deployed and can not be used to a create datasource.
Thanks,
Mitesh