Return-Path: 
 <tomcat-user-return-118869-apmail-jakarta-tomcat-user-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-tomcat-user-archive@www.apache.org
Received: (qmail 30354 invoked from network); 5 Jan 2005 21:53:24 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur-2.apache.org with SMTP; 5 Jan 2005 21:53:24 -0000
Received: (qmail 38494 invoked by uid 500); 5 Jan 2005 21:52:59 -0000
Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org
Received: (qmail 38473 invoked by uid 500); 5 Jan 2005 21:52:58 -0000
Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:tomcat-user-subscribe@jakarta.apache.org>
List-Help: <mailto:tomcat-user-help@jakarta.apache.org>
List-Post: <mailto:tomcat-user@jakarta.apache.org>
List-Id: "Tomcat Users List" <tomcat-user.jakarta.apache.org>
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Delivered-To: mailing list tomcat-user@jakarta.apache.org
Received: (qmail 38454 invoked by uid 99); 5 Jan 2005 21:52:58 -0000
X-ASF-Spam-Status: No, hits=0.1 required=10.0
	tests=FORGED_RCVD_HELO,HTML_MESSAGE
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from dpsmailout.dpsk12.org (HELO dpsmailout.dpsk12.org)
 (164.92.10.41)
  by apache.org (qpsmtpd/0.28) with ESMTP; Wed, 05 Jan 2005 13:52:55 -0800
Received: from POSTOFFICE2.dpsk12.org ([164.92.10.67]) by
 dpsmailout.dpsk12.org with Microsoft SMTPSVC(6.0.3790.0);
	 Wed, 5 Jan 2005 14:53:27 -0700
X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C4F370.FCB7B6B3"
Subject: Connection Pooling with Tomcat 4.1 and SQL Server 2000
Date: Wed, 5 Jan 2005 14:53:27 -0700
Message-ID: <3A0B16ADCF75794B86AEDD16A0E810D9FEB8B8@POSTOFFICE2.dpsk12.org>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Connection Pooling with Tomcat 4.1 and SQL Server 2000
Thread-Index: AcTzcPzPrAh3/+kvQ4WboQuyrETTwg==
From: "Johnson, Jay" <Jay_Johnson@dpsk12.org>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
X-OriginalArrivalTime: 05 Jan 2005 21:53:27.0677 (UTC)
 FILETIME=[FCD2B2D0:01C4F370]
X-Virus-Checked: Checked
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

------_=_NextPart_001_01C4F370.FCB7B6B3
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I am trying to establish a connection pool in Tomcat 4.1 to SQL Server
2000.  Looking at the SQL Server trace utility, it appears Tomcat
connects with the correct username/password and then the following
exception is thrown:

=20

java.lang.UnsupportedOperationException at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSourc
e.java:161).
=20
I have taken the following steps:
=20
1)        Moved the driver jar files to /common/lib/
2)        Modified the Server.xml file
3)        Modified the web.xml file of the application
=20
Here is my Server.xml entry:
=20
<DefaultContext>
<Resource name=3D"jdbc/test" auth=3D"Container"
type=3D"javax.sql.DataSource"/>
<ResourceParams name=3D"jdbc/test">
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://localhost:1433</value>
</parameter>
<parameter>
<name>username</name>
<value>jay</value>
</parameter>
<parameter>
<name>password</name>
<value>jay</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>100</value>
</parameter>
</ResourceParams>
</DefaultContext>
=20
Here is my entry in the web.xml file:
=20
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/test</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>=20
</resource-ref>
=20
Are any additional entries needed?  Any help would be greatly
appreciated!

=20

Thanks,

Jay Johnson


------_=_NextPart_001_01C4F370.FCB7B6B3--