1 Reply Latest reply on Feb 22, 2007 3:20 PM by edavis

    JDBCStore and clustering

    edavis

      Hello,
      is it posible to have Tomcat clustering within jboss using apache as the load balancer and have the session data stored in a database using the JDBCStore Persistant Manager??

        • 1. Re: JDBCStore and clustering
          edavis

          I forgot to tell, im using Jboss 4.0.5GA using a context.xml inside the WEB-INF of my .war

          <Context cookies="true" crossContext="true">
           <Manager
           className="org.apache.catalina.session.PersistentManager"
           maxIdleSwap="20"
           saveOnRestart="true">
           <Store checkInterval="10"
           className="org.apache.catalina.session.JDBCStore"
           connectionURL="jdbc:mysql://localhost:3306/bligoo?user=bligoo&amp;password=bligoo"
           driverName="com.mysql.jdbc.Driver"
           sessionAppCol="app_name"
           sessionDataCol="session_data"
           sessionIdCol="session_id"
           sessionLastAccessedCol="last_access"
           sessionMaxInactiveCol="max_inactive"
           sessionTable="tomcat_sessions"
           sessionValidCol="valid_session"/>
           </Manager>
           <InstanceListener>org.jboss.web.tomcat.security.RunAsListener</InstanceListener>
          
          </Context>
          


          and works like a charm in a single server environment, will it work in a cluster environment?