tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Julio Serje (@canada.com)" <jse...@home.com>
Subject Re: Database connection pooling with tomcat
Date Wed, 22 Nov 2000 17:57:59 GMT
Hi, Kaushal,

I haven't used that specific conn pool, but looks like that you are having a
CLASSPATH problem.

- first, make sure that your drivers (and your poolmanager jars) are
available using the global classpath of Tomcat. You'll have to modify
startup.sh in order to include them in the classpath.

- Normally Oracle thin drivers are shipped as a zip file (classes111.zip),
and seems that Tomcat does not read zip files. I just renamed them to .jar
and everything worked fine.

Julio

----- Original Message -----
From: Kaushal Patel <KPatel@mail.doi.state.nc.us>
To: <tomcat-user@jakarta.apache.org>
Sent: Wednesday, November 22, 2000 10:46 AM
Subject: Database connection pooling with tomcat


>
>
> Question  What is the best way to do connection pooling to
>                  multiple oracle database with tomcat ?
>
> Hello All I have posted this message yesterday
> but haven't gotten any reply so trying it again to-day
> hope some one will be able to offer some help / thoughts
>
> I am trying to get he Pool Manger working
> I have a Redhat Linux 6.1 box with Apache &
> Tomcat 3.1 on it, my jsp pages work fine
> I am able to get connection to databases using
> Oracle  type 4 jdbc thin driver
>
> I have downloaded PoolMan v1.4 from codestudio.com
> and am trying to set-up connection pooling
> I have done all the classpath setting as per
> the install doc still I keep getting a message
> saying classNotfound exception
>            nullpointer exception
>
> What am I missing any help would be appreciated !!
>
> Question 1 Has anyone got this working ?
> Question 2 What is the best way to do connection pooling with tomcat ?
>
> Thanks in advance,
>
> Thanks,
> KPatel
>
> P.S.
> I tired running the test PoolMan.jsp util page they provide and
> got this below message
> ResultSet
>
> ERROR: Unable to process query.
> Please verify that PoolMan.jar and your JDBC Driver are in your
application
> server's CLASSPATH.
> If the problem continues, try testing your database and JDBC configuration
> via PoolManSample from the command line.
>
> ERROR: Unable to process query.
> Please verify that PoolMan.jar and your JDBC Driver are in your
application
> server's CLASSPATH.


Mime
View raw message