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
