i solved that ExampleDS problem. In EE subsystem, you can find default bindings, in that remove r change datasource to your datasource name, problem will be solved.
i deployed my application in wildfly-8.0.1.Final-SNAPSHOT. after 5 minutes CPU usage of my machine is going 100%. here also same "idleRemover" thread is the culprit.But the interesting thing is, in WINDOWS, i didn't face any problem. But when i try in Linux (CentOS 6.5) operating system, CPU usage is hitting 100%.
My datasource configuration is,
<subsystem xmlns="urn:jboss:domain:datasources:2.0">
<datasources>
<datasource jta="false" jndi-name="java:jboss/datasources/yba" pool-name="yba" enabled="true" use-java-context="true" use-ccm="false">
<connection-url>jdbc:mysql://localhost:3306/yba</connection-url>
<driver>m2mmysql</driver>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<pool>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<prefill>true</prefill>
<use-strict-min>true</use-strict-min>
<flush-strategy>IdleConnections</flush-strategy>
</pool>
<security>
<user-name>root</user-name>
<password>root</password>
</security>
<timeout>
<idle-timeout-minutes>5</idle-timeout-minutes>
</timeout>
</datasource>
<datasource jta="false" jndi-name="java:jboss/datasources/m2m" pool-name="m2m" enabled="true" use-java-context="true" use-ccm="false">
<connection-url>jdbc:mysql:localhost:3306/m2m</connection-url>
<driver>mymysql</driver>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<pool>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<prefill>true</prefill>
<use-strict-min>true</use-strict-min>
<flush-strategy>IdleConnections</flush-strategy>
</pool>
<security>
<user-name>root</user-name>
<password>root</password>
</security>
<timeout>
<idle-timeout-minutes>5</idle-timeout-minutes>
</timeout>
</datasource>
<drivers>
<driver name="h2" module="com.h2database.h2">
<xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
</driver>
<driver name="mymysql" module="my.mysql">
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
</driver>
</drivers>
</datasources>
</subsystem>
Then, i removed below tag in both datasource configurations.
<timeout>
<idle-timeout-minutes>5</idle-timeout-minutes>
</timeout>
this time CPU didn't go 100% usage, even if i acces my application left and right. Just to confirm, i again put this tag and changed idle-timeout-minutes to 2, then obviously after 2 mins CPU usage hit 100% and stayed there only.
so, Can you please tell me,
1)Why is that tag causing the problem?
2)why specifically in Linux operating system?
seems to be problem is in idle connections removal logic...
Attached org.jboss.jca log (which has taken when CPU usage @ 100%...
