[infinispan-issues] [JBoss JIRA] (ISPN-3414) Infinispan ignores DatabaseType configuration

Vitalii Chepeliuk (JIRA) jira-events at lists.jboss.org
Thu Aug 15 05:37:26 EDT 2013


     [ https://issues.jboss.org/browse/ISPN-3414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vitalii Chepeliuk updated ISPN-3414:
------------------------------------

    Description: 
When I configure DefaultCacheManager with following configuration
{code:title=Configurator.java|borderStyle=solid}
        ConfigurationBuilder bld = new ConfigurationBuilder();
        bld.clustering().cacheMode(CacheMode.LOCAL)
            .loaders().passivation(passivation).preload(preload).shared(false)
            .addLoader(JdbcMixedCacheStoreConfigurationBuilder.class).fetchPersistentState(false).purgeOnStartup(false)
            .databaseType(DatabaseType.MYSQL)
             .stringTable()
                .dropOnExit(false)
                .createOnStart(true)
                .tableNamePrefix("ISPN6Alpha2_STRING")
                .idColumnName("ID").idColumnType("VARCHAR(255)")
                .dataColumnName("DATA").dataColumnType("VARBINARY(1000)")
                .timestampColumnName("TIMESTAMP").timestampColumnType("BIGINT")
             .binaryTable()
                .dropOnExit(false)
                .createOnStart(true)
                .tableNamePrefix("ISPN6Alpha2_BINARY")
                .idColumnName("ID").idColumnType("VARCHAR(255)")
                .dataColumnName("DATA").dataColumnType("VARBINARY(1000)")
                .timestampColumnName("TIMESTAMP").timestampColumnType("BIGINT")
             .dataSource()
                .jndiUrl("java:jboss/datasources/ExampleDS");
{code}
And here is TableManipulation class with getDatabaseType() method
{code:title=TableManipulation.java|borderStyle=solid}
  private DatabaseType getDatabaseType() {
      databaseType = config.databaseType();
      System.out.println(">>>>>>> databaseType "+ databaseType);
      if (databaseType == null) {
         // need to guess from the database type!
         Connection connection = null;
...
{code}
*Got the following output when test is running*
!!!!! is printed from my client code
>>>>> is printed from infinispan(TableManipulation.java)
-----
     [java] 10:59:07,347 INFO  [stdout] (pool-1-thread-1) !!!!!!! databasetype MYSQL
     [java] 10:59:07,500 INFO  [org.infinispan.factories.GlobalComponentRegistry] (pool-1-thread-1) ISPN000128: Infinispan version: Infinispan 'Infinium' 6.0.0.Alpha2-redhat-1
     [java] 10:59:09,851 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:11,953 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:12,644 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:12,645 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:13,393 INFO  [org.infinispan.jmx.CacheJmxRegistration] (pool-1-thread-1) ISPN000031: MBeans were successfully registered to the platform MBean server.
     [java] 10:59:24,780 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:24,954 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:25,260 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:29,679 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:29,680 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:29,843 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:29,844 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:30,002 INFO  [org.infinispan.jmx.CacheJmxRegistration] (pool-1-thread-1) ISPN000031: MBeans were successfully registered to the platform MBean server.
     [java] 10:59:38,626 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:38,776 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:41,806 INFO  [org.jboss.arquillian.testenricher.cdi.container.BeanManagerProducer] (pool-1-thread-1) BeanManager not found.
     [java] 10:59:41,813 INFO  [stdout] (pool-1-thread-1) !!!!!!! databasetype MYSQL
     [java] 10:59:41,848 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:41,848 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:42,018 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:42,020 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:42,176 INFO  [org.infinispan.jmx.CacheJmxRegistration] (pool-1-thread-1) ISPN000031: MBeans were successfully registered to the platform MBean server.
     [java] 10:59:52,364 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:52,515 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:52,667 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:57,155 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
-----
*And other issue with postgresqlplus92 DB, infinispan cannt recognize it like DatabaseType.POSTGRES*
-----
     [java] ^[[0m^[[0m10:53:45,198 INFO  [stdout] (pool-1-thread-1) !!!!!!! databasetype POSTGRES
     [java] ^[[0m^[[0m10:53:45,348 INFO  [org.infinispan.factories.GlobalComponentRegistry] (pool-1-thread-1) ISPN000128: Infinispan version: Infinispan 'Infinium' 6.0.0.Alpha2-redhat-1
     [java] ^[[0m^[[0m10:53:46,845 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:53:48,939 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:53:50,429 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:53:51,456 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:53:52,994 INFO  [org.infinispan.jmx.CacheJmxRegistration] (pool-1-thread-1) ISPN000031: MBeans were successfully registered to the platform MBean server.
     [java] ^[[0m^[[0m10:53:59,232 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:53:59,414 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:01,807 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:04,020 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:06,084 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:07,275 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:08,303 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:09,509 INFO  [org.infinispan.jmx.CacheJmxRegistration] (pool-1-thread-1) ISPN000031: MBeans were successfully registered to the platform MBean server.
     [java] ^[[0m^[[0m10:54:13,520 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:13,693 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:16,104 INFO  [org.jboss.arquillian.testenricher.cdi.container.BeanManagerProducer] (pool-1-thread-1) BeanManager not found.
     [java] ^[[0m^[[0m10:54:16,111 INFO  [stdout] (pool-1-thread-1) !!!!!!! databasetype POSTGRES
     [java] ^[[0m^[[0m10:54:16,148 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:18,180 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:19,352 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:20,358 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:21,531 INFO  [org.infinispan.jmx.CacheJmxRegistration] (pool-1-thread-1) ISPN000031: MBeans were successfully registered to the platform MBean server.
     [java] ^[[0m^[[0m10:54:26,078 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:26,256 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:27,419 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[31m10:54:57,421 ERROR [org.infinispan.loaders.jdbc.connectionfactory.ManagedConnectionFactory] (pool-1-thread-1) ISPN008018: Sql failure retrieving connection from datasource: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/ExampleDS
     [java]     at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:147)
     [java]     at org.infinispan.loaders.jdbc.connectionfactory.ManagedConnectionFactory.getConnection(ManagedConnectionFactory.java:82) [infinispan-cachestore-jdbc.jar:6.0.0.Alpha2-redhat-1]
     [java]     at org.infinispan.loaders.jdbc.TableManipulation.getDatabaseType(TableManipulation.java:396) [infinispan-cachestore-jdbc.jar:6.0.0.Alpha2-redhat-1]
     [java]     at org.infinispan.loaders.jdbc.TableManipulation.getSelectRowSql(TableManipulation.java:193) [infinispan-cachestore-jdbc.jar:6.0.0.Alpha2-redhat-1]
     [java]     at org.infinispan.loaders.jdbc.binary.JdbcBinaryCacheStore.loadBucket(JdbcBinaryCacheStore.java:247) [infinispan-cachestore-jdbc.jar:6.0.0.Alpha2-redhat-1]

-----

  was:
When I configure DefaultCacheManager with following configuration
{code:title=Configurator.java|borderStyle=solid}
        ConfigurationBuilder bld = new ConfigurationBuilder();
        bld.clustering().cacheMode(CacheMode.LOCAL)
            .loaders().passivation(passivation).preload(preload).shared(false)
            .addLoader(JdbcMixedCacheStoreConfigurationBuilder.class).fetchPersistentState(false).purgeOnStartup(false)
            .databaseType(DatabaseType.MYSQL)
             .stringTable()
                .dropOnExit(false)
                .createOnStart(true)
                .tableNamePrefix(STRING_TABLE_NAME_PREFIX)
                .idColumnName(ID_COLUMN_NAME).idColumnType(props.getProperty("id.column.type"))
                .dataColumnName(DATA_COLUMN_NAME).dataColumnType(props.getProperty("data.column.type"))
                .timestampColumnName(TIMESTAMP_COLUMN_NAME).timestampColumnType(props.getProperty("timestamp.column.type"))
             .binaryTable()
                .dropOnExit(false)
                .createOnStart(true)
                .tableNamePrefix(BUCKET_TABLE_NAME_PREFIX)
                .idColumnName(ID_COLUMN_NAME).idColumnType(props.getProperty("id.column.type"))
                .dataColumnName(DATA_COLUMN_NAME).dataColumnType(props.getProperty("data.column.type"))
                .timestampColumnName(TIMESTAMP_COLUMN_NAME).timestampColumnType(props.getProperty("timestamp.column.type"))
             .dataSource()
                .jndiUrl(props.getProperty("datasource.jndi.location"));
{code}
And here is TableManipulation class with getDatabaseType() method
{code:title=TableManipulation.java|borderStyle=solid}
  private DatabaseType getDatabaseType() {
      databaseType = config.databaseType();
      System.out.println(">>>>>>> databaseType "+ databaseType);
      if (databaseType == null) {
         // need to guess from the database type!
         Connection connection = null;
...
{code}
*Got the following output when test is running*
!!!!! is printed from my client code
>>>>> is printed from infinispan(TableManipulation.java)
-----
     [java] 10:59:07,347 INFO  [stdout] (pool-1-thread-1) !!!!!!! databasetype MYSQL
     [java] 10:59:07,500 INFO  [org.infinispan.factories.GlobalComponentRegistry] (pool-1-thread-1) ISPN000128: Infinispan version: Infinispan 'Infinium' 6.0.0.Alpha2-redhat-1
     [java] 10:59:09,851 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:11,953 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:12,644 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:12,645 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:13,393 INFO  [org.infinispan.jmx.CacheJmxRegistration] (pool-1-thread-1) ISPN000031: MBeans were successfully registered to the platform MBean server.
     [java] 10:59:24,780 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:24,954 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:25,260 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:29,679 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:29,680 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:29,843 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:29,844 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:30,002 INFO  [org.infinispan.jmx.CacheJmxRegistration] (pool-1-thread-1) ISPN000031: MBeans were successfully registered to the platform MBean server.
     [java] 10:59:38,626 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:38,776 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:41,806 INFO  [org.jboss.arquillian.testenricher.cdi.container.BeanManagerProducer] (pool-1-thread-1) BeanManager not found.
     [java] 10:59:41,813 INFO  [stdout] (pool-1-thread-1) !!!!!!! databasetype MYSQL
     [java] 10:59:41,848 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:41,848 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:42,018 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:42,020 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:42,176 INFO  [org.infinispan.jmx.CacheJmxRegistration] (pool-1-thread-1) ISPN000031: MBeans were successfully registered to the platform MBean server.
     [java] 10:59:52,364 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:52,515 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:52,667 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] 10:59:57,155 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
-----
*And other issue with postgresqlplus92 DB, infinispan cannt recognize it like DatabaseType.POSTGRES*
-----
     [java] ^[[0m^[[0m10:53:45,198 INFO  [stdout] (pool-1-thread-1) !!!!!!! databasetype POSTGRES
     [java] ^[[0m^[[0m10:53:45,348 INFO  [org.infinispan.factories.GlobalComponentRegistry] (pool-1-thread-1) ISPN000128: Infinispan version: Infinispan 'Infinium' 6.0.0.Alpha2-redhat-1
     [java] ^[[0m^[[0m10:53:46,845 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:53:48,939 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:53:50,429 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:53:51,456 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:53:52,994 INFO  [org.infinispan.jmx.CacheJmxRegistration] (pool-1-thread-1) ISPN000031: MBeans were successfully registered to the platform MBean server.
     [java] ^[[0m^[[0m10:53:59,232 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:53:59,414 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:01,807 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:04,020 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:06,084 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:07,275 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:08,303 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:09,509 INFO  [org.infinispan.jmx.CacheJmxRegistration] (pool-1-thread-1) ISPN000031: MBeans were successfully registered to the platform MBean server.
     [java] ^[[0m^[[0m10:54:13,520 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:13,693 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:16,104 INFO  [org.jboss.arquillian.testenricher.cdi.container.BeanManagerProducer] (pool-1-thread-1) BeanManager not found.
     [java] ^[[0m^[[0m10:54:16,111 INFO  [stdout] (pool-1-thread-1) !!!!!!! databasetype POSTGRES
     [java] ^[[0m^[[0m10:54:16,148 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:18,180 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:19,352 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:20,358 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:21,531 INFO  [org.infinispan.jmx.CacheJmxRegistration] (pool-1-thread-1) ISPN000031: MBeans were successfully registered to the platform MBean server.
     [java] ^[[0m^[[0m10:54:26,078 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:26,256 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[0m10:54:27,419 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
     [java] ^[[0m^[[31m10:54:57,421 ERROR [org.infinispan.loaders.jdbc.connectionfactory.ManagedConnectionFactory] (pool-1-thread-1) ISPN008018: Sql failure retrieving connection from datasource: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/ExampleDS
     [java]     at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:147)
     [java]     at org.infinispan.loaders.jdbc.connectionfactory.ManagedConnectionFactory.getConnection(ManagedConnectionFactory.java:82) [infinispan-cachestore-jdbc.jar:6.0.0.Alpha2-redhat-1]
     [java]     at org.infinispan.loaders.jdbc.TableManipulation.getDatabaseType(TableManipulation.java:396) [infinispan-cachestore-jdbc.jar:6.0.0.Alpha2-redhat-1]
     [java]     at org.infinispan.loaders.jdbc.TableManipulation.getSelectRowSql(TableManipulation.java:193) [infinispan-cachestore-jdbc.jar:6.0.0.Alpha2-redhat-1]
     [java]     at org.infinispan.loaders.jdbc.binary.JdbcBinaryCacheStore.loadBucket(JdbcBinaryCacheStore.java:247) [infinispan-cachestore-jdbc.jar:6.0.0.Alpha2-redhat-1]

-----


    
> Infinispan ignores DatabaseType configuration 
> ----------------------------------------------
>
>                 Key: ISPN-3414
>                 URL: https://issues.jboss.org/browse/ISPN-3414
>             Project: Infinispan
>          Issue Type: Bug
>          Components: Configuration
>    Affects Versions: 6.0.0.Alpha2
>            Reporter: Vitalii Chepeliuk
>            Assignee: Mircea Markus
>            Priority: Critical
>
> When I configure DefaultCacheManager with following configuration
> {code:title=Configurator.java|borderStyle=solid}
>         ConfigurationBuilder bld = new ConfigurationBuilder();
>         bld.clustering().cacheMode(CacheMode.LOCAL)
>             .loaders().passivation(passivation).preload(preload).shared(false)
>             .addLoader(JdbcMixedCacheStoreConfigurationBuilder.class).fetchPersistentState(false).purgeOnStartup(false)
>             .databaseType(DatabaseType.MYSQL)
>              .stringTable()
>                 .dropOnExit(false)
>                 .createOnStart(true)
>                 .tableNamePrefix("ISPN6Alpha2_STRING")
>                 .idColumnName("ID").idColumnType("VARCHAR(255)")
>                 .dataColumnName("DATA").dataColumnType("VARBINARY(1000)")
>                 .timestampColumnName("TIMESTAMP").timestampColumnType("BIGINT")
>              .binaryTable()
>                 .dropOnExit(false)
>                 .createOnStart(true)
>                 .tableNamePrefix("ISPN6Alpha2_BINARY")
>                 .idColumnName("ID").idColumnType("VARCHAR(255)")
>                 .dataColumnName("DATA").dataColumnType("VARBINARY(1000)")
>                 .timestampColumnName("TIMESTAMP").timestampColumnType("BIGINT")
>              .dataSource()
>                 .jndiUrl("java:jboss/datasources/ExampleDS");
> {code}
> And here is TableManipulation class with getDatabaseType() method
> {code:title=TableManipulation.java|borderStyle=solid}
>   private DatabaseType getDatabaseType() {
>       databaseType = config.databaseType();
>       System.out.println(">>>>>>> databaseType "+ databaseType);
>       if (databaseType == null) {
>          // need to guess from the database type!
>          Connection connection = null;
> ...
> {code}
> *Got the following output when test is running*
> !!!!! is printed from my client code
> >>>>> is printed from infinispan(TableManipulation.java)
> -----
>      [java] 10:59:07,347 INFO  [stdout] (pool-1-thread-1) !!!!!!! databasetype MYSQL
>      [java] 10:59:07,500 INFO  [org.infinispan.factories.GlobalComponentRegistry] (pool-1-thread-1) ISPN000128: Infinispan version: Infinispan 'Infinium' 6.0.0.Alpha2-redhat-1
>      [java] 10:59:09,851 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] 10:59:11,953 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] 10:59:12,644 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] 10:59:12,645 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] 10:59:13,393 INFO  [org.infinispan.jmx.CacheJmxRegistration] (pool-1-thread-1) ISPN000031: MBeans were successfully registered to the platform MBean server.
>      [java] 10:59:24,780 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] 10:59:24,954 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] 10:59:25,260 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] 10:59:29,679 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] 10:59:29,680 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] 10:59:29,843 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] 10:59:29,844 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] 10:59:30,002 INFO  [org.infinispan.jmx.CacheJmxRegistration] (pool-1-thread-1) ISPN000031: MBeans were successfully registered to the platform MBean server.
>      [java] 10:59:38,626 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] 10:59:38,776 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] 10:59:41,806 INFO  [org.jboss.arquillian.testenricher.cdi.container.BeanManagerProducer] (pool-1-thread-1) BeanManager not found.
>      [java] 10:59:41,813 INFO  [stdout] (pool-1-thread-1) !!!!!!! databasetype MYSQL
>      [java] 10:59:41,848 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] 10:59:41,848 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] 10:59:42,018 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] 10:59:42,020 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] 10:59:42,176 INFO  [org.infinispan.jmx.CacheJmxRegistration] (pool-1-thread-1) ISPN000031: MBeans were successfully registered to the platform MBean server.
>      [java] 10:59:52,364 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] 10:59:52,515 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] 10:59:52,667 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] 10:59:57,155 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
> -----
> *And other issue with postgresqlplus92 DB, infinispan cannt recognize it like DatabaseType.POSTGRES*
> -----
>      [java] ^[[0m^[[0m10:53:45,198 INFO  [stdout] (pool-1-thread-1) !!!!!!! databasetype POSTGRES
>      [java] ^[[0m^[[0m10:53:45,348 INFO  [org.infinispan.factories.GlobalComponentRegistry] (pool-1-thread-1) ISPN000128: Infinispan version: Infinispan 'Infinium' 6.0.0.Alpha2-redhat-1
>      [java] ^[[0m^[[0m10:53:46,845 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] ^[[0m^[[0m10:53:48,939 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] ^[[0m^[[0m10:53:50,429 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] ^[[0m^[[0m10:53:51,456 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] ^[[0m^[[0m10:53:52,994 INFO  [org.infinispan.jmx.CacheJmxRegistration] (pool-1-thread-1) ISPN000031: MBeans were successfully registered to the platform MBean server.
>      [java] ^[[0m^[[0m10:53:59,232 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] ^[[0m^[[0m10:53:59,414 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] ^[[0m^[[0m10:54:01,807 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] ^[[0m^[[0m10:54:04,020 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] ^[[0m^[[0m10:54:06,084 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] ^[[0m^[[0m10:54:07,275 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] ^[[0m^[[0m10:54:08,303 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] ^[[0m^[[0m10:54:09,509 INFO  [org.infinispan.jmx.CacheJmxRegistration] (pool-1-thread-1) ISPN000031: MBeans were successfully registered to the platform MBean server.
>      [java] ^[[0m^[[0m10:54:13,520 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] ^[[0m^[[0m10:54:13,693 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] ^[[0m^[[0m10:54:16,104 INFO  [org.jboss.arquillian.testenricher.cdi.container.BeanManagerProducer] (pool-1-thread-1) BeanManager not found.
>      [java] ^[[0m^[[0m10:54:16,111 INFO  [stdout] (pool-1-thread-1) !!!!!!! databasetype POSTGRES
>      [java] ^[[0m^[[0m10:54:16,148 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] ^[[0m^[[0m10:54:18,180 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] ^[[0m^[[0m10:54:19,352 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] ^[[0m^[[0m10:54:20,358 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] ^[[0m^[[0m10:54:21,531 INFO  [org.infinispan.jmx.CacheJmxRegistration] (pool-1-thread-1) ISPN000031: MBeans were successfully registered to the platform MBean server.
>      [java] ^[[0m^[[0m10:54:26,078 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] ^[[0m^[[0m10:54:26,256 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] ^[[0m^[[0m10:54:27,419 INFO  [stdout] (pool-1-thread-1) >>>>>>> databaseType null
>      [java] ^[[0m^[[31m10:54:57,421 ERROR [org.infinispan.loaders.jdbc.connectionfactory.ManagedConnectionFactory] (pool-1-thread-1) ISPN008018: Sql failure retrieving connection from datasource: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/ExampleDS
>      [java]     at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:147)
>      [java]     at org.infinispan.loaders.jdbc.connectionfactory.ManagedConnectionFactory.getConnection(ManagedConnectionFactory.java:82) [infinispan-cachestore-jdbc.jar:6.0.0.Alpha2-redhat-1]
>      [java]     at org.infinispan.loaders.jdbc.TableManipulation.getDatabaseType(TableManipulation.java:396) [infinispan-cachestore-jdbc.jar:6.0.0.Alpha2-redhat-1]
>      [java]     at org.infinispan.loaders.jdbc.TableManipulation.getSelectRowSql(TableManipulation.java:193) [infinispan-cachestore-jdbc.jar:6.0.0.Alpha2-redhat-1]
>      [java]     at org.infinispan.loaders.jdbc.binary.JdbcBinaryCacheStore.loadBucket(JdbcBinaryCacheStore.java:247) [infinispan-cachestore-jdbc.jar:6.0.0.Alpha2-redhat-1]
> -----

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


More information about the infinispan-issues mailing list