Return-Path: 
 <dev-return-96252-apmail-tomcat-dev-archive=tomcat.apache.org@tomcat.apache.org>
Delivered-To: apmail-tomcat-dev-archive@www.apache.org
Received: (qmail 50558 invoked from network); 9 Jun 2009 11:07:34 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 9 Jun 2009 11:07:34 -0000
Received: (qmail 93763 invoked by uid 500); 9 Jun 2009 11:07:45 -0000
Delivered-To: apmail-tomcat-dev-archive@tomcat.apache.org
Received: (qmail 93678 invoked by uid 500); 9 Jun 2009 11:07:45 -0000
Mailing-List: contact dev-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@tomcat.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@tomcat.apache.org>
List-Post: <mailto:dev@tomcat.apache.org>
List-Id: <dev.tomcat.apache.org>
Reply-To: "Tomcat Developers List" <dev@tomcat.apache.org>
Delivered-To: mailing list dev@tomcat.apache.org
Received: (qmail 93667 invoked by uid 99); 9 Jun 2009 11:07:45 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 09 Jun 2009 11:07:45 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=10.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 09 Jun 2009 11:07:42 +0000
Received: by brutus.apache.org (Postfix, from userid 33)
	id 5BCED234C04C; Tue,  9 Jun 2009 04:07:21 -0700 (PDT)
From: bugzilla@apache.org
To: dev@tomcat.apache.org
Subject: DO NOT REPLY [Bug 47061] JDBCStore for saving sessions doesn't
 support datasource
X-Bugzilla-Reason: AssignedTo
X-Bugzilla-Type: newchanged
X-Bugzilla-Watch-Reason: None
X-Bugzilla-Product: Tomcat 6
X-Bugzilla-Component: Catalina
X-Bugzilla-Keywords: PatchAvailable
X-Bugzilla-Severity: enhancement
X-Bugzilla-Who: britsp@bristol.gov.uk
X-Bugzilla-Status: NEW
X-Bugzilla-Priority: P2
X-Bugzilla-Assigned-To: dev@tomcat.apache.org
X-Bugzilla-Target-Milestone: default
X-Bugzilla-Changed-Fields: 
In-Reply-To: <bug-47061-78@https.issues.apache.org/bugzilla/>
References: <bug-47061-78@https.issues.apache.org/bugzilla/>
Auto-Submitted: auto-generated
Content-Type: text/plain; charset="UTF-8"
MIME-Version: 1.0
Message-Id: <20090609110721.5BCED234C04C@brutus.apache.org>
Date: Tue,  9 Jun 2009 04:07:21 -0700 (PDT)
X-Virus-Checked: Checked by ClamAV on apache.org

https://issues.apache.org/bugzilla/show_bug.cgi?id=47061





--- Comment #6 from Steve Pugh <britsp@bristol.gov.uk>  2009-06-09 04:07:18 PST ---
Created an attachment (id=23778)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23778)
New version of JDBCStore supporting datasource only

I have also come up with an alternative for the JDBC session store.
Attached JDBCStoreDS.java is a new file which ONLY supports the datasource
method of getting the connection. Therefore this doesn't require any changes to
the existing "direct connection" version of the code.

The code can be used by adding the following into context.xml

<Manager className="org.apache.catalina.session.PersistentManager"
maxIdleBackup="0">
  <Store className="org.apache.catalina.session.JDBCStoreDS"
datasourceName="java:/comp/env/jdbc/DB-TOMCAT" sessionDataCol="session_data"
sessionIdCol="session_id" sessionLastAccessedCol="last_access"
sessionMaxInactiveCol="max_inactive" sessionTable="tomcat_sessions"
sessionValidCol="valid_session">
  </Store>
</Manager>

where DB-TOMCAT is a datasource defined elsewhere.

There is also an optional parameter "requireDistributable". Setting this to
true will mean sessions will only be persisted to the database if the webapp is
marked as "distributable" in the web.xml. The default is false which means the
the sessions will be persisted anyway.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@tomcat.apache.org
For additional commands, e-mail: dev-help@tomcat.apache.org