Andreas,
thanks for coming back to us with your findings, I am sure other users will
appreciate to know about a solution for this problem.
Thanks
Werner
On Thu, 16 Dec 2004 07:15:38 +0100, Andreas Vombach wrote:
>
>Hi Werner,
>
>first of all many thanks indeed for your helpfulness.
>Second: It works now.
>Third: I was close to bite my keyboard ... ok, now the facts:
>
>It has always been a good question where to put jar files in Tomcat
>(which I use since 3.2.1) because of the class loader issues.
>Calling class.forName() depends on the actual classloader and this
>method is used in the dbcp package. So where is this dbcp stuff in
>tomcat 5.5.4? Surprisingly in common/lib in a file called
>naming-factory-dbcp.jar, which is a merge of commons-pool and
>commons-dbcp with modified package paths. (!)
>So your jdbc drivers, whatever you use, must go here. (I use
>ojdbc14.jar) Otherwise you will get this Class not found exception.
>Now to the server.xml ... I'm not sure about the administration tool
>capabilities (which you have to install separately) but the "global"
>datasource you see in there is not recognized.
>Instead your conf/server.xml should look like
>
><?xml version='1.0' encoding='utf-8'?>
><Server>
> <Listener className="org.apache.catalina.mbeans.ServerLifecycleListener"/>
> <Listener
>className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"/>
> <GlobalNamingResources>
>..
> </GlobalNamingResources>
> <Service name="Catalina">
> <Connector port="80" redirectPort="8443" maxSpareThreads="75"
>maxThreads="150" minSpareThreads="25">
> </Connector>
> <Connector port="8009" protocol="AJP/1.3"
>protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler"
>redirectPort="8443">
> </Connector>
> <Engine defaultHost="localhost" name="Catalina">
> <Host appBase="webapps" name="localhost">
> <Context displayName="MyApp" docBase="MyApp" path="/MyApp"
>workDir="work\Catalina\localhost\MyApp">
> <Resource auth="Container" description=""
>name="jdbc/JNDI_MYDB" type="javax.sql.DataSource" password="mypass"
>driverClassName="oracle.jdbc.driver.OracleDriver" maxIdle="10"
>maxWait="-1" username="user" url="jdbc:oracle:thin:@myOracleDB"
>maxActive="20"/>
> </Context>
> </Host>
> <Realm className="org.apache.catalina.realm.UserDatabaseRealm"/>
> </Engine>
> </Service>
></Server>
>
>which means that you have to configure a pool for each web application
>separately. :[
>The rest works as described in the examples.
>
>
>
>-----------------------------------------------------------
>If you wish to unsubscribe from this mailing, send mail to
>[EMAIL PROTECTED] with a subject of:
> unsubscribe castor-user
>
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-user
