[JBoss JIRA] (ISPN-7685) JDBC Sybase upsert fails
by Ryan Emerson (JIRA)
[ https://issues.jboss.org/browse/ISPN-7685?page=com.atlassian.jira.plugin.... ]
Ryan Emerson updated ISPN-7685:
-------------------------------
Status: Open (was: New)
> 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
>
> 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}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 9 months
[JBoss JIRA] (ISPN-7685) JDBC Sybase upsert fails
by Ryan Emerson (JIRA)
[ https://issues.jboss.org/browse/ISPN-7685?page=com.atlassian.jira.plugin.... ]
Ryan Emerson updated ISPN-7685:
-------------------------------
Status: Pull Request Sent (was: Open)
Git Pull Request: https://github.com/infinispan/infinispan/pull/5038
> 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
>
> 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}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 9 months
[JBoss JIRA] (ISPN-7685) JDBC Sybase upsert fails
by Ryan Emerson (JIRA)
Ryan Emerson created ISPN-7685:
----------------------------------
Summary: 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
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}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 9 months