I'm working on an app that consists of three WAR files that all use the same data source. What is the best way to configure JNDI so all three WAR files can share the same data source? I'm currently using Eclipse Europa to manage my Tomcat 6.0 environment. I'm using DB2 UDB 8.2 Personal Edition.
I started with the following Resource definition in my shared context.xml file. \/\/\/\/\/\/\/\/
<Resource name="jdbc/EPDatabase"
auth="Container"
type="javax.sql.DataSource
"
username="devuser"
password="1234Hjkl"
driverClassName="COM.ibm.d
b2.jdbc.ap
p.DB2Drive
r"
url="jdbc:db2:CRMDEV"
maxActive="8"
maxIdle="4"/>
All examples on the web recommend Something closer to this in the Server.xml, but I'm getting a SAX parse error on Resource Params \/\/\/\/\/\/\/\/\/
<Resource auth="Container" description="User database that can be updated and saved" factory="org.apache.catali
na.users.M
emoryUserD
atabaseFac
tory" name="UserDatabase" pathname="conf/tomcat-user
s.xml" type="org.apache.catalina.
UserDataba
se"/>
<Resource name="jdbc/EPDatabase"
auth="Container"
type="javax.sql.DataSource
" />
<ResourceParams name="jdbc/EPDatabase" >
<parameter>
<name>factory</name>
<value>org.apache.commons.
dbcp.Basic
DataSource
Factory</v
alue>
</parameter>
<parameter>
<name>maxActive</name>
<value>10</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>3</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<parameter>
<name>username</name>
<value>devuser</value>
</parameter>
<parameter>
<name>password</name>
<value>1234Hjkl</value>
</parameter>
<parameter>
<name>driverClassName</nam
e>
<value>COM.ibm.db2.jdbc.ap
p.DB2Drive
r</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:db2:CRMDEV</va
lue>
</parameter>
</ResourceParams>
Start Free Trial