commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dirk Verbeeck <>
Subject Re: Getting DBCP working through Tomcat 4.1
Date Thu, 20 Jan 2005 18:18:54 GMT
Hi Mike

You need a DriverAdapterCPDS and a PerUserPoolDataSource.
Try the following configuration:

<Resource name="jdbc/TestDBCPDS" auth="Container" 
<ResourceParams name="jdbc/TestDBCPDS">

<Resource auth="Container" name="jdbc/TestDB" 
<ResourceParams name="jdbc/TestDB">

-- Dirk wrote:
> Hello all, and apologies if I am asking a question which has been asked
> before (I presume it has but I can't find anything after comprehensive
> searching).
> I am trying to get a simple Tomcat application up using DBCP, and got
> BasicDataSource working fine. However, our applications all run under
> their own identities, and therefore need to be able to get connections
> based on username. I have tried using PerUserPoolDataSource and
> SharedPoolDataSource with no luck. The exception I am currently getting
> is as follows:
> "Must set the ConnectionPoolDataSource through setDataSourceName or
> setConnectionPoolDataSource before calling getConnection"
> My configuration is as follows:
> Tomcat 4.1.24, DBCP 1.2.1, Sybase jConnect 5.0 build 10229 (Sybase and
> DBCP jars in <tomcat_base>/common/lib)
> Following is an extract of my configuration files, and application code.
> I would greatly appreciate some help - this is beginning to drive me
> insane!
> Thanks in advance,
> Mike

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message