2 messages in com.mysql.lists.javasudden mm.mysql problems| From | Sent On | Attachments |
|---|---|---|
| Jiann-Ming Su | 06 Jun 2002 10:41 | |
| Jiann-Ming Su | 06 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.
-- Jiann-Ming Su js...@emory.edu 404-712-2603 Development Team Systems Administrator General Libraries Systems Division




