2 Replies Latest reply on Feb 12, 2013 10:11 PM by toddlthomas

    Infinispan 5.2.1 and MySQL Cache Store Issue

    toddlthomas

      I must be loading the mysql driver incorrectly as I'm getting the error below.  I have put the mysql-connector-java-5.1.22-bin.jar in the lib directory and I updated the .../modules/cachestores/jdbc/runtime-classpath.txt to include this jar but I'm getting "No suitable driver" error.  Any ideas?

       

      2013-02-09 02:24:39,250 WARN  (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0) [com.mchange.v2.resourcepool.BasicResourcePool] com.mchange.v2.r

      esourcepool.BasicResourcePool$AcquireTask@2af4ca49 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we

      failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:

      java.sql.SQLException: No suitable driver

              at java.sql.DriverManager.getDriver(DriverManager.java:279)

              at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:223)

              at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)

              at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)

              at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)

              at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)

              at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)

              at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)

              at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)

              at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

       

       

       

       

      Thanks for any help you can provide.