[infinispan-issues] [JBoss JIRA] (ISPN-5552) Cannot start persistence cache: CacheException

[Tristan Tarrant (JIRA)]

    [ https://issues.jboss.org/browse/ISPN-5552?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13079706#comment-13079706 ] 

Tristan Tarrant commented on ISPN-5552:
---------------------------------------

The version of Infinispan included in WildFly does not package the c3p0 module which is needed by our connection pool code, you should use the ManagedConnection which delegates the pooling to an application-server-provided data source.

> Cannot start persistence cache: CacheException
> ----------------------------------------------
>
>                 Key: ISPN-5552
>                 URL: https://issues.jboss.org/browse/ISPN-5552
>             Project: Infinispan
>          Issue Type: Bug
>    Affects Versions: 6.0.3.Final
>         Environment: WildFly 8.2.0 / Linux
>            Reporter: Veli Cris
>
> Hi,
> I have the following configuration for persistence cache (MySQL) and when I try to start the cache I get CacheException error. Basically what I want is to save the records from cache called 'mycache' in MySQL table called 'bean.bean_session'. Thank you.
> org.infinispan.commons.CacheException: Unable to invoke method public void org.infinispan.persistence.manager.PersistenceManagerImpl.start() on object of type PersistenceManagerImpl
> ConfigurationBuilder builder = new ConfigurationBuilder();
> Configuration config = builder.persistence()
> .addStore(JdbcBinaryStoreConfigurationBuilder.class)
> .fetchPersistentState(false)
> .ignoreModifications(false)
> .purgeOnStartup(false)
> .table()
> .dropOnExit(true)
> .createOnStart(true)
> .tableNamePrefix("bean_session")
> .idColumnName("id").idColumnType("INT(11)")
> .dataColumnName("string").dataColumnType("TEXT")
> .timestampColumnName("timestamp").timestampColumnType("TIMESTAMP")
> .connectionPool()
> .connectionUrl("jdbc:mysql://localhost:3306/bean")
> .username("root").password("1234567")
> .driverClass("com.mysql.jdbc.Driver").build();
> DefaultCacheManager manager = new DefaultCacheManager();
> manager.defineConfiguration("mycache", config);
> Cache cache = manager.getCache("mycache");
> cache.put("1", "1");
> cache.put("2", "2");
> cache.put("3", "3");
> cache.start();



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)