Hi!
I'm trying to use JDBCStore with mySQL under Win98. It looks like Tomcat can
connect to the database I get to see the created process in the Process list
in the WinMySQLadmin-Programm, but no entries are sent to the database.
Instead I get the following Exception:
l
ocalhost_log.txt:
2003-07-03 19:49:49 StandardHost[localhost]: Removing web application at
context path /Portal.war
2003-07-03 19:49:49 PersistentManager[/Portal.war]: Stopping
2003-07-03 19:49:49 StandardHost[localhost]: Error removing application at
context path /Portal.war
java.lang.NullPointerException
at org.apache.catalina.session.JDBCStore.stop(JDBCStore.java:762)
at
org.apache.catalina.session.PersistentManagerBase.stop(PersistentManagerBase
.java:875)
at org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1184)
at org.apache.catalina.core.StandardContext.stop(StandardContext.java:3440)
at
org.apache.catalina.core.ContainerBase.removeChild(ContainerBase.java:983)
at org.apache.catalina.core.StandardHost.remove(StandardHost.java:789)
at org.apache.catalina.startup.HostConfig.undeployApps(HostConfig.java:843)
at org.apache.catalina.startup.HostConfig.stop(HostConfig.java:803)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:467)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor
t.java:155)
at org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1151)
at org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1163)
at org.apache.catalina.core.StandardService.stop(StandardService.java:435)
at org.apache.catalina.core.StandardServer.stop(StandardServer.java:534)
at org.apache.catalina.startup.Catalina.start(Catalina.java:794)
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:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
2003-07-03 19:49:49 HostConfig[localhost] Error undeploying web application
at context path /Portal.war
java.io.IOException: java.lang.NullPointerException
at org.apache.catalina.core.StandardHost.remove(StandardHost.java:792)
at org.apache.catalina.startup.HostConfig.undeployApps(HostConfig.java:843)
at org.apache.catalina.startup.HostConfig.stop(HostConfig.java:803)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:467)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor
t.java:155)
at org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1151)
at org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1163)
at org.apache.catalina.core.StandardService.stop(StandardService.java:435)
at org.apache.catalina.core.StandardServer.stop(StandardServer.java:534)
at org.apache.catalina.startup.Catalina.start(Catalina.java:794)
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:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
apache_log.txt:
2003-07-03 19:49:49 [org.apache.catalina.connector.warp.WarpConnector] Error
accepting requests
java.net.SocketException: socket closed
at java.net.PlainSocketImpl.socketAccept(Native Method)
at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:353)
at java.net.ServerSocket.implAccept(ServerSocket.java:448)
at java.net.ServerSocket.accept(ServerSocket.java:419)
at
org.apache.catalina.connector.warp.WarpConnector.run(WarpConnector.java:580)
at java.lang.Thread.run(Thread.java:536)
the other logs seem to be all right.
I've put the following lines in the server.xml as my application context:
<!-- SEP Portal Context -->
<Context path="/Portal.war" docBase="Portal" debug="0"
reloadable="true">
<!-- Manager for mySQL-Database -->
<Manager className="org.apache.catalina.session.PersistentManager"
debug="99"
saveOnRestart="true"
maxActiveSessions="-1"
minIdleSwap="-1"
maxIdleSwap="-1"
maxIdleBackup="-1">
<Store className="org.apache.catalina.session.JDBCStore"
driverName="org.gjt.mm.mysql.Driver"
connectionURL="jdbc:mysql://localhost/tomcatsessions?user=ODBC"
sessionTable="sessions"
sessionIdCol="id"
sessionDataCol="data"
sessionValidCol="valid"
sessionMaxInactiveCol="maxinactive"
sessionLastAccessedCol="lastaccess"
checkInterval="60"
debug="99" />
</Manager>
</Context>
After the time specified under checkInterval has passed the tomcat program
window (i.e. MS-Dos Window I get when I start tomcat) displays the following
message:
Starting service Tomcat-Apache
Apache Tomcat/4.0.1
java.io.IOException: Stream closed
at
java.io.BufferedInputStream.ensureOpen(BufferedInputStream.java:120)S
topping service Tomcat-Standalone
at java.io.BufferedInputStream.read(BufferedInputStream.java:270)
at
java.io.ObjectInputStream$PeekInputStream.read(ObjectInputStream.java
:2150)
at
java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream
.java:2163)
at
java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputS
tream.java:2634)
at
java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:734
)
at java.io.ObjectInputStream.<init>(ObjectInputStream.java:253)
at
org.apache.catalina.util.CustomObjectInputStream.<init>(CustomObjectI
nputStream.java:103)
at org.apache.catalina.session.JDBCStore.load(JDBCStore.java:518)
at
org.apache.catalina.session.StoreBase.processExpires(StoreBase.java:2
95)
at org.apache.catalina.session.StoreBase.run(StoreBase.java:350)
at java.lang.Thread.run(Thread.java:536)
Stopping service Tomcat-Apache
Any suggestions are greatly appreciated!!!
Stephan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]