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 jeremyheiler@gmail.com
 designates 209.85.223.173 as permitted sender)
MIME-Version: 1.0
Date: Tue, 9 Oct 2012 10:37:07 -0400
Message-ID: 
 <CAKL9L2kE5RA7GaCMdNDHeXqs6GBbNdmkHt2oPk6Nank1AN=8+Q@mail.gmail.com>
Subject: Tomcat managed connections (DBCP) with driver in web application.
From: Jeremy Heiler <jeremyheiler@gmail.com>
To: users@tomcat.apache.org
Content-Type: multipart/alternative; boundary=20cf307d052ac696c304cba1450d

--20cf307d052ac696c304cba1450d
Content-Type: text/plain; charset=UTF-8

I am using Tomcat 7 and having it manage my database connections with its
DBCP implementation. In the past I have put ojdbc14.jar in
$CATALINA_HOME/lib, which has been fine. However, some applications are
being upgraded to Oracle 11g and require the ojdbc6.jar instead. If I take
the jar out of $CATALINA_HOME/lib and put the correct one in each
individual application, everything works fine, except for the "cannot
unregister driver" error Tomcat logs.

Every resource I've read thus far has said that the driver jar must be
in $CATALINA_HOME/lib or DBCP wont work. Except that it appears to work
just fine. Perhaps I am missing something? Are there other consequences for
putting the driver in each individual webapp (when having Tomcat manage
connections) and not in $CATALINA_HOME/lib?

Thanks,
//Jeremy

--20cf307d052ac696c304cba1450d--