Persistence in Tomact

[Ujwal Oswal]

Hi,

Has anyone out there implemented Persistence Session using JDBC Based Store
 in Tomcat. If yes can you please let us know of the procedure. I tried
modifing the Server.xml file but
I am getting SQLException.

Here are the exception 

2002-08-08 15:50:42 JDBCStore[/examples]: The database connection is null or
was found to be closed. Trying to re-open it.
2002-08-08 15:50:42 JDBCStore[/examples]: A SQL exception occurred
java.sql.SQLException: invalid arguments in call


Heres part of my Server.xml (ONLY PERSISTENCE ELEMENT)

          <Manager className="org.apache.catalina.session.PersistentManager"
              debug="0"
              saveOnRestart="true"
              maxActiveSessions="-1"
              minIdleSwap="-1"
              maxIdleSwap="0"
              maxIdleBackup="0">
                <Store className="org.apache.catalina.session.JDBCStore"
                       debug="2"
 
connectionURL="jdbc:oracle:thin:@hocleunx02:1521:reqpro?user=x25agent_dev;pa
ssword=x25agent_dev"
                       driverName="oracle.jdbc.driver.OracleDriver"
                       sessionDataCol="session_data"
                       sessionIdCol="session_id"
                       sessionLastAccessedCol="last_access"
                       sessionMaxInactiveCol="max_inactive"
                       sessionTable="tomcat_sessions"
                       sessionValidCol="valid_session"/>
          </Manager>

Thanks
Ujwal