[Geotools-gt2-users] Proper configuration of geotools connection pool in tomcat

[Robin P. <rp...@iv...>]

Hi,

I use geotools in a web application to connect to an oracle database and need to configure the connection pool. The latest geotools docs describes some parameters in http://bit.ly/QmlPrE how to do this. I think this way is ok for standalone applications but web applications should use the container functions. So I use jndiReferenceName to declare the datasource which is configured in the context.xml like this:

<Resource
       name="oracleDatasource"
       auth="Container"
       type="javax.sql.DataSource"

       maxActive="100"
       maxIdle="20"
       maxWait="10000"

       driverClassName="oracle.jdbc.OracleDriver"
       factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
       username="*****"
       password="*****"
       url="*****"

       jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;
                    org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer;
                    org.apache.tomcat.jdbc.pool.interceptor.ResetAbandonedTimer;
                    org.apache.tomcat.jdbc.pool.interceptor.StatementDecoratorInterceptor"
       testWhileIdle="true"
       testOnBorrow="false"
       testOnReturn="false"
       validationQuery="SELECT 1 FROM dual"
       validationInterval="25000"
       timeBetweenEvictionRunsMillis="30000"/>

But how does the datastore recognize this external pool configuration? My understanding of the matter is that I finally have two pools which don't know each other and so there will rise performance problems. Is there any parameter to disable geotools connection pooling, so geotools just obtain an connection on demand and the tomcat connection pool administrates all the connections on its own?

[System]
Geotools = 8.0-RC2
Java = 1.6.0_29 x64
Tomcat = 7.0.26 x64
OS = Windows 7 x64


Thanks in advance!



Yours sincerely.

Robin Pradel
System Ingenieur
IVU Traffic Technologies AG
Bundesallee 88, D-12161 Berlin
Telefon: +49.30.8 59 06-448, Telefax: +49.30.8 59 06-499
mailto: rp...@iv...<mailto:rp...@iv...>, http://www.ivu.de<http://www.ivu.de/>

Vorstand: Martin Müller-Elschner (Vorsitzender)
Dr. Helmut Bergstein, Frank Kochanski
Aufsichtsrat: Klaus-Gerd Kleversaat (Vorsitzender)
Sitz der Gesellschaft: Berlin
Registergericht: Amtsgericht Berlin, HRB 69310