Return-Path: 
 <tomcat-user-return-78878-apmail-jakarta-tomcat-user-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-tomcat-user-archive@www.apache.org
Received: (qmail 13312 invoked from network); 24 Sep 2003 11:06:14 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 24 Sep 2003 11:06:14 -0000
Received: (qmail 80521 invoked by uid 500); 24 Sep 2003 11:05:48 -0000
Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org
Received: (qmail 80456 invoked by uid 500); 24 Sep 2003 11:05:48 -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 80363 invoked from network); 24 Sep 2003 11:05:47 -0000
Received: from unknown (HELO fs1.info-resonance.com) (199.171.27.66)
  by daedalus.apache.org with SMTP; 24 Sep 2003 11:05:47 -0000
Content-Class: urn:content-classes:message
Subject: RE: Configuring a JDBC Data Source
Date: Wed, 24 Sep 2003 07:05:48 -0400
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Message-ID: <F64B29488BD2C541AAB658EF3CF9550F1951A3@fs1.info-resonance.com>
X-MS-Has-Attach: 
X-MIMEOLE: Produced By Microsoft Exchange V6.0.6375.0
X-MS-TNEF-Correlator: 
Thread-Topic: Configuring a JDBC Data Source
thread-index: AcOCdLog7t0kigRtQT6p07UAavd+kgAFvTQw
From: "Renda, Michael" <michael.renda@info-resonance.com>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

I've got the commons-dbcp.jar file in the common/lib directory.  Where
do I find the commons-pool.jar file?

Mike

-----Original Message-----
From: Adam Hardy [mailto:ahardy.struts@cyberspaceroad.com]=20
Sent: Wednesday, September 24, 2003 4:20 AM
To: Tomcat Users List
Subject: Re: Configuring a JDBC Data Source

sounds like you need the commons-dbcp and commons-pool jar files as
well.

Adam

On 09/24/2003 01:52 AM Renda, Michael wrote:
> I'm trying to configure a JDBC Data Source for a Tomcat 4.1.27
> installation.  I used the Admin tool which wrote the following entry
to
> my server.xml file:
>=20
>   <GlobalNamingResources>
>     <Resource name=3D"jdbc/connection" scope=3D"Shareable"
> type=3D"javax.sql.DataSource"/>
>     <ResourceParams name=3D"jdbc/connection">
>       <parameter>
>         <name>maxWait</name>
>         <value>5000</value>
>       </parameter>
>       <parameter>
>         <name>maxActive</name>
>         <value>4</value>
>       </parameter>
>       <parameter>
>         <name>password</name>
>         <value>secret</value>
>       </parameter>
>       <parameter>
>         <name>url</name>
>         <value>jdbc:microsoft:sqlserver:192.168.0.2:1433</value>
>       </parameter>
>       <parameter>
>         <name>driverClassName</name>
>         <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
>       </parameter>
>       <parameter>
>         <name>maxIdle</name>
>         <value>2</value>
>       </parameter>
>       <parameter>
>         <name>username</name>
>         <value>sa</value>
>       </parameter>
>     </ResourceParams>
>   </GlobalNamingResources>
>=20
> I have placed the jar files for the sql/server jdbc driver in the
> common/lib directory.
>=20
> Now Tomcat won't start up.  I have the following message in my log:
>=20
> INFO: Initializing Coyote HTTP/1.1 on port 8080
> Exception during startup processing
> java.lang.reflect.InvocationTargetException
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at
>
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
> a:39)
> 	at
>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
> Impl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:324)
> 	at
> org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)
> Caused by: java.lang.NoClassDefFoundError:
> org/apache/commons/pool/impl/GenericObjectPool
> 	at
>
org.apache.commons.dbcp.BasicDataSourceFactory.getObjectInstance(BasicDa
> taSourceFactory.java:121)
> 	at
>
org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFact
> ory.java:186)
> 	at
>
javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:301)
> 	at
> org.apache.naming.NamingContext.lookup(NamingContext.java:834)
> 	at
> org.apache.naming.NamingContext.lookup(NamingContext.java:194)
> 	at
>
org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.createMBeans
> (GlobalResourcesLifecycleListener.java:214)
> 	at
>
org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.createMBeans
> (GlobalResourcesLifecycleListener.java:220)
> 	at
>
org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.createMBeans
> (GlobalResourcesLifecycleListener.java:181)
> 	at
>
org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.lifecycleEve
> nt(GlobalResourcesLifecycleListener.java:149)
> 	at
>
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSu
> pport.java:166)
> 	at
>
org.apache.catalina.core.StandardServer.start(StandardServer.java:2183)
> 	at org.apache.catalina.startup.Catalina.start(Catalina.java:512)
> 	at
> org.apache.catalina.startup.Catalina.execute(Catalina.java:400)
> 	at
> org.apache.catalina.startup.Catalina.process(Catalina.java:180)
> 	... 5 more
>=20
> Can anyone tell me what I'm doing wrong here?
>=20
> Thanks,
>=20
> Mike Renda
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>=20
>=20

--=20
struts 1.1 + tomcat 4.1.27 + java 1.4.2
Linux 2.4.20 RH9


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


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