Session Persistance

[susantpatnaik]

Hi All,
I am trying to achive http session persistance using jboss-tomcat55.sar and modifying context.xml






Can anybody help am i in right direction for doing HttpSessionPersistance,Please give your input.



Many Thanks,
Susanta Patnayak

[susantpatnaik]

<Manager pathname="SESSIONS.ser" path=""
 className="org.apache.catalina.session.PersistentManager"
 debug="0"
 saveOnRestart="true"
 minIdleSwap="900"
 maxIdleSwap="1200"
 maxIdleBackup="600">
 <Store
 className="org.apache.catalina.session.JDBCStore"
 driverName="org.gjt.mm.mysql.Driver"
 connectionURL=
 "jdbc:mysql://localhost/test?user=root&password=root"
 sessionTable="tomcat_session"
 sessionIdCol="id"
 sessionAppCol="app"
 sessionDataCol="data"
 sessionValidCol="valid_session"
 sessionMaxInactiveCol="max_inactive"
 sessionLastAccessedCol="last_access"
 />
 </Manager>

[susantpatnaik]

Hi All,
i m again here.
i m trying this configuration using mysql as database.
i m gettting this message in JbossApp.Server while starting Application server and i m using jboss4.0.3sp1.

[[/test]] The database connection is null or was found to be closed. Trying to re-open it

but when ever i m shutting down application server it stores the session into database, and another problem i m facing is i m not getting all web application's session persistance.What could be the reason if any body will reply it will be highly Appriciatable.


Many Thanks,
Susanta Patnayak

[mpunhani]

Did you find a solution to this problem..I'm running into same problem with similar configuration. Error message is same as yours:

"The database connection is null or was found to be closed. Trying to re-open it"

and then it comes back with a NullPointerException.


Thanks
-Mukesh

"susantpatnaik" wrote:
Hi All,
i m again here.
i m trying this configuration using mysql as database.
i m gettting this message in JbossApp.Server while starting Application server and i m using jboss4.0.3sp1.

[[/test]] The database connection is null or was found to be closed. Trying to re-open it

but when ever i m shutting down application server it stores the session into database, and another problem i m facing is i m not getting all web application's session persistance.What could be the reason if any body will reply it will be highly Appriciatable.


Many Thanks,
Susanta Patnayak