Tomcat 6.0.14 PersistentManager/JDBCStore

[Timothy Wonil Lee <ti...@koorong.com.au>]

Greetings, all

I might be completely off track (hope not!), but I am trying to achieve
session replication by using JDBCStore and PersistentManager with a shared
database.
I noticed that the sessions are not persisted in database until I stop the
application (or stop Tomcat) and this is a problem for me since I want to
use this session replication as a mean to clustering. (instead of using
SimpleTcpCluster)

Has anybody succeeded using database as session storage while having several
tomcat instances sharing one? (and achieving clustering in effect?)


My configs:
Tomcat 6.0.14
Java 6
DB: mysql 5

context.xml used in my application

<Context path="/LocalhostTest" distributable="true">
  <Manager className="org.apache.catalina.session.PersistentManager"
           saveOnRestart="true" >
    <Store className="org.apache.catalina.session.JDBCStore"
           driverName="com.mysql.jdbc.Driver"
           connectionName="sessionManager"
           connectionPassword="smPassword"
           connectionURL="jdbc:mysql://localhost:3306/sessions"
           sessionAppCol="app_name"
           sessionDataCol="session_data"
           sessionIdCol="session_id"
           sessionLastAccessedCol="last_access"
           sessionMaxInactiveCol="max_inactive"
           sessionTable="tomcat_sessions"
           sessionValidCol="valid_session" />
  </Manager>
</Context>


Thank you for help.


Timothy Wonil Lee

Java Developer
Koorong Books (http://www.koorong.com/)
email: timothyl@koorong.com
direct ph: (+612) 9857 4448
direct fax: (+612) 9857 6648
http://timundergod.blogspot.com/
http://www.google.com/reader/shared/16849249410805339619



---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org