Does anyone know how to set up a connection pool to the MySQL database in
weblogic.properties?
I tried to set it up as follows:
weblogic.jdbc.connectionPool.mysqlConnPool=\
url=jdbc:mysql:localhost:3306,\
driver=org.gjt.mm.mysql.Driver,\
loginDelaySecs=1,\
initialCapacity=5,\
maxCapacity=10,\
capacityIncrement=1,\
allowShrinking=true,\
shrinkPeriodMins=15,\
testTable=weblogic,\
refreshTestMinutes=45,\
props=user=user_db;password=pass;server=none
The placed the JDBC driver's JAR on the weblogic classpath.
When I start weblogic, I get the following exception (below).
Many thanks.
-Lenny Reinstein, New York.
-------------------------------------
Mon Jan 28 07:43:14 EST 2002:<I> <JDBC Pool> Sleeping in createResource()
Mon Jan 28 07:43:15 EST 2002:<E> <JDBC Pool> Failed to create connection
pool "mysqlConnPool"
weblogic.common.ResourceException: java.lang.NullPointerException
at
weblogic.jdbc.common.internal.ConnectionMOWrapper.<init>(ConnectionMOWrapper
.java:42)
at
weblogic.jdbc.common.internal.ConnectionEnv.setConnection(ConnectionEnv.java
:142)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(Connection
EnvFactory.ja
va:108)
at
weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator.j
ava:771)
at
weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.java:416
)
at
weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:330
)
at
weblogic.jdbc.common.internal.JdbcInfo.initPools(JdbcInfo.java:117)
at weblogic.jdbc.common.internal.JdbcInfo.startup(JdbcInfo.java:200)
at
weblogic.jdbc.common.internal.JdbcStartup.main(JdbcStartup.java:11)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.t3.srvr.StartupThread.runMain(StartupThread.java:219)
at weblogic.t3.srvr.StartupThread.doWork(StartupThread.java:109)
at
weblogic.t3.srvr.PropertyExecuteThread.run(PropertyExecuteThread.java:62)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
