tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nicholas Sushkin <nsush...@openfinance.com>
Subject Re: Cleaning up after tomcat jdbc-pool?
Date Fri, 04 Mar 2011 15:59:35 GMT
On Thursday, March 03, 2011 19:24:11 Olivier Lefevre wrote:
> Can we see the relevant part of your context.xml, too?

Sure. It's something like:

<?xml version=3D"1.0" encoding=3D"UTF-8"?>
<Context antiJARLocking=3D"true" path=3D"@deploy.path@">
  <Resource auth=3D"Container"=20
            connectionProperties=3D"v$session.program=3DMyApp-@release@ @in=
stance.title@;"=20
            driverClassName=3D"oracle.jdbc.driver.OracleDriver"=20
            factory=3D"org.apache.tomcat.jdbc.pool.DataSourceFactory"=20
            initialSize=3D"1"=20
            maxActive=3D"10"=20
            name=3D"jdbc/Db1"=20
            password=3D"@db1.password@"=20
            type=3D"javax.sql.DataSource"=20
            url=3D"@db1.dburl@"=20
            username=3D"@db1.username@"/>
  <Resource auth=3D"Container" connectionProperties=3D"v$session.program=3D=
API-@release@ @instance.title@;" driverClassName=3D"oracle.jdbc.driver.Orac=
leDriver"=20
factory=3D"org.apache.tomcat.jdbc.pool.DataSourceFactory" initialSize=3D"1"=
 maxActive=3D"10" name=3D"jdbc/Db2" password=3D"@db2.password@" type=3D"jav=
ax.sql.DataSource"=20
url=3D"@db2.dburl@" username=3D"@db2.username@"/>
</Context>

At build time, I run the file through ant target that replaces @*@ tokens w=
ith actual values. I build using "ant -propertyfile myinstance.properties d=
ist"

   <target name=3D"-pre-dist">
       <replace dir=3D"${build.web.dir}/WEB-INF"
                replacefilterfile=3D"${instance.properties}"/>
       <replace dir=3D"${build.web.dir}/META-INF"
                replacefilterfile=3D"${instance.properties}"/>
   </target>
=2D-=20
Nicholas Sushkin, Senior Software Engineer, Manager of IT Operations
Open Finance Aggregation eXchange <http://www.aggex.com>

Mime
View raw message