Skip to content

Instantly share code, notes, and snippets.

@mgencur
Created November 28, 2011 14:32
Show Gist options
  • Save mgencur/1400596 to your computer and use it in GitHub Desktop.
Save mgencur/1400596 to your computer and use it in GitHub Desktop.
jdbc_driver_exception
[java] 15:27:26,592 ERROR [org.infinispan.loaders.jdbc.TableManipulation] (MSC service thread 1-4) ISPN008011: Error while creating table; used DDL statement: 'CREATE TABLE EDG_STRING_BASED_NO_PASSIVATION_TABLE_default(id VARCHAR NOT NULL, datum BINARY, version BIGINT, PRIMARY KEY (id))': com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL, datum BINARY, version BIGINT, PRIMARY KEY (id))' at line 1
[java] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [:1.6.0_21]
[java] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) [:1.6.0_21]
[java] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) [:1.6.0_21]
[java] at java.lang.reflect.Constructor.newInstance(Constructor.java:513) [:1.6.0_21]
[java] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
[java] at com.mysql.jdbc.Util.getInstance(Util.java:386)
[java] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
[java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
[java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
[java] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
[java] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
[java] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619)
[java] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1709)
[java] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1628)
[java] at org.jboss.jca.adapters.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:349)
[java] at org.infinispan.loaders.jdbc.TableManipulation.executeUpdateSql(TableManipulation.java:184) [infinispan-cachestore-jdbc-5.1.0-SNAPSHOT.jar:]
[java] at org.infinispan.loaders.jdbc.TableManipulation.createTable(TableManipulation.java:160) [infinispan-cachestore-jdbc-5.1.0-SNAPSHOT.jar:]
[java] at org.infinispan.loaders.jdbc.TableManipulation.start(TableManipulation.java:261) [infinispan-cachestore-jdbc-5.1.0-SNAPSHOT.jar:]
[java] at org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore.doConnectionFactoryInitialization(JdbcStringBasedCacheStore.java:344) [infinispan-cachestore-jdbc-5.1.0-SNAPSHOT.jar:]
[java] at org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore.start(JdbcStringBasedCacheStore.java:121) [infinispan-cachestore-jdbc-5.1.0-SNAPSHOT.jar:]
[java] at org.infinispan.loaders.CacheLoaderManagerImpl.start(CacheLoaderManagerImpl.java:128) [infinispan-core-5.1.0-SNAPSHOT.jar:]
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [:1.6.0_21]
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [:1.6.0_21]
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [:1.6.0_21]
[java] at java.lang.reflect.Method.invoke(Method.java:597) [:1.6.0_21]
[java] at org.infinispan.util.ReflectionUtil.invokeAccessibly(ReflectionUtil.java:203) [infinispan-core-5.1.0-SNAPSHOT.jar:]
[java] at org.infinispan.factories.AbstractComponentRegistry$PrioritizedMethod.invoke(AbstractComponentRegistry.java:825) [infinispan-core-5.1.0-SNAPSHOT.jar:]
[java] at org.infinispan.factories.AbstractComponentRegistry.internalStart(AbstractComponentRegistry.java:624) [infinispan-core-5.1.0-SNAPSHOT.jar:]
[java] at org.infinispan.factories.AbstractComponentRegistry.start(AbstractComponentRegistry.java:527) [infinispan-core-5.1.0-SNAPSHOT.jar:]
[java] at org.infinispan.factories.ComponentRegistry.start(ComponentRegistry.java:177) [infinispan-core-5.1.0-SNAPSHOT.jar:]
[java] at org.infinispan.CacheImpl.start(CacheImpl.java:473) [infinispan-core-5.1.0-SNAPSHOT.jar:]
[java] at org.infinispan.manager.DefaultCacheManager.createCache(DefaultCacheManager.java:562) [infinispan-core-5.1.0-SNAPSHOT.jar:]
[java] at org.infinispan.manager.DefaultCacheManager.getCache(DefaultCacheManager.java:451) [infinispan-core-5.1.0-SNAPSHOT.jar:]
[java] at org.infinispan.manager.DefaultCacheManager.getCache(DefaultCacheManager.java:465) [infinispan-core-5.1.0-SNAPSHOT.jar:]
[java] at org.jboss.as.clustering.infinispan.DefaultEmbeddedCacheManager.getCache(DefaultEmbeddedCacheManager.java:100) [jboss-as-clustering-infinispan-7.1.0.Beta1.jar:]
[java] at org.jboss.as.clustering.infinispan.DefaultEmbeddedCacheManager.getCache(DefaultEmbeddedCacheManager.java:91) [jboss-as-clustering-infinispan-7.1.0.Beta1.jar:]
[java] at org.jboss.as.clustering.infinispan.subsystem.CacheService.start(CacheService.java:89) [jboss-as-clustering-infinispan-7.1.0.Beta1.jar:]
[java] at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1824) [jboss-msc-1.0.1.GA.jar:]
[java] at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1759) [jboss-msc-1.0.1.GA.jar:]
[java] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [:1.6.0_21]
[java] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [:1.6.0_21]
[java] at java.lang.Thread.run(Thread.java:619) [:1.6.0_21]
[java] 15:27:26,633 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-4) MSC00001: Failed to start service jboss.infinispan.default.default: org.jboss.msc.service.StartException in service jboss.infinispan.default.default: Failed to start service
[java] at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1780) [jboss-msc-1.0.1.GA.jar:]
[java] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [:1.6.0_21]
[java] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [:1.6.0_21]
[java] at java.lang.Thread.run(Thread.java:619) [:1.6.0_21]
[java] Caused by: org.infinispan.CacheException: Unable to invoke method public void org.infinispan.loaders.CacheLoaderManagerImpl.start() on object
[java] at org.infinispan.util.ReflectionUtil.invokeAccessibly(ReflectionUtil.java:205)
[java] at org.infinispan.factories.AbstractComponentRegistry$PrioritizedMethod.invoke(AbstractComponentRegistry.java:825)
[java] at org.infinispan.factories.AbstractComponentRegistry.internalStart(AbstractComponentRegistry.java:624)
[java] at org.infinispan.factories.AbstractComponentRegistry.start(AbstractComponentRegistry.java:527)
[java] at org.infinispan.factories.ComponentRegistry.start(ComponentRegistry.java:177)
[java] at org.infinispan.CacheImpl.start(CacheImpl.java:473)
[java] at org.infinispan.manager.DefaultCacheManager.createCache(DefaultCacheManager.java:562)
[java] at org.infinispan.manager.DefaultCacheManager.getCache(DefaultCacheManager.java:451)
[java] at org.infinispan.manager.DefaultCacheManager.getCache(DefaultCacheManager.java:465)
[java] at org.jboss.as.clustering.infinispan.DefaultEmbeddedCacheManager.getCache(DefaultEmbeddedCacheManager.java:100)
[java] at org.jboss.as.clustering.infinispan.DefaultEmbeddedCacheManager.getCache(DefaultEmbeddedCacheManager.java:91)
[java] at org.jboss.as.clustering.infinispan.subsystem.CacheService.start(CacheService.java:89)
[java] at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1824) [jboss-msc-1.0.1.GA.jar:]
[java] at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1759) [jboss-msc-1.0.1.GA.jar:]
[java] ... 3 more
[java] Caused by: java.lang.reflect.InvocationTargetException
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [:1.6.0_21]
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [:1.6.0_21]
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [:1.6.0_21]
[java] at java.lang.reflect.Method.invoke(Method.java:597) [:1.6.0_21]
[java] at org.infinispan.util.ReflectionUtil.invokeAccessibly(ReflectionUtil.java:203)
[java] ... 16 more
[java] Caused by: org.infinispan.CacheException: Unable to start cache loaders
[java] at org.infinispan.loaders.CacheLoaderManagerImpl.start(CacheLoaderManagerImpl.java:131)
[java] ... 21 more
[java] Caused by: org.infinispan.loaders.CacheLoaderException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL, datum BINARY, version BIGINT, PRIMARY KEY (id))' at line 1
[java] at org.infinispan.loaders.jdbc.TableManipulation.executeUpdateSql(TableManipulation.java:187)
[java] at org.infinispan.loaders.jdbc.TableManipulation.createTable(TableManipulation.java:160)
[java] at org.infinispan.loaders.jdbc.TableManipulation.start(TableManipulation.java:261)
[java] at org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore.doConnectionFactoryInitialization(JdbcStringBasedCacheStore.java:344)
[java] at org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore.start(JdbcStringBasedCacheStore.java:121)
[java] at org.infinispan.loaders.CacheLoaderManagerImpl.start(CacheLoaderManagerImpl.java:128)
[java] ... 21 more
[java] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL, datum BINARY, version BIGINT, PRIMARY KEY (id))' at line 1
[java] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [:1.6.0_21]
[java] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) [:1.6.0_21]
[java] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) [:1.6.0_21]
[java] at java.lang.reflect.Constructor.newInstance(Constructor.java:513) [:1.6.0_21]
[java] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
[java] at com.mysql.jdbc.Util.getInstance(Util.java:386)
[java] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
[java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
[java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
[java] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
[java] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
[java] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619)
[java] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1709)
[java] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1628)
[java] at org.jboss.jca.adapters.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:349)
[java] at org.infinispan.loaders.jdbc.TableManipulation.executeUpdateSql(TableManipulation.java:184)
[java] ... 26 more
[java] 15:27:26,753 INFO [com.redhat.datagrid.endpoint.ProtocolServerService] (MSC service thread 1-3) HotRodServer started in 2541ms
[java] 15:27:26,753 INFO [com.redhat.datagrid.endpoint.ProtocolServerService] (MSC service thread 1-1) MemcachedServer started in 2570ms
[java] 15:27:26,774 INFO [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service status report
[java] JBAS014777: Services which failed to start: service jboss.infinispan.default.default: org.jboss.msc.service.StartException in service jboss.infinispan.default.default: Failed to start service
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment