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

    JDBCStore and clustering

    Emilio Davis Newbie

      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
          Emilio Davis Newbie

          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?