Return-Path: X-Original-To: apmail-tomcat-users-archive@www.apache.org Delivered-To: apmail-tomcat-users-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id D53E969D1 for ; Tue, 28 Jun 2011 06:56:29 +0000 (UTC) Received: (qmail 2692 invoked by uid 500); 28 Jun 2011 06:56:25 -0000 Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org Received: (qmail 2331 invoked by uid 500); 28 Jun 2011 06:56:18 -0000 Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "Tomcat Users List" Delivered-To: mailing list users@tomcat.apache.org Received: (qmail 2178 invoked by uid 99); 28 Jun 2011 06:56:15 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 28 Jun 2011 06:56:15 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [209.85.213.45] (HELO mail-yw0-f45.google.com) (209.85.213.45) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 28 Jun 2011 06:56:09 +0000 Received: by ywb3 with SMTP id 3so3189769ywb.18 for ; Mon, 27 Jun 2011 23:55:47 -0700 (PDT) Received: by 10.91.197.25 with SMTP id z25mr7662845agp.185.1309244147143; Mon, 27 Jun 2011 23:55:47 -0700 (PDT) From: =?ISO-8859-1?Q?Andr=E9_Brunnsberg?= MIME-Version: 1.0 X-Mailer: Microsoft Outlook 14.0 Thread-Index: Acw1X+GR/piCDrxrSkSCTbKtibR5Jg== Date: Tue, 28 Jun 2011 09:55:46 +0300 Message-ID: <151c5f779142247e8b2afc2367456429@mail.gmail.com> Subject: Best practise when using the datasource database realm To: users@tomcat.apache.org Content-Type: multipart/alternative; boundary=001636af02835092fd04a6c02840 --001636af02835092fd04a6c02840 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I have been testing the datasource database realm in combination with the new Tomcat database pool and it seems to work fine. However I would like to know if you guys use the same database pool for you= r application or a separate pool for the application and a separate pool for the realm. Currently in production I use the jdbcrealm with a different username and password that only has read access to the users and roles table. Therefore if I would like to continue with the current database setting I would need = a different pool for the datasource realm. Cheers, Andr=E9 --001636af02835092fd04a6c02840--