[infinispan-issues] [JBoss JIRA] (ISPN-7685) JDBC Sybase upsert fails

JDBC Sybase upsert fails ------------------------ Key: ISPN-7685 URL: https://issues.jboss.org/browse/ISPN-7685 Project: Infinispan Issue Type: Bug Components: Loaders and Stores Affects Versions: 9.0.0.CR4 Reporter: Ryan Emerson Assignee: Ryan Emerson Fix For: 9.0.0.Final Writes to the underlying JDBC store fail with the following exception: {code:java} 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 {code}