Hi
I am using this within tomcat-6.0.36.B.RELEASE contained in STS tcServer.
Here is my spring config as well.
<bean id="ppfeDataSource" class="org.apache.tomcat.jdbc.pool.DataSource"
destroy-method="close">
<property name="driverClassName"
value="${ppfe.database.driverClassName}"
/>
<property name="url" value="${ppfe.database.url}" />
<property name="username" value="${ppfe.database.username}" />
<property name="password" value="${ppfe.database.password}" />
<property name="initialSize"
value="${ppfe.database.initialPoolSize}" />
<property name="maxActive" value="${ppfe.database.maxPoolSize}"
/>
<property name="minIdle" value="${ppfe.database.minIdle}" />
<property name="maxIdle" value="${ppfe.database.maxIdle}" />
<property name="maxWait"
value="${ppfe.database.maxWait}"></property>
<property name="validationQuery"
value="${ppfe.database.preferredTestQuery}" />
<property name="testOnBorrow"
value="${ppfe.database.testConnectionOnCheckout}" />
<property name="testOnReturn"
value="${ppfe.database.testConnectionOnCheckin}" />
<property name="testWhileIdle"
value="${ppfe.database.testWhileIdle}" />
<property name="timeBetweenEvictionRunsMillis"
value="${ppfe.database.timeBetweenEvictionRunsMillis}"
/>
<property name="numTestsPerEvictionRun"
value="${ppfe.database.numTestsPerEvictionRun}" />
<property name="minEvictableIdleTimeMillis"
value="${ppfe.database.minEvictableIdleTimeMillis}" />
<property name="removeAbandoned"
value="${ppfe.database.removeAbandoned}"
/>
<property name="removeAbandonedTimeout"
value="${ppfe.database.removeAbandonedTimeout}" />
<property name="logAbandoned"
value="${ppfe.database.logAbandoned}" />
<property name="maxAge" value="${ppfe.database.maxAge}" />
<property name="logValidationErrors"
value="${ppfe.database.logValidationErrors}" />
<property name="connectionProperties"
value="maxStatements=6000;maxPoolSize=${ppfe.database.maxPoolSize};catalog=${ppfe.database.catalog};schema=${ppfe.database.schema};T4LogLevel=${ppfe.database.logLevel};T4LogFile=${ppfe.database.logFile}"
/>
<property name="jdbcInterceptors"
value="StatementFinalizer"></property>
</bean>
<tx:annotation-driven transaction-manager="txManager" />
<bean id="txManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="ppfeDataSource" />
</bean>
<bean id="ppfeSessionFactory"
class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
<property name="dataSource" ref="ppfeDataSource" />
<property name="mappingResources">
<list>
<value>za/co/vodacom/ppfe/data/airtime/airtimeXferLog.hbm.xml
</value>
-----
</property>
<property name="hibernateProperties">
<value>
hibernate.dialect=org.hibernate.dialect.SqlmxDialect
hibernate.show_sql=false
hibernate.format_sql=false
hibernate.jdbc.batch_size=0
</value>
</property>
</bean>
<bean id="ppfeTransactionManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory" ref="ppfeSessionFactory" />
</bean>
Regards
--
View this message in context:
http://tomcat.10.x6.nabble.com/Fwd-Tomcat-Jdbc-Pool-NumActive-vs-actual-Established-Connections-tp4997798p4997845.html
Sent from the Tomcat - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
