Hi,
here is the configuration-
server.xml--
<Context crossContext="true" debug="5" docBase="ddmweb" path="/ddmweb" reloadable="true">
<Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_ddmweb_log." suffix=".txt" timestamp="true"/>
<Resource name="jdbc/myoracle" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/myoracle">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc
racle:thin:@192.168.192.28:1521:LBSLVLD</value>
</parameter>
<parameter>
<name>username</name>
<value>ddmdev</value>
</parameter>
<parameter>
<name>password</name>
<value>devddm</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams>
</Context>
web.xml--
<resource-ref>
<description>Oracle Datasource example</description>
<res-ref-name>jdbc/myoracle</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
and I've the following jars in my common\lib\
commons-pool-1.2.jar
commons-dbcp-1.2.1.jar
commons-collections-3.1.jar
classes12.jar
Thanks
Ajay