This config worked for me: weblogic.jdbc.connectionPool.PoolName=\ url=jdbc:mysql://localhost:3306/test,\ driver=org.gjt.mm.mysql.Driver,\ initialCapacity=1,\ maxCapacity=10,\ capacityIncrement=1,\ props=user=DBUser;password=DBPassword
weblogic.jdbc.TXDataSource.weblogic.jdbc.jts.PoolName=PoolName weblogic.allow.reserve.weblogic.jdbc.connectionPool.PoolName=everyone cheers - Rich -----Original Message----- From: Reinstein, Lenny [mailto:[EMAIL PROTECTED]] Sent: Monday, January 28, 2002 1:47 PM To: [EMAIL PROTECTED] Subject: MySQL JDBC setup in weblogic. 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 --------------------------------------------------------------------- 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
