-
1. Re: JBoss AS7 JNDI Datasource Database pooling not really pooling.
jbertram Dec 21, 2012 11:50 AM (in response to techsjs2012)Paste your config?
-
2. Re: JBoss AS7 JNDI Datasource Database pooling not really pooling.
techsjs2012 Dec 21, 2012 11:53 AM (in response to jbertram)<datasource jta="false" jndi-name="java:jboss/datasources/mySQLDB" pool-name="MySQL" enabled="true" use-ccm="false">
<connection-url>jdbc:mysql://xxxx/jsmith1</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<driver>mysql-connector-java-5.1.21.jar</driver>
<pool>
<min-pool-size>2</min-pool-size>
<max-pool-size>10</max-pool-size>
<use-strict-min>false</use-strict-min>
</pool>
<security>
<user-name>jsmith</user-name>
<password>xxxx</password>
</security>
<validation>
<validate-on-match>false</validate-on-match>
<background-validation>false</background-validation>
</validation>
<statement>
<share-prepared-statements>false</share-prepared-statements>
</statement>
</datasource>
-
3. Re: JBoss AS7 JNDI Datasource Database pooling not really pooling.
jbertram Dec 21, 2012 3:34 PM (in response to techsjs2012)What happens if you set <prefill> to "true"? For example:
<datasource jta="false" jndi-name="java:jboss/datasources/mySQLDB" pool-name="MySQL" enabled="true" use-ccm="false"> <connection-url>jdbc:mysql://xxxx/jsmith1</connection-url> <driver-class>com.mysql.jdbc.Driver</driver-class> <driver>mysql-connector-java-5.1.21.jar</driver> <pool> <min-pool-size>2</min-pool-size> <max-pool-size>10</max-pool-size> <use-strict-min>false</use-strict-min> <prefill>true</prefill> </pool> <security> <user-name>jsmith</user-name> <password>xxxx</password> </security> <validation> <validate-on-match>false</validate-on-match> <background-validation>false</background-validation> </validation> <statement> <share-prepared-statements>false</share-prepared-statements> </statement> </datasource>