1 Reply Latest reply on Jul 5, 2015 9:53 PM by Lyle Wang

    Unable to load: org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker

    em ay Newbie

      I have following configuration in my standalone.xml file

       

       

                          <validation>
                              <valid-connection-checker class-name="org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker"/>
                              <validate-on-match>false</validate-on-match>
                              <background-validation>true</background-validation>
                              <background-validation-millis>60000</background-validation-millis>
                              <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLExceptionSorter"/>
                          </validation>
      

       

      And when I deploy my application, I run into following issue

       

       

      13:29:30,543 WARN  [org.jboss.as.connector.subsystems.datasources.AbstractDataSourceService$MyXaMCF] (ConnectionValidator) Exception trying to create valid connection checker (disabling):: java.lang.E
      xception: Unable to load: org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker
              at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.loadPlugin(BaseWrapperManagedConnectionFactory.java:1030)
              at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:1107)
              at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkValid(BaseWrapperManagedConnection.java:513)
              at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.getInvalidConnections(BaseWrapperManagedConnectionFactory.java:921)
              at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.validateConnections(SemaphoreArrayListManagedConnectionPool.java:948) [ironjacamar-core-impl-1.0.31.Fin
      al-redhat-1.jar:1.0.31.Final-redhat-1]
              at org.jboss.jca.core.connectionmanager.pool.validator.ConnectionValidator$ConnectionValidatorRunner.run(ConnectionValidator.java:277) [ironjacamar-core-impl-1.0.31.Final-redhat-1.jar:1.0.31.F
      inal-redhat-1]
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_45]
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_45]
              at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_45]
      
      
      
      
      13:29:30,549 WARN  [org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory] (ConnectionValidator) Exception trying to create valid connection checker (disabling):: java.lang.Exception: Unable
       to load: org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker
              at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.loadPlugin(BaseWrapperManagedConnectionFactory.java:1030)
              at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:1107)
              at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkValid(BaseWrapperManagedConnection.java:513)
              at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.getInvalidConnections(BaseWrapperManagedConnectionFactory.java:921)
              at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.validateConnections(SemaphoreArrayListManagedConnectionPool.java:948) [ironjacamar-core-impl-1.0.31.Fin
      al-redhat-1.jar:1.0.31.Final-redhat-1]
              at org.jboss.jca.core.connectionmanager.pool.validator.ConnectionValidator$ConnectionValidatorRunner.run(ConnectionValidator.java:277) [ironjacamar-core-impl-1.0.31.Final-redhat-1.jar:1.0.31.F
      inal-redhat-1]
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_45]
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_45]
              at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_45]
      14:35:53,748 INFO  [com.hazelcast.nio.Connection] (hz._hzInstance_1_myapp-app.IO.thread-2) [10.125.141.203]:6701 [myapp-app] Connection [Address[10.125.139.36]:6701] lost. Reason: java.io.IOException[An e
      



      Any Idea how to fix this issue ?

        • 1. Re: Unable to load: org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker
          Lyle Wang Novice

          6.6. Database Connection Validation

           

          • Specify a <valid-connection-checker> Class Name

          This is the preferred mechanism as it optimized for the particular RDBMS in use. JBoss EAP 6 provides the following connection checkers:

            • org.jboss.jca.adapters.jdbc.extensions.db2.DB2ValidConnectionChecker
            • org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLValidConnectionChecker
            • org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLReplicationValidConnectionChecker
            • org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker
            • org.jboss.jca.adapters.jdbc.extensions.novendor.JDBC4ValidConnectionChecker
            • org.jboss.jca.adapters.jdbc.extensions.novendor.NullValidConnectionChecker
            • org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker
            • org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLValidConnectionChecker
            • org.jboss.jca.adapters.jdbc.extensions.sybase.SybaseValidConnectionChecker