oracle connection pool startup problem ('No suitable driver')

Thomas

unread,

Sep 24, 2001, 8:04:59 AM9/24/01

to

Hello,

I have problems generating a connection pool with WLS6.1 and Oracle8.1.7 on WinNT4.

The command line test tool runs fine:
:/> java utils.t3dbping t3://127.0.0.1:7001 testuser testpassword Cargo1DB oracle.jdbc.driver.OracleDriver
./lib/classes12.zip

I have classes12.zip in the classpath (after editing startWebLogic.cmd and restarting
WLS):
set CLASSPATH=d:\ecargo~1\lib\classes12.zip;.\lib\weblogic.jar;.;.\lib\weblogic_sp.jar;

The part in config.xml looks like this:
<JDBCConnectionPool
CapacityIncrement="5"
ConnLeakProfilingEnabled="false"
DeploymentOrder="1000"
DriverName="oracle.jdbc.driver.OracleDriver"
EnableResourceHealthMonitoring="true"
InitialCapacity="5"
JDBCXADebugLevel="0"
KeepLogicalConnOpenOnRelease="false"
KeepXAConnTillTxComplete="false"
LoginDelaySeconds="0"
MaxCapacity="50"
Name="oraclePool"
NeedTxCtxOnClose="false"
NewXAConnForCommit="false"
PrepStmtCacheProfilingEnabled="false"
PrepStmtCacheProfilingThreshold="10"
PreparedStatementCacheSize="10"
Properties="user=ecargoneu;password=ecargo"
RecoverOnlyOnce="false"
RefreshMinutes="0"
ShrinkPeriodMinutes="15"
ShrinkingEnabled="true"
SqlStmtMaxParamLength="10"
SqlStmtParamLoggingEnabled="false"
SqlStmtProfilingEnabled="false"
SupportsLocalTransaction="false"
Targets="ecargoWebAppServer"
TestConnectionsOnRelease="false"
TestConnectionsOnReserve="false"
TestTableName="ibenutzer"
URL="jdbc:oracle:this:@ul20010081:1521:cargo1"
XAEndOnlyOnce="false"/>

The config was done via the webconsole. When I try to chose a target-server I
get following exception:
<24.09.2001 13:01:17 CEST> <Error> <JDBC> <Cannot startup connection pool "oraclePool"
No suitable driver>
weblogic.management.DistributedManagementException: Distributed Management [1
exceptions]
at weblogic.management.internal.ConfigurationMBeanImpl.updateConfigMBeans(ConfigurationMBeanImpl.java:532)
at
.. (and a long list with exception-output, if you wish I can send it)

Help needed, can someone explain what I am doing wrong?

regards,

Thomas

unread,

Sep 24, 2001, 8:31:31 AM9/24/01

to

Hi, it's me again:

I changed

> URL="jdbc:oracle:this:@ul20010081:1521:cargo1"

to
jdbc:oracle:thin:@ul20010081:1521:cargo1
(thin - this - oops)

but I get another exception:
<24.09.2001 13:20:14 CEST> <Error> <JDBC> <Cannot startup connection pool "oraclePool"
weblogic.common.ResourceException:
Could not create pool connection. The DBMS driver exception was:
java.sql.SQLException: Ungłltige Argumente in Aufruf
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
... and again a long list with exception output

WLS automaticly adds some properties:
dll=ocijdbc8
protocol=thin

But I don't want to connect via oci. Can I WLS say not to use this?

regards,

Thomas

unread,

Sep 24, 2001, 9:41:49 AM9/24/01

to

Hi,

the problem is no longer a problem.
After changing the URL and using the right JNDI-Name in my code the app runs fine.

regards,

Thomas

Sree Bodapati

unread,

Sep 27, 2001, 12:45:58 PM9/27/01

to

Also weblogic_sp.jar file should always be before the weblogic.jar. If you
switch them you are effectively ignoring the service pack.

/
sree

"Thomas" <tom...@gmx.de> wrote in message
news:3baf135b$1...@newsgroups.bea.com...