Return-Path: 
 <derby-user-return-758-apmail-db-derby-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-user-archive@www.apache.org
Received: (qmail 87159 invoked from network); 21 Feb 2005 15:31:38 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur-2.apache.org with SMTP; 21 Feb 2005 15:31:38 -0000
Received: (qmail 19162 invoked by uid 500); 21 Feb 2005 15:31:37 -0000
Delivered-To: apmail-db-derby-user-archive@db.apache.org
Received: (qmail 19137 invoked by uid 500); 21 Feb 2005 15:31:36 -0000
Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:derby-user-help@db.apache.org>
list-unsubscribe: <mailto:derby-user-unsubscribe@db.apache.org>
List-Post: <mailto:derby-user@db.apache.org>
List-Id: <derby-user.db.apache.org>
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Delivered-To: mailing list derby-user@db.apache.org
Received: (qmail 19124 invoked by uid 99); 21 Feb 2005 15:31:36 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from stingray.uchicago.edu (HELO stingray.uchicago.edu)
 (128.135.17.223)
  by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 21 Feb 2005 07:31:35 -0800
Received: from skate (skate.uchicago.edu [128.135.17.227])
	by stingray.uchicago.edu (8.12.7/8.12.7/SuSE Linux 0.6) with SMTP id
 j1LFVS5G027921
	for <derby-user@db.apache.org>; Mon, 21 Feb 2005 09:31:32 -0600
Message-ID: <001101c5182a$68bee080$e3118780@skate>
From: "Jonathan Eric Miller" <jemiller@uchicago.edu>
To: "Derby Discussion" <derby-user@db.apache.org>
References: <BAY24-F385DDE33D7CF55687A8766D3610@phx.gbl>
Subject: Re: Tomcat / derby connection pool
Date: Mon, 21 Feb 2005 09:31:23 -0600
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2527
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
X-Virus-Checked: Checked
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

I'm using something similar to the following. I have it in context.xml in 
the META-INF directory of my webapp. I'm using Derby as a separate server 
though and using the IBM UDB JDBC driver. Note, this syntax is for Tomcat 
5.5. It's different for earlier versions.

<Context>
<Resource name="jdbc/mydatabase"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.ibm.db2.jcc.DB2Driver"
url="jdbc:derby:net://localhost:1527/mydatabase;create=true:retrieveMessagesFromServerOnGetMessage=true;"
username="myuser"
password="mypassword"
maxActive="5"
maxIdle="5"
maxWait="60000"
validationQuery="VALUES(1)"
removeAbandoned="true"
removeAbandonedTimeout="60"
logAbandoned="true"/>
</Context>

Jon

----- Original Message ----- 
From: "Ravi BRavi" <ravioakton@hotmail.com>
To: <derby-user@db.apache.org>
Sent: Sunday, February 20, 2005 8:07 PM
Subject: Tomcat / derby connection pool


> Hi:
>
> I am new to both tomcat and derby - I am very familiar with weblogic and 
> oracle.
> I would like to create a database connection pool for a web application 
> (embedded model - tomcat and derby in the same jvm - I am following the 
> fortune tutorial example).
> Is there an example of the steps / syntax (server.xml) for "jdbc 
> connection pool" for tomcat / derby?
>
> Thanks
> -Ravi
>
>