Loading...

XML

Word

Printable

Details

Type: Bug
Resolution: Obsolete
Priority: Major
Fix Version/s: None
Affects Version/s: 5.3.0.Final
Component/s: Loaders and Stores
Labels:
None

Description

It's not possible to deploy appplication using following jdbc cache configuration with defined Sybase datasource:

<binary-keyed-jdbc-store datasource="java:jboss/datasources/testDS" preload="true" passivation="false" purge="false">
                        <binary-keyed-table prefix="stringbased">
                            <id-column name="id" type="VARCHAR(500)"/>
                            <data-column name="datum" type="BINARY"/>
                            <timestamp-column name="version" type="BIGINT"/>
                        </binary-keyed-table>
</binary-keyed-jdbc-store>

Problem is that it cannot create table executing following statement:

CREATE TABLE "b_repl"(id VARCHAR(255) NOT NULL, datum VARBINARY(10000), ver BIGINT, PRIMARY KEY (id))

Correct statement in this configuration is the one without quotation marks. So the deployment fails on WildFly with following exception:

10:07:08,920 ERROR [org.infinispan.loaders.jdbc.TableManipulation] (ServerService Thread Pool -- 57) ISPN008011: Error while creating table; used DDL statement: 'CREATE TABLE "stringbased_default_host_mystore"(id VARCHAR(500) NOT NULL, datum BINARY, version BIGINT, PRIMARY KEY (id))': java.sql.SQLException: Incorrect syntax near '('.

	at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(SybConnection.java:2780)
	at com.sybase.jdbc4.jdbc.SybStatement.handleSQLE(SybStatement.java:2665)
	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:295)
	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:272)
	at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2515)
	at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2499)
	at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:577)
	at org.jboss.jca.adapters.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:375)
	at org.infinispan.loaders.jdbc.TableManipulation.executeUpdateSql(TableManipulation.java:167)
	at org.infinispan.loaders.jdbc.TableManipulation.createTable(TableManipulation.java:143)
	at org.infinispan.loaders.jdbc.TableManipulation.start(TableManipulation.java:245)
	at org.infinispan.loaders.jdbc.binary.JdbcBinaryCacheStore.doConnectionFactoryInitialization(JdbcBinaryCacheStore.java:514)
	at org.infinispan.loaders.jdbc.binary.JdbcBinaryCacheStore.start(JdbcBinaryCacheStore.java:102)
	at org.infinispan.loaders.CacheLoaderManagerImpl.start(CacheLoaderManagerImpl.java:155)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_21]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_21]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_21]
	at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_21]
	at org.infinispan.util.ReflectionUtil.invokeAccessibly(ReflectionUtil.java:205)
	at org.infinispan.factories.AbstractComponentRegistry$PrioritizedMethod.invoke(AbstractComponentRegistry.java:889)
	at org.infinispan.factories.AbstractComponentRegistry.invokeStartMethods(AbstractComponentRegistry.java:658)
	at org.infinispan.factories.AbstractComponentRegistry.internalStart(AbstractComponentRegistry.java:647)
	at org.infinispan.factories.AbstractComponentRegistry.start(AbstractComponentRegistry.java:550)
	at org.infinispan.factories.ComponentRegistry.start(ComponentRegistry.java:221)
	at org.infinispan.CacheImpl.start(CacheImpl.java:691)
	at org.infinispan.manager.DefaultCacheManager.wireAndStartCache(DefaultCacheManager.java:685)
	at org.infinispan.manager.DefaultCacheManager.createCache(DefaultCacheManager.java:648)
	at org.infinispan.manager.DefaultCacheManager.getCache(DefaultCacheManager.java:544)
	at org.infinispan.manager.DefaultCacheManager.getCache(DefaultCacheManager.java:558)
	at org.jboss.as.clustering.infinispan.DefaultEmbeddedCacheManager.getCache(DefaultEmbeddedCacheManager.java:109)
	at org.jboss.as.clustering.infinispan.DefaultEmbeddedCacheManager.getCache(DefaultEmbeddedCacheManager.java:100)
	at org.jboss.as.clustering.infinispan.subsystem.CacheService.start(CacheService.java:78)
	at org.jboss.as.clustering.msc.AsynchronousService$1.run(AsynchronousService.java:82)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_21]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_21]
	at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_21]
	at org.jboss.threads.JBossThread.run(JBossThread.java:122)

