Details

    • Workaround:
      Workaround Exists
    • Workaround Description:
      Hide

      Disable upsert by setting the following property on the store `<property name="infinispan.jdbc.upsert.disabled">true</property>`

      Show
      Disable upsert by setting the following property on the store `<property name="infinispan.jdbc.upsert.disabled">true</property>`

      Description

      Writes to the underlying JDBC store fail with the following exception:

      14:50:01.919 [main] ERROR org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore - ISPN008024: Error while storing string key to database; key: '41'
      com.sybase.jdbc4.jdbc.SybSQLException: Incorrect syntax near the keyword 'VALUES'.
      
      	at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4131) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
      	at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3247) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
      	at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
      	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:294) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
      	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:276) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
      	at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2749) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
      	at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2733) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
      	at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:335) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
      	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) ~[HikariCP-2.4.6.jar:?]
      	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) ~[HikariCP-2.4.6.jar:?]
      	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.executeUpsert(JdbcStringBasedStore.java:224) ~[infinispan-cachestore-jdbc-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.write(JdbcStringBasedStore.java:209) ~[infinispan-cachestore-jdbc-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.write(JdbcStringBasedStore.java:189) ~[infinispan-cachestore-jdbc-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.persistence.manager.PersistenceManagerImpl.lambda$writeToAllNonTxStores$9(PersistenceManagerImpl.java:518) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184) ~[?:1.8.0_112]
      	at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:175) ~[?:1.8.0_112]
      	at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:175) ~[?:1.8.0_112]
      	at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1374) ~[?:1.8.0_112]
      	at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481) ~[?:1.8.0_112]
      	at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471) ~[?:1.8.0_112]
      	at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151) ~[?:1.8.0_112]
      	at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174) ~[?:1.8.0_112]
      	at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) ~[?:1.8.0_112]
      	at java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:418) ~[?:1.8.0_112]
      	at org.infinispan.persistence.manager.PersistenceManagerImpl.writeToAllNonTxStores(PersistenceManagerImpl.java:518) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.impl.CacheWriterInterceptor.storeEntry(CacheWriterInterceptor.java:480) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.impl.CacheWriterInterceptor.lambda$visitPutKeyValueCommand$1(CacheWriterInterceptor.java:189) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextThenAccept(BaseAsyncInterceptor.java:108) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.impl.CacheWriterInterceptor.visitPutKeyValueCommand(CacheWriterInterceptor.java:181) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNext(BaseAsyncInterceptor.java:57) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.impl.CacheLoaderInterceptor.visitDataCommand(CacheLoaderInterceptor.java:196) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.impl.CacheLoaderInterceptor.visitPutKeyValueCommand(CacheLoaderInterceptor.java:133) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextThenAccept(BaseAsyncInterceptor.java:101) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.impl.EntryWrappingInterceptor.setSkipRemoteGetsAndInvokeNextForDataCommand(EntryWrappingInterceptor.java:675) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.impl.EntryWrappingInterceptor.visitPutKeyValueCommand(EntryWrappingInterceptor.java:303) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextAndFinally(BaseAsyncInterceptor.java:153) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.locking.AbstractLockingInterceptor.visitNonTxDataWriteCommand(AbstractLockingInterceptor.java:116) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.locking.NonTransactionalLockingInterceptor.visitDataWriteCommand(NonTransactionalLockingInterceptor.java:39) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.locking.AbstractLockingInterceptor.visitPutKeyValueCommand(AbstractLockingInterceptor.java:77) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNext(BaseAsyncInterceptor.java:57) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.impl.CacheMgmtInterceptor.updateStoreStatistics(CacheMgmtInterceptor.java:167) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.impl.CacheMgmtInterceptor.visitPutKeyValueCommand(CacheMgmtInterceptor.java:156) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextAndExceptionally(BaseAsyncInterceptor.java:126) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.impl.InvocationContextInterceptor.visitCommand(InvocationContextInterceptor.java:94) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.impl.AsyncInterceptorChainImpl.invoke(AsyncInterceptorChainImpl.java:248) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.cache.impl.CacheImpl.executeCommandAndCommitIfNeeded(CacheImpl.java:1489) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.cache.impl.CacheImpl.putInternal(CacheImpl.java:1120) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.cache.impl.CacheImpl.put(CacheImpl.java:1110) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.cache.impl.CacheImpl.put(CacheImpl.java:1559) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.cache.impl.CacheImpl.put(CacheImpl.java:249) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.cache.impl.AbstractDelegatingCache.put(AbstractDelegatingCache.java:358) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.cache.impl.TypeConverterDelegatingAdvancedCache.put(TypeConverterDelegatingAdvancedCache.java:173) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.jboss.set.JdbcWriter.main(JdbcWriter.java:18) [classes/:?]
      14:50:01.931 [main] ERROR org.infinispan.interceptors.impl.InvocationContextInterceptor - ISPN000136: Error executing command PutKeyValueCommand, writing keys [1]
      org.infinispan.persistence.spi.PersistenceException: Error while storing string key to database; key: '41'
      	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.write(JdbcStringBasedStore.java:192) ~[infinispan-cachestore-jdbc-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.persistence.manager.PersistenceManagerImpl.lambda$writeToAllNonTxStores$9(PersistenceManagerImpl.java:518) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184) ~[?:1.8.0_112]
      	at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:175) ~[?:1.8.0_112]
      	at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:175) ~[?:1.8.0_112]
      	at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1374) ~[?:1.8.0_112]
      	at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481) ~[?:1.8.0_112]
      	at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471) ~[?:1.8.0_112]
      	at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151) ~[?:1.8.0_112]
      	at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174) ~[?:1.8.0_112]
      	at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) ~[?:1.8.0_112]
      	at java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:418) ~[?:1.8.0_112]
      	at org.infinispan.persistence.manager.PersistenceManagerImpl.writeToAllNonTxStores(PersistenceManagerImpl.java:518) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.impl.CacheWriterInterceptor.storeEntry(CacheWriterInterceptor.java:480) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.impl.CacheWriterInterceptor.lambda$visitPutKeyValueCommand$1(CacheWriterInterceptor.java:189) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextThenAccept(BaseAsyncInterceptor.java:108) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.impl.CacheWriterInterceptor.visitPutKeyValueCommand(CacheWriterInterceptor.java:181) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNext(BaseAsyncInterceptor.java:57) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.impl.CacheLoaderInterceptor.visitDataCommand(CacheLoaderInterceptor.java:196) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.impl.CacheLoaderInterceptor.visitPutKeyValueCommand(CacheLoaderInterceptor.java:133) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextThenAccept(BaseAsyncInterceptor.java:101) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.impl.EntryWrappingInterceptor.setSkipRemoteGetsAndInvokeNextForDataCommand(EntryWrappingInterceptor.java:675) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.impl.EntryWrappingInterceptor.visitPutKeyValueCommand(EntryWrappingInterceptor.java:303) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextAndFinally(BaseAsyncInterceptor.java:153) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.locking.AbstractLockingInterceptor.visitNonTxDataWriteCommand(AbstractLockingInterceptor.java:116) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.locking.NonTransactionalLockingInterceptor.visitDataWriteCommand(NonTransactionalLockingInterceptor.java:39) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.locking.AbstractLockingInterceptor.visitPutKeyValueCommand(AbstractLockingInterceptor.java:77) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNext(BaseAsyncInterceptor.java:57) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.impl.CacheMgmtInterceptor.updateStoreStatistics(CacheMgmtInterceptor.java:167) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.impl.CacheMgmtInterceptor.visitPutKeyValueCommand(CacheMgmtInterceptor.java:156) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74) ~[infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextAndExceptionally(BaseAsyncInterceptor.java:126) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.impl.InvocationContextInterceptor.visitCommand(InvocationContextInterceptor.java:94) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.interceptors.impl.AsyncInterceptorChainImpl.invoke(AsyncInterceptorChainImpl.java:248) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.cache.impl.CacheImpl.executeCommandAndCommitIfNeeded(CacheImpl.java:1489) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.cache.impl.CacheImpl.putInternal(CacheImpl.java:1120) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.cache.impl.CacheImpl.put(CacheImpl.java:1110) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.cache.impl.CacheImpl.put(CacheImpl.java:1559) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.cache.impl.CacheImpl.put(CacheImpl.java:249) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.cache.impl.AbstractDelegatingCache.put(AbstractDelegatingCache.java:358) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.cache.impl.TypeConverterDelegatingAdvancedCache.put(TypeConverterDelegatingAdvancedCache.java:173) [infinispan-core-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.jboss.set.JdbcWriter.main(JdbcWriter.java:18) [classes/:?]
      Caused by: com.sybase.jdbc4.jdbc.SybSQLException: Incorrect syntax near the keyword 'VALUES'.
      
      	at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4131) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
      	at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3247) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
      	at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
      	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:294) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
      	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:276) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
      	at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2749) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
      	at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2733) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
      	at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:335) ~[jconn-4.jar:JDK 1.6/jdbcmain/Tue Sep  1 02:27:47 PDT 2015]
      	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) ~[HikariCP-2.4.6.jar:?]
      	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) ~[HikariCP-2.4.6.jar:?]
      	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.executeUpsert(JdbcStringBasedStore.java:224) ~[infinispan-cachestore-jdbc-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.write(JdbcStringBasedStore.java:209) ~[infinispan-cachestore-jdbc-9.0.0.CR4.jar:9.0.0.CR4]
      	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.write(JdbcStringBasedStore.java:189) ~[infinispan-cachestore-jdbc-9.0.0.CR4.jar:9.0.0.CR4]
      	... 45 more
      Exception in thread "main" org.infinispan.persistence.spi.PersistenceException: Error while storing string key to database; key: '41'
      	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.write(JdbcStringBasedStore.java:192)
      	at org.infinispan.persistence.manager.PersistenceManagerImpl.lambda$writeToAllNonTxStores$9(PersistenceManagerImpl.java:518)
      	at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
      	at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:175)
      	at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:175)
      	at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1374)
      	at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481)
      	at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471)
      	at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
      	at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
      	at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
      	at java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:418)
      	at org.infinispan.persistence.manager.PersistenceManagerImpl.writeToAllNonTxStores(PersistenceManagerImpl.java:518)
      	at org.infinispan.interceptors.impl.CacheWriterInterceptor.storeEntry(CacheWriterInterceptor.java:480)
      	at org.infinispan.interceptors.impl.CacheWriterInterceptor.lambda$visitPutKeyValueCommand$1(CacheWriterInterceptor.java:189)
      	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextThenAccept(BaseAsyncInterceptor.java:108)
      	at org.infinispan.interceptors.impl.CacheWriterInterceptor.visitPutKeyValueCommand(CacheWriterInterceptor.java:181)
      	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74)
      	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNext(BaseAsyncInterceptor.java:57)
      	at org.infinispan.interceptors.impl.CacheLoaderInterceptor.visitDataCommand(CacheLoaderInterceptor.java:196)
      	at org.infinispan.interceptors.impl.CacheLoaderInterceptor.visitPutKeyValueCommand(CacheLoaderInterceptor.java:133)
      	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74)
      	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextThenAccept(BaseAsyncInterceptor.java:101)
      	at org.infinispan.interceptors.impl.EntryWrappingInterceptor.setSkipRemoteGetsAndInvokeNextForDataCommand(EntryWrappingInterceptor.java:675)
      	at org.infinispan.interceptors.impl.EntryWrappingInterceptor.visitPutKeyValueCommand(EntryWrappingInterceptor.java:303)
      	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74)
      	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextAndFinally(BaseAsyncInterceptor.java:153)
      	at org.infinispan.interceptors.locking.AbstractLockingInterceptor.visitNonTxDataWriteCommand(AbstractLockingInterceptor.java:116)
      	at org.infinispan.interceptors.locking.NonTransactionalLockingInterceptor.visitDataWriteCommand(NonTransactionalLockingInterceptor.java:39)
      	at org.infinispan.interceptors.locking.AbstractLockingInterceptor.visitPutKeyValueCommand(AbstractLockingInterceptor.java:77)
      	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74)
      	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNext(BaseAsyncInterceptor.java:57)
      	at org.infinispan.interceptors.impl.CacheMgmtInterceptor.updateStoreStatistics(CacheMgmtInterceptor.java:167)
      	at org.infinispan.interceptors.impl.CacheMgmtInterceptor.visitPutKeyValueCommand(CacheMgmtInterceptor.java:156)
      	at org.infinispan.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:74)
      	at org.infinispan.interceptors.BaseAsyncInterceptor.invokeNextAndExceptionally(BaseAsyncInterceptor.java:126)
      	at org.infinispan.interceptors.impl.InvocationContextInterceptor.visitCommand(InvocationContextInterceptor.java:94)
      	at org.infinispan.interceptors.impl.AsyncInterceptorChainImpl.invoke(AsyncInterceptorChainImpl.java:248)
      	at org.infinispan.cache.impl.CacheImpl.executeCommandAndCommitIfNeeded(CacheImpl.java:1489)
      	at org.infinispan.cache.impl.CacheImpl.putInternal(CacheImpl.java:1120)
      	at org.infinispan.cache.impl.CacheImpl.put(CacheImpl.java:1110)
      	at org.infinispan.cache.impl.CacheImpl.put(CacheImpl.java:1559)
      	at org.infinispan.cache.impl.CacheImpl.put(CacheImpl.java:249)
      	at org.infinispan.cache.impl.AbstractDelegatingCache.put(AbstractDelegatingCache.java:358)
      	at org.infinispan.cache.impl.TypeConverterDelegatingAdvancedCache.put(TypeConverterDelegatingAdvancedCache.java:173)
      	at org.jboss.set.JdbcWriter.main(JdbcWriter.java:18)
      Caused by: com.sybase.jdbc4.jdbc.SybSQLException: Incorrect syntax near the keyword 'VALUES'.
      
      	at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4131)
      	at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3247)
      	at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
      	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:294)
      	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:276)
      	at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2749)
      	at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2733)
      	at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:335)
      	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
      	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
      	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.executeUpsert(JdbcStringBasedStore.java:224)
      	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.write(JdbcStringBasedStore.java:209)
      	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.write(JdbcStringBasedStore.java:189)
      	... 45 more
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                ryanemerson Ryan Emerson
                Reporter:
                ryanemerson Ryan Emerson
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: