Question regarding Tomcat's JDBCStore

Discussion in 'Java' started by Xocomil, Jun 30, 2004.

  1. Xocomil

    Xocomil Guest

    I am trying to implement Tomcat's JDBCStore to get some session
    persistance across three servers that I am load-balancing. I am
    running Tomcat 4.1 and Oracle 9i. My connection context in server.xml
    is:

    <Context path="" docBase="myDocBase..." debug="0">
    <Manager className="org.apache.catalina.session.PersistentManager"
    debug="999" saveOnRestart="true" maxActiveSessions="-1"
    minIdleSwap="-1" maxIdleSwap="-1" maxIdleBackup="1">
    <Store className="org.apache.catalina.session.JDBCStore"
    driverName="oracle.jdbc.driver.OracleDriver"
    connectionURL="myConnectionString..."
    sessionTable="tomcat$sessions"
    sessionIdCol="id"
    sessionDataCol="data"
    sessionValidCol="valid"
    sessionMaxInactiveCol="maxinactive"
    sessionLastAccessedCol="lastaccess"
    sessionAppCol="appname"
    checkInterval="60"
    debug="999"
    />
    </Manager>
    </Context>

    Tomcat seems to connect just fine, but when trying to store my
    sessions to the database I get the following errors in my log (or
    something similar):

    2004-06-30 10:29:32 PersistentManager[]: writeObject() storing session
    C3B86F0980DE63689A8D296AF0161D41
    2004-06-30 10:29:32 PersistentManager[]: storing attribute 'CARS'
    with value 'com.ucoast.model.beans.CarBeanCollection@1706eb7'
    2004-06-30 10:29:33 PersistentManager[]: storing attribute
    'CARFINDERS' with value
    'com.ucoast.model.beans.CarFinderBeanCollection@1fe4169'
    2004-06-30 10:29:35 JDBCStore[]: SQL Error java.sql.SQLException: No
    more data to read from socket
    2004-06-30 10:29:35 JDBCStore[]: Saving Session
    B86F0980DE63689A8D296AF0161D41 to database tomcat$sessions
    2004-06-30 10:30:32 JDBCStore[]: SQL Error java.sql.SQLException: No
    more data to read from socket

    After this happens, I get a java.sql.SQLException: Io exception:
    Broken pipe every time Tomcat tries to write to the database. Is there
    something glaringly wrong with my set-up? Has anyone run into this
    problem before that could point me in a good direction to troubleshoot
    this? The error logs aren't very descriptive or helpful.
    Xocomil, Jun 30, 2004
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. %=zerointeractive.it%

    [TOMCAT] Tomcat crashes

    %=zerointeractive.it%, Jan 22, 2004, in forum: Java
    Replies:
    1
    Views:
    398
    Erwin Moller
    Jan 22, 2004
  2. Christos Gravvanis
    Replies:
    0
    Views:
    2,021
    Christos Gravvanis
    Jul 7, 2004
  3. Sean Berry
    Replies:
    3
    Views:
    4,531
    Tim Terry
    Dec 19, 2005
  4. Replies:
    0
    Views:
    337
  5. nek
    Replies:
    0
    Views:
    264
Loading...

Share This Page