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

JdbcStringBasedCacheStore entering "-1" in TIMESTAMP_COLUMN

anithakothandapani Aug 16, 2010 8:42 AM

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 Aug 18, 2010 1:09 PM (in response to anithakothandapani)

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?
Actions

2. Re: JdbcStringBasedCacheStore entering "-1" in TIMESTAMP_COLUMN

anithakothandapani Aug 20, 2010 11:00 AM (in response to mircea.markus)

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 Aug 23, 2010 5:44 AM (in response to anithakothandapani)

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
Actions
4. Re: JdbcStringBasedCacheStore entering "-1" in TIMESTAMP_COLUMN

anithakothandapani Aug 23, 2010 8:08 AM (in response to mircea.markus)
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.
Actions

Go to original post