retrieve session data stored in db using JDBCStore.

[jerrySheen]

Hi,
I have been successful in saving the sessions to my mysql db, using the
given code in my server configuration file.

<Store className="org.apache.catalina.session.JDBCStore" 
          
connectionURL="jdbc:mysql://XXXXXXXXX/xxxxxx?user=zzzzz&amp;password=zzzzzz"
           driverName="com.mysql.jdbc.Driver"
           sessionIdCol="id"
           sessionValidCol="valid"
           sessionMaxInactiveCol="maxinactive"
           sessionLastAccessedCol="lastaccess"
           sessionTable = "app_sessions"
           sessionAppCol = "context"
           sessionDataCol = "data"
        />
this stores the session data as a blob in the db. So my questions are, 

Can we assign the blob data directly to a new session, so that this new
session assumes the state of the session in the db?
Can we retrieve and edit information from the blob?

if YES, please furnish some sample code or at least direct me towards the
solutions.
if NO, what other ways can we go about, to achieve session persistence(not
just validation as in cookies but a complete session state snapshot).
-- 
View this message in context: 
http://www.nabble.com/retrieve-session-data-stored-in-db-using-JDBCStore.-tp23020556p23020556.html
Sent from the Tomcat - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org