Re: DBCP with JDBC driver in WEB-INF/lib

2004-07-12 Thread David Smith
I don't think you can.  The classloader that supports the jars in 
common/lib can't see the jars in your webapp.  It's one of those cases 
where your webapp's classloader can see the jars at the tomcat level, 
but not the other way around.  I think your stuck with either getting 
the provider to update their driver or rewriting your code to the older 
driver they are running.

--David
Steven J. Owens wrote:
Hi all,
I'm using tomcat with DBCP for connection pooling, on a hosted
server.
My hosting provider is using an older driver that doesn't support
some JDBC 3.0 features I'd like.
When I asked them about upgrading, they told me I could just stick
the jar file for the more up-to-date driver in WEB-INF/lib and use that.
What I'm wondering is, how do I tell DBCP to use the WEB-INF/lib
jar file? 

 

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


Re: DBCP with JDBC driver in WEB-INF/lib

2004-07-11 Thread QM
On Sun, Jul 11, 2004 at 01:49:24AM -0400, Steven J. Owens wrote:
:  My hosting provider is using an older driver that doesn't support
: some JDBC 3.0 features I'd like.
: 
:  When I asked them about upgrading, they told me I could just stick
: the jar file for the more up-to-date driver in WEB-INF/lib and use that.
: 
:  What I'm wondering is, how do I tell DBCP to use the WEB-INF/lib
: jar file? 

I don't think this is possible -- IIRC Tomcat looks for DB drivers in
common/lib because that's handled by the container's classloader, not
the per-context classloader.  (This makes sense: think of where pooling
is handled.)

Review the Tomcat docs for DBCP.  You may find some ammo to hand back to
your admins.  It may not get them to change their minds, but at least
they would stop telling people to do something that won't work ;)

-QM

-- 

software  -- http://www.brandxdev.net
tech news -- http://www.RoarNetworX.com


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



DBCP with JDBC driver in WEB-INF/lib

2004-07-10 Thread Steven J. Owens
Hi all,

 I'm using tomcat with DBCP for connection pooling, on a hosted
server.

 My hosting provider is using an older driver that doesn't support
some JDBC 3.0 features I'd like.

 When I asked them about upgrading, they told me I could just stick
the jar file for the more up-to-date driver in WEB-INF/lib and use that.

 What I'm wondering is, how do I tell DBCP to use the WEB-INF/lib
jar file? 

-- 
Steven J. Owens
[EMAIL PROTECTED]

I'm going to make broad, sweeping generalizations and strong,
 declarative statements, because otherwise I'll be here all night and
 this document will be four times longer and much less fun to read.
 Take it all with a grain of salt. - Me at http://darksleep.com


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]