Session Persistence via JDBCStore

[Eddie Yee]

Hi,

 

I currently use deployment descriptor xml files to describe both the war file 
to deployed and the session persistence info (configs+db info).  Currently we 
use a connectionURL that specifies db complete db info 
(user/pass/db/port/sid)--  I would like to know if I can specify a datasource 
specified in the server.xml instead, and how to specify it (if you could 
provide an example, that'd be great).

 

Here's an example of my current deployment descriptor:

mywar.xml

 

        <Context
            path="/mywar"
            docBase="/nas1/tomcat/apps/mywar.war">
          <Manager className="org.apache.catalina.session.PersistentManager"
              maxIdleBackup="1"
              maxIdleSwap="1780"
              maxInactiveInterval="1800"
              minIdleSwap="1750"
              processExpiresFrequency="1">
            <Store className="org.apache.catalina.session.JDBCStore"
              
connectionURL="jdbc:oracle:thin:user/passw...@mydberver.mydomain.com:1521:DBSID"
              driverName="oracle.jdbc.driver.OracleDriver"
              sessionAppCol="app_context"
              sessionDataCol="session_data"
              sessionIdCol="session_id"
              sessionLastAccessedCol="last_access"
              sessionMaxInactiveCol="max_inactive"
              sessionTable="tomcat_sessions"
              sessionValidCol="valid_session"/>
          </Manager>
        </Context>


 

Thanks!!!

Eddie

_________________________________________________________________
Express your personality in color! Preview and select themes for Hotmail®.
http://www.windowslive-hotmail.com/LearnMore/personalize.aspx?ocid=TXT_MSGTX_WL_HM_express_032009#colortheme