Hi people,
in my company i have a web application running in Tomcat 6. That application connects to an oracle database. These configuration is defined in context.xml:
<Context path="/ngincard" reloadable="true" docBase="ngincard.war" antiJARLocking = "true" antiResourceLocking = "true"> <Resource name="jdbc/ngincard" auth="Container" type="oracle.jdbc.pool.OracleConnectionPoolDataSource" driverClassName="oracle.jdbc.OracleDriver" factory="oracle.jdbc.pool.OracleDataSourceFactory" url="jdbc:oracle:thin:clicardv2_06/xxxxxxx@xxx.xxx.xxx.xxx:1521:YYYY" maxActive="20" maxIdle="10" maxWait="-1" /> <Environment name="userDb" value="ADMINCARDV2_06" type="java.lang.String" override="false" /> <WatchedResource>WEB-INF/web.xml</WatchedResource> </Context>
To define a data source you will need a *-ds.xml file that you place in the server/xxx/deploy directory. You can find example *-ds.xml files for a variety of databases at docs/examples/jca.