Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: pass (athena.apache.org: domain of dmikusa@gopivotal.com
 designates 209.85.216.49 as permitted sender)
Content-Type: text/plain; charset=iso-8859-1
Mime-Version: 1.0 (Mac OS X Mail 6.6 \(1510\))
Subject: Re: Reg: Connection pool
From: Daniel Mikusa <dmikusa@gopivotal.com>
In-Reply-To: 
 <CAF0CH4tyLgFEm6bkbqDi9DE8b98n5G+3JXRd+7UUWWxHWF_hDg@mail.gmail.com>
Date: Mon, 7 Oct 2013 06:47:37 -0400
Content-Transfer-Encoding: quoted-printable
Message-Id: <9498EF28-AACE-4D3A-A238-9CB6B843AF07@gopivotal.com>
References: 
 <CAF0CH4tyLgFEm6bkbqDi9DE8b98n5G+3JXRd+7UUWWxHWF_hDg@mail.gmail.com>
To: "Tomcat Users List" <users@tomcat.apache.org>

On Oct 7, 2013, at 1:00 AM, Anu Prab <anuprab2@gmail.com> wrote:

> Hi,
>=20
>=20
> The Tomcat version I am using is 7.0.40 and the connection pool is
> tomcat-jdbc. I am having trouble configuring the connection pool. The
> configuration does not trouble as long as I do not include initialSize =
and
> factory attributes. But when I include any of these two, Tomcat starts
> throwing the below exception:
>=20
> org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC =
driver
> class 'oracle.jdbc.OracleDriver'
>        at
> =
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicD=
ataSource.java:1429)
>        at
> =
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSour=
ce.java:1371)
>        at
> =
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getLogWriter(BasicDataSource.j=
ava:1098)
>        at
> =
org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory.createDataSource(BasicD=
ataSourceFactory.java:350)
>        at
> =
org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory.getObjectInstance(Basic=
DataSourceFactory.java:156)
>        at
> =
org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactor=
y.java:143)
>        at
> =
javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:321)
>        at =
org.apache.naming.NamingContext.lookup(NamingContext.java:843)
>        at =
org.apache.naming.NamingContext.lookup(NamingContext.java:154)
>        at =
org.apache.naming.NamingContext.lookup(NamingContext.java:831)
>        at =
org.apache.naming.NamingContext.lookup(NamingContext.java:168)
>        at
> =
org.apache.catalina.core.NamingContextListener.addResource(NamingContextLi=
stener.java:1093)
>        at
> =
org.apache.catalina.core.NamingContextListener.createNamingContext(NamingC=
ontextListener.java:672)
>        at
> =
org.apache.catalina.core.NamingContextListener.lifecycleEvent(NamingContex=
tListener.java:271)
>        at
> =
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupp=
ort.java:119)
>        at
> =
org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.ja=
va:90)
>        at
> =
org.apache.catalina.core.StandardContext.startInternal(StandardContext.jav=
a:5269)
>        at
> org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
>        at
> =
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java=
:901)
>        at
> =
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
>        at
> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
>        at
> =
org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:111=
4)
>        at
> =
org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java=
:1672)
>        at
> =
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
>        at
> java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
>        at java.util.concurrent.FutureTask.run(FutureTask.java:166)
>        at
> =
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:=
1145)
>        at
> =
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java=
:615)
>        at java.lang.Thread.run(Thread.java:722)
> Caused by: java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
>        at
> =
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.j=
ava:1714)
>        at
> =
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.j=
ava:1559)
>        at
> =
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicD=
ataSource.java:1420)
>=20
>=20
> Why is this happening

It's happening because you're trying to use a JDBC driver that cannot be =
loaded.  Where do you have your Oracle driver?  It should be in =
CATALINA_BASE/lib or CATALINA_HOME/lib.

> ClassNotFoundException: oracle.jdbc.OracleDriver

> and why this happens specifically when I include these two attributes?

By default the pool is not going to make any connections to the database =
when it is created.  Because it doesn't make any connections, it doesn't =
need the driver.  If you set "initialSize" to something greater than 0, =
it will create connections at start up and thus it will need the driver =
class.

Dan

> Any help is appreciated. Thanks.
>=20
>=20
> -Anu


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