java - Default JBoss 7 Connection Pool timeout -
does know default connection timeout in jboss 7 when using connection pooling?
my datasource defined this
<?xml version = '1.0' encoding = 'utf-8'?> <datasources> <xa-datasource jndi-name="java:/xxxxx" pool-name="xxxxx" enabled="true" use-java-context="false"> <xa-datasource-class>oracle.jdbc.xa.client.oraclexadatasource</xa-datasource-class> <xa-datasource-property name="url"> jdbc:oracle:thin:@xxxxxxxxx:1521:xxxxxxxx </xa-datasource-property> <driver>oracle.jdbc.oracledriver</driver> <new-connection-sql>select 1 dual</new-connection-sql> <transaction-isolation>transaction_read_committed</transaction-isolation> <xa-pool> <min-pool-size>1</min-pool-size> <max-pool-size>50</max-pool-size> <is-same-rm-override>false</is-same-rm-override> <interleaving>false</interleaving> <pad-xid>false</pad-xid> <wrap-xa-resource>false</wrap-xa-resource> </xa-pool> <security> <user-name> xxxxxxxx </user-name> <password>xxxxxxx</password> </security> <validation> <validate-on-match>true</validate-on-match> <background-validation>false</background-validation> </validation> <statement> <share-prepared-statements>false</share-prepared-statements> </statement> </xa-datasource> </datasources>
ps: query database , see connections jboss , cant figure out how creates new connection or when uses existing 1 pool. have couple of connections status inactive when jboss server not used application.
Comments
Post a Comment