10:07:08,941 ERROR [org.jboss.msc.service.fail] (ServerService Thread Pool -- 54) MSC000001: Failed to start service jboss.infinispan.web.repl: org.jboss.msc.service.StartException in service jboss.infinispan.web.repl: org.infinispan.CacheException: Unable to invoke method public void org.infinispan.loaders.CacheLoaderManagerImpl.start() on object of type CacheLoaderManagerImpl
	at org.jboss.as.clustering.msc.AsynchronousService$1.run(AsynchronousService.java:87) [wildfly-clustering-common-8.0.0.Alpha4.jar:8.0.0.Alpha4]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_21]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_21]
	at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_21]
	at org.jboss.threads.JBossThread.run(JBossThread.java:122) [jboss-threads-2.1.0.Final.jar:2.1.0.Final]
Caused by: org.infinispan.CacheException: Unable to invoke method public void org.infinispan.loaders.CacheLoaderManagerImpl.start() on object of type CacheLoaderManagerImpl
	at org.infinispan.util.ReflectionUtil.invokeAccessibly(ReflectionUtil.java:207)
	at org.infinispan.factories.AbstractComponentRegistry$PrioritizedMethod.invoke(AbstractComponentRegistry.java:889)
	at org.infinispan.factories.AbstractComponentRegistry.invokeStartMethods(AbstractComponentRegistry.java:658)
	at org.infinispan.factories.AbstractComponentRegistry.internalStart(AbstractComponentRegistry.java:647)
	at org.infinispan.factories.AbstractComponentRegistry.start(AbstractComponentRegistry.java:550)
	at org.infinispan.factories.ComponentRegistry.start(ComponentRegistry.java:221)
	at org.infinispan.CacheImpl.start(CacheImpl.java:691)
	at org.infinispan.manager.DefaultCacheManager.wireAndStartCache(DefaultCacheManager.java:685)
	at org.infinispan.manager.DefaultCacheManager.createCache(DefaultCacheManager.java:648)
	at org.infinispan.manager.DefaultCacheManager.getCache(DefaultCacheManager.java:544)
	at org.infinispan.manager.DefaultCacheManager.getCache(DefaultCacheManager.java:558)
	at org.jboss.as.clustering.infinispan.DefaultEmbeddedCacheManager.getCache(DefaultEmbeddedCacheManager.java:109)
	at org.jboss.as.clustering.infinispan.DefaultEmbeddedCacheManager.getCache(DefaultEmbeddedCacheManager.java:100)
	at org.jboss.as.clustering.infinispan.subsystem.CacheService.start(CacheService.java:78)
	at org.jboss.as.clustering.msc.AsynchronousService$1.run(AsynchronousService.java:82) [wildfly-clustering-common-8.0.0.Alpha4.jar:8.0.0.Alpha4]
	... 4 more
Caused by: org.infinispan.CacheException: Unable to start cache loaders
	at org.infinispan.loaders.CacheLoaderManagerImpl.start(CacheLoaderManagerImpl.java:163)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_21]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_21]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_21]
	at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_21]
	at org.infinispan.util.ReflectionUtil.invokeAccessibly(ReflectionUtil.java:205)
	... 18 more
Caused by: org.infinispan.loaders.CacheLoaderException: java.sql.SQLException: Incorrect syntax near '('.

	at org.infinispan.loaders.jdbc.TableManipulation.executeUpdateSql(TableManipulation.java:170)
	at org.infinispan.loaders.jdbc.TableManipulation.createTable(TableManipulation.java:143)
	at org.infinispan.loaders.jdbc.TableManipulation.start(TableManipulation.java:245)
	at org.infinispan.loaders.jdbc.binary.JdbcBinaryCacheStore.doConnectionFactoryInitialization(JdbcBinaryCacheStore.java:514)
	at org.infinispan.loaders.jdbc.binary.JdbcBinaryCacheStore.start(JdbcBinaryCacheStore.java:102)
	at org.infinispan.loaders.CacheLoaderManagerImpl.start(CacheLoaderManagerImpl.java:155)
	... 23 more
Caused by: java.sql.SQLException: Incorrect syntax near '('.

	at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(SybConnection.java:2780)
	at com.sybase.jdbc4.jdbc.SybStatement.handleSQLE(SybStatement.java:2665)
	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:295)
	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:272)
	at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2515)
	at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2499)
	at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:577)
	at org.jboss.jca.adapters.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:375)
	at org.infinispan.loaders.jdbc.TableManipulation.executeUpdateSql(TableManipulation.java:167)
	... 28 more

Attachments

Activity

People

Assignee:: Unassigned

Reporter:: Tomas Remes

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2013/09/11 4:15 AM

Updated:: 2021/03/25 11:07 AM

Resolved:: 2021/03/25 11:07 AM