Hi Eddie, I'm not sure if this would be possible with the default JDBCStore shipped with tomcat since the org.apache.catalina.session.JDBCStore is not considering usage of datasources which would certainly be a good plus, but maybe there is a reason why it is not in there.
if some one else have a clue i'm interested to know how this work. On Fri, Mar 27, 2009 at 4:23 PM, Eddie Yee <eddieyeew...@hotmail.com> wrote: > > 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 -- -- Yassine Elassad Bonn, Germany. Fon : +49 228 97629355 Mobile : +49 157 74519666 PEACE : ( P ) Positive ( E ) Energy ( A ) Always ( C ) Correct ( E ) Errors. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
