<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Cannot configure valid-connection-checker, causes ClassNotFoundException
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/tkimura">Takayoshi Kimura</a> in <i>IronJacamar Development</i> - <a href="http://community.jboss.org/message/616895#616895">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>I'm trying to implement JBJCA-634 and hit an issue.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Support query timeout for check-valid-connection-sql</p><p><a class="jive-link-external-small" href="https://issues.jboss.org/browse/JBJCA-634" target="_blank">https://issues.jboss.org/browse/JBJCA-634</a></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>When I configured valid-connection-checker with NullValidConnectionChecker for testing purpose, I got this exception:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><pre class="jive-pre"><code class="jive-code">12:01:35,859 WARN  [org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory] (JBossConnectionValidator) Exception trying to create connection checker (disabling):: java.lang.ClassNotFoundException: org.jboss.jca.adapters.jdbc.extensions.novendor.NullValidConnectionChecker from [Module "org.jboss.ironjacamar.impl:main" from local module loader @12b7eea (roots: /home/nekop/usr/src/as7/build/target/jboss-as-7.1.0.Alpha1-SNAPSHOT/modules)]
    at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:191)
    at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:358)
    at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:307)
    at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:101)
    at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:1034)
    at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkValid(BaseWrapperManagedConnection.java:449)
    at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.getInvalidConnections(BaseWrapperManagedConnectionFactory.java:918)
    at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.validateConnections(SemaphoreArrayListManagedConnectionPool.java:800) [ironjacamar-core-impl-1.0.0.Final.jar:1.0.0.Final]
    at org.jboss.jca.core.connectionmanager.pool.validator.ConnectionValidator$JBossConnectionValidator.run(ConnectionValidator.java:269) [ironjacamar-core-impl-1.0.0.Final.jar:1.0.0.Final]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [:1.6.0_22]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [:1.6.0_22]
    at java.lang.Thread.run(Thread.java:679) [:1.6.0_22]
</code></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>And here is my datasource config:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><pre class="jive-pre"><code class="jive-code"><datasource jndi-name="java:jboss/datasources/ExampleDS" enabled="true" use-java-context="true" pool-name="H2DS" spy="true">
  <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url>
  <driver>h2</driver>
  <pool>
    <min-pool-size>2</min-pool-size>
    <max-pool-size>10</max-pool-size>
    <prefill>true</prefill>
  </pool>
  <security>
    <user-name>sa</user-name>
    <password>sa</password>
  </security>
  <validation>
    <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.novendor.NullValidConnectionChecker"/>
<!--
    <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.CheckValidConnectionSQL">
      <config-property name="sql">SELECT 1</config-property>
      <config-property name="queryTimeout">20</config-property>
    </valid-connection-checker>
-->
    <validate-on-match>true</validate-on-match>
    <background-validation>true</background-validation>
    <background-validation-minutes>1</background-validation-minutes>
  </validation>
  <timeout></timeout>
  <statement></statement>
</datasource></code></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I've tested this with both AS7 Final and AS7 upstream and got same result.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Is this a config issue or a known bug?</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/616895#616895">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in IronJacamar Development at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2099">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>