2 messages in com.mysql.lists.javasudden mm.mysql problems
FromSent OnAttachments
Jiann-Ming Su06 Jun 2002 10:41 
Jiann-Ming Su06 Jun 2002 12:01 
Subject:sudden mm.mysql problems
From:Jiann-Ming Su (js@emory.edu)
Date:06/06/2002 10:41:37 AM
List:com.mysql.lists.java

For some reason, our jdbc connection is no longer coming back up, and I have no idea why. I get the following in catalina.out:

Starting service Tomcat-Standalone Apache Tomcat/4.0.3 ConnectionPool: JDBCDriver = org.gjt.mm.mysql.Driver ConnectionPool: JDBCConnectionURL = "jdbc:mysql://localhost/arc" ConnectionPool: ConnectionPoolSize = 5 ConnectionPool: ConnectionPoolMax = 100 ConnectionPool: ConnectionUseCount = 5 ConnectionPool: ConnectionTimeout = 100 seconds ConnectionPool: (JDBC Property) Password = dbpassword ConnectionPool: (JDBC Property) User = dbadmin ConnectionPool: Registering org.gjt.mm.mysql.Driver java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(DriverManager.java:532) at java.sql.DriverManager.getConnection(DriverManager.java:171) at db.ConnectionPool.fillPool(Unknown Source) at db.ConnectionPool.createPool(Unknown Source) at db.ConnectionPool.initialize(Unknown Source) at db.ConnectionPool.initialize(Unknown Source) at db.ConnectionServlet.init(Unknown Source) at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:9 16) at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:808) at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java :3266) at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3395) at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:785) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:454) at org.apache.catalina.core.StandardHost.install(StandardHost.java:714) at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:300) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:389) at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:232) at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppo rt.java:155) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1131) at org.apache.catalina.core.StandardHost.start(StandardHost.java:614) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343) at
org.apache.catalina.core.StandardService.start(StandardService.java:388) at
org.apache.catalina.core.StandardServer.start(StandardServer.java:506) at org.apache.catalina.startup.Catalina.start(Catalina.java:781) at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) at org.apache.catalina.startup.Catalina.process(Catalina.java:179) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3 9) at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp l.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)

I've gone through several interations on different $CLASSPATH combinations but haven't found anything to be useful. Here's the $CLASSPATH that is being passed to tomcat:

Jun 6 12:14:57 myserver su(pam_unix)[870]: session closed for user tomcat4 Jun 6 12:14:57 myserver su: dtomcat4:
.:/home/tomcat4/webapps/oai/WEB-INF/lib/classes12.zip:/home/tomcat4/webapps/oai/WEB-INF/lib/crimson.jar:/home/tomcat4/webapps/oai/WEB-INF/lib/jaxp.jar:/home/tomcat4/webapps/oai/WEB-INF/lib/xalan.jar:/home/tomcat4/webapps/oai/WEB-INF/lib/jndi.jar:/home/tomcat4/webapps/oai/WEB-INF/lib/servlet.jar:/home/tomcat4/webapps/oai/WEB-INF/lib/mm.mysql-2.0.8-bin.jar Jun 6 12:14:57 myserver su: Using CATALINA_BASE: /home/tomcat4 Jun 6 12:14:57 myserver su: Using CATALINA_HOME: /home/tomcat4 Jun 6 12:14:57 myserver su: Using CATALINA_TMPDIR: /home/tomcat4/temp Jun 6 12:14:57 myserver su: Using JAVA_HOME: /usr/java/j2sdk1.4.0 Jun 6 12:14:57 myserver tomcat4: dtomcat4 startup succeeded

What's most strange is this particular server was working fine the other day, but when when we shutdown and started tomcat again, the jdbc connection would not come back up. I've got 2.0.8 installed in the servlet lib directory as well as 2.0.14 in $JAVA_HOME/jre/lib/ext/ as described in the README. I am all out of ideas as to why the jdbc connection will not come back up. Tomcat runs fine. The servlet runs fine, except the module that requires the jdbc connection. Any help would be greatly appreciated.