3 Replies Latest reply on Sep 15, 2006 3:03 AM by Mukesh Punhani

    Session Persistance

    Susanta Newbie

      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

        • 1. Re: Session Persistance
          Susanta Newbie

           

          <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>


          • 2. Re: Session Persistance
            Susanta Newbie

            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

            • 3. Re: Session Persistance
              Mukesh Punhani Newbie

              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