Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Help with Oracel JDBC JDriver vs Thin

1 view
Skip to first unread message

Brad@nowhere

unread,
Apr 1, 2003, 1:43:41 PM4/1/03
to
Hi All,
I have an update:
I can get the JDriver to work but not the oracle thin driver

<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)
>


Mitesh Patel

unread,
Apr 1, 2003, 3:12:42 PM4/1/03
to
Message-ID: <3E89F2B9...@bea.com>
Date: Tue, 01 Apr 2003 15:12:42 -0500
From: Mitesh Patel <Mitesh...@bea.com>
Organization: BEA Systems Inc.
X-Mailer: Mozilla 4.73 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: weblogic.developer.interest.jdbc
Subject: Re: Help with Oracel JDBC JDriver vs Thin
References: <1104_10...@newsgroups.bea.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 216.148.48.12
X-Original-NNTP-Posting-Host: 216.148.48.12
X-Trace: newsgroups.bea.com 1049226617 216.148.48.12 (1 Apr 2003 11:50:17 -0800)
X-Original-Trace: 1 Apr 2003 11:50:17 -0800, 216.148.48.12
Lines: 93
XPident: Unknown
Path: newsgroups.bea.com!not-for-mail
Xref: newsgroups.bea.com weblogic.developer.interest.jdbc:16561

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

0 new messages