Problem Creating ConnectionPool using oracle thin driver in WLS 7.0 1

[SimonKelly]

I get an error that no suitable driver is found at server startup and that a Connection Pool cannot be created.

I have tested the connection using util.dbping provided by BEA and have been successful. I made sure that the classpath and path variables for the server are identical to those in place when I run dbping.

I still have the same problem!

The following is my path and classpath as verified by server console upon startup:


CLASSPATH=C:\jdev_9i\jdbc\lib\classes12.jar;C:\jdev_9i\jdbc\lib\classes111.jar;C:\bea\jdk131_03\libtools.jar;C:\bea\weblogic700\server\lib\weblogic_sp.jar;C:\bea\weblogic700\server\lib\weblogic.jar

PATH=.;C:\bea\weblogic700\server\bin;C:\bea\jdk131_03\bin;C:\bea\weblogic700\server\bin\oci817_8;Cra817\bin


Here, also, is the error message received upon startup:

<Dec 13, 2002 11:39:13 AM MST> <Error> <JDBC> <001060> <Cannot startup connection pool &quot;MyConnection
Pool&quot; java.sql.SQLException: No suitable driver>
<Dec 13, 2002 11:39:13 AM MST> <Error> <JDBC> <001059> <Error during Data Source creation: weblogic.
common.ResourceException: DataSource(MyDataSource) can't be created with non-existent Pool (connecti
on or multi) (MyConnectionPool)
at weblogic.jdbc.common.internal.JdbcInfo.validateConnectionPool(JdbcInfo.java:127)
at weblogic.jdbc.common.internal.JdbcInfo.startDataSource(JdbcInfo.java:260)
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:37
5)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(DeploymentTarget.java:3
03)
at weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(DeploymentTarg
et.java:256)
at weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(DeploymentTarget.jav
a: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:41
7)
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:926)

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_C
achingStub.java:4060)
at weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(SlaveDeployer.java
:2259)
at weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:373)
at weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(DeploymentManagerS
erverLifeCycleImpl.java:235)
at weblogic.t3.srvr.ServerLifeCycleList.resume(ServerLifeCycleList.java:61)
at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:806)
at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:295)
at weblogic.Server.main(Server.java:32)


Lastly, here are the relevant parts of my config.xml file for the domain.



<JDBCConnectionPool DriverName=&quot;oracle.jdbc.driver.OracleDriver&quot; MaxCapacity=&quot;5&quot; Name=&quot;MyConnectionPool&quot; Password=&quot;{3DES}OD0cIz1ljJk=&quot; Properties=&quot;user=fred&quot; Targets=&quot;MyServer&quot; TestTableName=&quot;dual&quot; URL=&quot;jdbcracle:thin@host:1521racleInstanceName&quot; />
<JDBCDataSource JNDIName=&quot;MyDataSource&quot; Name=&quot;MyDataSource&quot; PoolName=&quot;MyConnectionPool&quot; Targets=&quot;MyServer&quot; />



I would greatly appreciate any help that can be offered on this matter.

Thanks in advance....

 

[jshandel]

Not sure if you resolved this or not ....

I just fought with this not long ago. Perhaps you still need this information? I think the key is to have only a username and password defined in properties. Leave ACLname blank without passwords (unrestricted access to the connection pool)

<JDBCConnectionPool CapacityIncrement=&quot;5&quot;
DriverName=&quot;oracle.jdbc.driver.OracleDriver&quot;
InitialCapacity=&quot;25&quot;
MaxCapacity=&quot;100&quot;
Name=&quot;optPool&quot;
Properties=&quot;user=<oracle-user-name>;
password=<users-password>;
url=jdbcracle:thin<oracle-server>:1521:<SID>;
dll=ocijdbc8;protocol=thin&quot;
RefreshMinutes=&quot;60&quot; Targets=&quot;<weblogic-server-name>&quot;
TestConnectionsOnRelease=&quot;true&quot;
TestConnectionsOnReserve=&quot;true&quot;
TestTableName=&quot;dual&quot;
URL=&quot;jdbcracle:thin<oracle-server>:1521:<SID>&quot;/>

 

[sunj2ee]

Plese try using url=jdbcracleci8host:1521. Hope this should work.

Hemant Khodaskar

 

[ryildirim00]

Check if classes12.zip is where weblogic.jar is..
Namely, {weblogic}/server/lib. If not copy from
{weblogic}/server/ext/jdbc/oracle/{oracle_version}
Or copy from oracle jdbc/lib directory...

 

[japdos]

The URL must be ....thin NOT ...thin@ thats all