4 Replies Latest reply on Aug 23, 2010 8:08 AM by Anitha Kothandapani

    JdbcStringBasedCacheStore entering "-1" in TIMESTAMP_COLUMN

    Anitha Kothandapani Newbie

      Hi All

       

      I am new to Infinispan. I am using infinispan-4.0.0.FINAL , JdbcStringBasedCacheStore for storing the cache data.

       

      Given below is the table data( ISPN_STRING_TABLE_MYCACHE - table name)  which is  created by INFINISPAN.Please help me to understand  why the value for timestamp_column is entered as -1 in the db (Oracle 10g is the db which I use).

       

      I used NUMBER(19) for the timestamp column, since BIGINT datatype throws invalid datatype exception. I  tried VARCHAR which also inserts -1 in the timestamp_column.  I also tried DATE for the timestamp_column but it throws the below exception.

       

       

       ORA-00932: inconsistent datatypes: expected DATE got NUMBER
      
       at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
       at 
      

       

       

      ID_COLUMN

      DATA_COLUMN

      TIMESTAMP_COLUMN

      key1

      HUGEBLOB

      -1

      key4

      HUGEBLOB

      -1

      key5

      HUGEBLOB

      -1

      key3

      HUGEBLOB

      -1

      key2

      HUGEBLOB

      -1

       

       

       

      My Infinispan cache configuration file.

      <namedCache name="MyCache">
        <locking isolationLevel="READ_COMMITTED" lockAcquisitionTimeout="150000"/>
            <transaction transactionManagerLookupClass="org.infinispan.transaction.lookup.DummyTransactionManagerLookup"/>
      <clustering mode="replication">
               <stateRetrieval timeout="20000" fetchInMemoryState="true"/>         
               <sync replTimeout="20000"/>        
            </clustering>
            
      <loaders>  
                  <loader fetchPersistentState="false" ignoreModifications="false" purgeOnStartup="false">
            <properties>
               <property name="stringsTableNamePrefix" value="ISPN_STRING_TABLE"/>
               <property name="idColumnName" value="ID_COLUMN"/>
               <property name="dataColumnName" value="DATA_COLUMN"/>
               <property name="timestampColumnName" value="TIMESTAMP_COLUMN"/>
               <property name="timestampColumnType" value="NUMBER(19)"/>
               <property name="connectionFactoryClass" value="org.infinispan.loaders.jdbc.connectionfactory.PooledConnectionFactory"/>
               <property name="connectionUrl" value="jdbc:oracle:thin:@myIP:1521:TPFDB"/>
               <property name="userName" value="myuser"/>
      <property name="password" value="mypassword"/>
               <property name="driverClass" value="oracle.jdbc.OracleDriver"/>
               <property name="idColumnType" value="VARCHAR2(500)"/>
               <property name="dataColumnType" value="BLOB"/>
               <property name="dropTableOnExit" value="true"/>
               <property name="createTableOnStart" value="true"/>
            </properties>
         </loader>
            </loaders> 
       </namedCache>
      
      
      

       

      Code which I use for inserting the cache data.

      public class TestCluster {
      
           public static void main(String[] args) throws Exception
           {
                CacheManager manager = new DefaultCacheManager("C:/workspace/CacheTest/clusterTest2.xml");
                
                Cache cache = manager.getCache("MyCache");
                
                    cache.put("key1", "value1");
                
                System.out.println("Cluster details : "+ manager.getClusterName());          
      
                manager.stop();
           }
           
                  
      }
      

       

      Please help me which is the correct datatype for the timestamp column if Oracle is used as the persistent store.

       

      regards

      Anitha K

        • 1. Re: JdbcStringBasedCacheStore entering "-1" in TIMESTAMP_COLUMN
          Mircea Markus Master

          We read/write the timestamp column as a Java long. A java long is mapped in Oracle as an BIGINT[1] so I think BIGINT is the way to go. Can you please create a UT that would fail with BIGINT?

          • 2. Re: JdbcStringBasedCacheStore entering "-1" in TIMESTAMP_COLUMN
            Anitha Kothandapani Newbie

            Hi Mircea

             

            Thanks for your reply. I tried

             
            <property name="timestampColumnType" value="BIGINT(1)"/>
            

             

            in the configuration as you mentioned. But I got the below exception.

            ug 20, 2010 8:21:13 PM org.infinispan.remoting.transport.jgroups.JGroupsTransport start
            INFO: Starting JGroups Channel
            Aug 20, 2010 8:21:13 PM org.infinispan.util.logging.AbstractLogImpl info
            INFO: Unable to use any JGroups configuration mechanisms provided in properties {}.  Using default JGroups configuration!
            Aug 20, 2010 8:21:13 PM org.jgroups.logging.JDKLogImpl info
            INFO: JGroups version: 2.9.0.GA
            Aug 20, 2010 8:21:13 PM org.infinispan.util.logging.AbstractLogImpl info
            INFO: Received new cluster view: [SGFNode-1403|16] [SGFNode-1403, SGFNode-7921, SGFNode-17760]
            Aug 20, 2010 8:21:13 PM org.infinispan.util.logging.AbstractLogImpl info
            INFO: Cache local address is SGFNode-17760, physical addresses are [16.181.193.139:4045]
            Aug 20, 2010 8:21:13 PM org.infinispan.factories.AbstractComponentRegistry internalStart
            INFO: Infinispan version: Infinispan 'Starobrno' 4.0.0.FINAL
            Aug 20, 2010 8:21:13 PM com.mchange.v2.log.MLog <clinit>
            INFO: MLog clients using java 1.4+ standard logging.
            Aug 20, 2010 8:21:13 PM com.mchange.v2.c3p0.C3P0Registry banner
            INFO: Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
            Aug 20, 2010 8:21:13 PM com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource getPoolManager
            INFO: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 4mwt578a13y7425aas2cr|e3fda4, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> oracle.jdbc.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 4mwt578a13y7425aas2cr|e3fda4, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:oracle:thin:@16.138.175.147:1521:TPFDB, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
            Aug 20, 2010 8:21:14 PM org.infinispan.loaders.jdbc.TableManipulation executeUpdateSql
            SEVERE: Error while creating table
            java.sql.SQLException: ORA-00907: missing right parenthesis
            
                at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
                at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
                at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
                at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
                at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
                at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1614)
                at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1579)
                at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
                at org.infinispan.loaders.jdbc.TableManipulation.executeUpdateSql(TableManipulation.java:174)
                at org.infinispan.loaders.jdbc.TableManipulation.createTable(TableManipulation.java:152)
                at org.infinispan.loaders.jdbc.TableManipulation.start(TableManipulation.java:250)
                at org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore.doConnectionFactoryInitialization(JdbcStringBasedCacheStore.java:299)
                at org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore.start(JdbcStringBasedCacheStore.java:98)
                at org.infinispan.loaders.CacheLoaderManagerImpl.start(CacheLoaderManagerImpl.java:99)
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:597)
                at org.infinispan.util.ReflectionUtil.invokeAccessibly(ReflectionUtil.java:170)
                at org.infinispan.factories.AbstractComponentRegistry$PrioritizedMethod.invoke(AbstractComponentRegistry.java:852)
                at org.infinispan.factories.AbstractComponentRegistry.internalStart(AbstractComponentRegistry.java:672)
                at org.infinispan.factories.AbstractComponentRegistry.start(AbstractComponentRegistry.java:574)
                at org.infinispan.factories.ComponentRegistry.start(ComponentRegistry.java:148)
                at org.infinispan.CacheDelegate.start(CacheDelegate.java:311)
                at org.infinispan.manager.DefaultCacheManager.createCache(DefaultCacheManager.java:507)
                at org.infinispan.manager.DefaultCacheManager.getCache(DefaultCacheManager.java:473)
                at TestCluster.main(TestCluster.java:12)
            Exception in thread "main" org.infinispan.CacheException: Unable to invoke method public void org.infinispan.loaders.CacheLoaderManagerImpl.start() on object 
                at org.infinispan.util.ReflectionUtil.invokeAccessibly(ReflectionUtil.java:173)
                at org.infinispan.factories.AbstractComponentRegistry$PrioritizedMethod.invoke(AbstractComponentRegistry.java:852)
                at org.infinispan.factories.AbstractComponentRegistry.internalStart(AbstractComponentRegistry.java:672)
                at org.infinispan.factories.AbstractComponentRegistry.start(AbstractComponentRegistry.java:574)
                at org.infinispan.factories.ComponentRegistry.start(ComponentRegistry.java:148)
                at org.infinispan.CacheDelegate.start(CacheDelegate.java:311)
                at org.infinispan.manager.DefaultCacheManager.createCache(DefaultCacheManager.java:507)
                at org.infinispan.manager.DefaultCacheManager.getCache(DefaultCacheManager.java:473)
                at TestCluster.main(TestCluster.java:12)
            Caused by: java.lang.reflect.InvocationTargetException
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:597)
                at org.infinispan.util.ReflectionUtil.invokeAccessibly(ReflectionUtil.java:170)
                ... 8 more
            Caused by: org.infinispan.CacheException: Unable to start cache loaders
                at org.infinispan.loaders.CacheLoaderManagerImpl.start(CacheLoaderManagerImpl.java:102)
                ... 13 more
            Caused by: org.infinispan.loaders.CacheLoaderException: java.sql.SQLException: ORA-00907: missing right parenthesis
            
                at org.infinispan.loaders.jdbc.TableManipulation.executeUpdateSql(TableManipulation.java:177)
                at org.infinispan.loaders.jdbc.TableManipulation.createTable(TableManipulation.java:152)
                at org.infinispan.loaders.jdbc.TableManipulation.start(TableManipulation.java:250)
                at org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore.doConnectionFactoryInitialization(JdbcStringBasedCacheStore.java:299)
                at org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore.start(JdbcStringBasedCacheStore.java:98)
                at org.infinispan.loaders.CacheLoaderManagerImpl.start(CacheLoaderManagerImpl.java:99)
                ... 13 more
            Caused by: java.sql.SQLException: ORA-00907: missing right parenthesis
            
                at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
                at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
                at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
                at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
                at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
                at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1614)
                at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1579)
                at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
                at org.infinispan.loaders.jdbc.TableManipulation.executeUpdateSql(TableManipulation.java:174)
                ... 18 more
            

             

             

            And when I simply gave BIGINT without specfying any size as below ,

             

            <property name="timestampColumnType" value="BIGINT"/>
            
            
            

            it gave me the following exception

            Aug 20, 2010 8:24:19 PM org.infinispan.remoting.transport.jgroups.JGroupsTransport start
            INFO: Starting JGroups Channel
            Aug 20, 2010 8:24:19 PM org.infinispan.util.logging.AbstractLogImpl info
            INFO: Unable to use any JGroups configuration mechanisms provided in properties {}.  Using default JGroups configuration!
            Aug 20, 2010 8:24:19 PM org.jgroups.logging.JDKLogImpl info
            INFO: JGroups version: 2.9.0.GA
            Aug 20, 2010 8:24:19 PM org.infinispan.util.logging.AbstractLogImpl info
            INFO: Received new cluster view: [SGFNode-1403|18] [SGFNode-1403, SGFNode-7921, SGFNode-44118]
            Aug 20, 2010 8:24:19 PM org.infinispan.util.logging.AbstractLogImpl info
            INFO: Cache local address is SGFNode-44118, physical addresses are [16.181.193.139:4078]
            Aug 20, 2010 8:24:19 PM org.infinispan.factories.AbstractComponentRegistry internalStart
            INFO: Infinispan version: Infinispan 'Starobrno' 4.0.0.FINAL
            Aug 20, 2010 8:24:19 PM com.mchange.v2.log.MLog <clinit>
            INFO: MLog clients using java 1.4+ standard logging.
            Aug 20, 2010 8:24:19 PM com.mchange.v2.c3p0.C3P0Registry banner
            INFO: Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
            Aug 20, 2010 8:24:19 PM com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource getPoolManager
            INFO: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 4mwt578a13yb3hadnrrd9|182a70, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> oracle.jdbc.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 4mwt578a13yb3hadnrrd9|182a70, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:oracle:thin:@16.138.175.147:1521:TPFDB, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
            Aug 20, 2010 8:24:20 PM org.infinispan.loaders.jdbc.TableManipulation executeUpdateSql
            SEVERE: Error while creating table
            java.sql.SQLException: ORA-00902: invalid datatype
            
                at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
                at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
                at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
                at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
                at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
                at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1614)
                at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1579)
                at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
                at org.infinispan.loaders.jdbc.TableManipulation.executeUpdateSql(TableManipulation.java:174)
                at org.infinispan.loaders.jdbc.TableManipulation.createTable(TableManipulation.java:152)
                at org.infinispan.loaders.jdbc.TableManipulation.start(TableManipulation.java:250)
                at org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore.doConnectionFactoryInitialization(JdbcStringBasedCacheStore.java:299)
                at org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore.start(JdbcStringBasedCacheStore.java:98)
                at org.infinispan.loaders.CacheLoaderManagerImpl.start(CacheLoaderManagerImpl.java:99)
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:597)
                at org.infinispan.util.ReflectionUtil.invokeAccessibly(ReflectionUtil.java:170)
                at org.infinispan.factories.AbstractComponentRegistry$PrioritizedMethod.invoke(AbstractComponentRegistry.java:852)
                at org.infinispan.factories.AbstractComponentRegistry.internalStart(AbstractComponentRegistry.java:672)
                at org.infinispan.factories.AbstractComponentRegistry.start(AbstractComponentRegistry.java:574)
                at org.infinispan.factories.ComponentRegistry.start(ComponentRegistry.java:148)
                at org.infinispan.CacheDelegate.start(CacheDelegate.java:311)
                at org.infinispan.manager.DefaultCacheManager.createCache(DefaultCacheManager.java:507)
                at org.infinispan.manager.DefaultCacheManager.getCache(DefaultCacheManager.java:473)
                at TestCluster.main(TestCluster.java:12)
            Exception in thread "main" org.infinispan.CacheException: Unable to invoke method public void org.infinispan.loaders.CacheLoaderManagerImpl.start() on object 
                at org.infinispan.util.ReflectionUtil.invokeAccessibly(ReflectionUtil.java:173)
                at org.infinispan.factories.AbstractComponentRegistry$PrioritizedMethod.invoke(AbstractComponentRegistry.java:852)
                at org.infinispan.factories.AbstractComponentRegistry.internalStart(AbstractComponentRegistry.java:672)
                at org.infinispan.factories.AbstractComponentRegistry.start(AbstractComponentRegistry.java:574)
                at org.infinispan.factories.ComponentRegistry.start(ComponentRegistry.java:148)
                at org.infinispan.CacheDelegate.start(CacheDelegate.java:311)
                at org.infinispan.manager.DefaultCacheManager.createCache(DefaultCacheManager.java:507)
                at org.infinispan.manager.DefaultCacheManager.getCache(DefaultCacheManager.java:473)
                at TestCluster.main(TestCluster.java:12)
            Caused by: java.lang.reflect.InvocationTargetException
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:597)
                at org.infinispan.util.ReflectionUtil.invokeAccessibly(ReflectionUtil.java:170)
                ... 8 more
            Caused by: org.infinispan.CacheException: Unable to start cache loaders
                at org.infinispan.loaders.CacheLoaderManagerImpl.start(CacheLoaderManagerImpl.java:102)
                ... 13 more
            Caused by: org.infinispan.loaders.CacheLoaderException: java.sql.SQLException: ORA-00902: invalid datatype
            
                at org.infinispan.loaders.jdbc.TableManipulation.executeUpdateSql(TableManipulation.java:177)
                at org.infinispan.loaders.jdbc.TableManipulation.createTable(TableManipulation.java:152)
                at org.infinispan.loaders.jdbc.TableManipulation.start(TableManipulation.java:250)
                at org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore.doConnectionFactoryInitialization(JdbcStringBasedCacheStore.java:299)
                at org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore.start(JdbcStringBasedCacheStore.java:98)
                at org.infinispan.loaders.CacheLoaderManagerImpl.start(CacheLoaderManagerImpl.java:99)
                ... 13 more
            Caused by: java.sql.SQLException: ORA-00902: invalid datatype
            
                at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
                at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
                at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
                at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
                at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
                at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1614)
                at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1579)
                at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
                at org.infinispan.loaders.jdbc.TableManipulation.executeUpdateSql(TableManipulation.java:174)
                ... 18 more
            

             

             

            Please help on this regard

            • 3. Re: JdbcStringBasedCacheStore entering "-1" in TIMESTAMP_COLUMN
              Mircea Markus Master

              Hi,

              I've just have a look at the code in that area and it seems to be right. Anyway, can you please enable TRACE logging so that we have more logs. I'm particulary interested in logs from org.infinispan.loaders.jdbc.TableManipulation, as these log all the SQLs sent to the database. Can you please try mapping that column to Oracle's  NUMERIC type? This table I found is looks very useful: http://www.castor.org/ddlgen-mapping.html

              • 4. Re: JdbcStringBasedCacheStore entering "-1" in TIMESTAMP_COLUMN
                Anitha Kothandapani Newbie

                Hi

                 

                Thanks for your reply. I tried Numeric as below

                <property name="timestampColumnType" value="NUMERIC"/>
                

                 

                But this time , it didnt throw me any exception . But the data is still "-1" only. Anyway I will try enabling trace log and get back to you.