com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'sequences' in information_schema

Google Groups | Nick | 1 year ago
  1. 0

    Fail to execute kie execution server and kie workbench on same server

    Google Groups | 1 year ago | Nick
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'sequences' in information_schema
  2. 0

    Unknown column 'prefix' in 'field list'

    GitHub | 2 years ago | Hendrikvd
    ru.tehkode.permissions.exceptions.PermissionBackendException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'prefix' in 'field list'
  3. 0

    Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax

    Stack Overflow | 2 years ago
    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 '? AND lexicon_lemma = ?)' at line 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Connect to a user input database

    Stack Overflow | 2 years ago
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user ''@'localhost' to database 'test2' Cannot connect to database test2
  6. 0

    MySQL server configuration issues

    Stack Overflow | 2 years ago
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size. Increase the redo log size using innodb_log_file_size.
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

    Unknown table 'sequences' in information_schema

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
  2. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:422)
    4 frames
  3. MySQL jdbc
    StatementWrapper.executeQuery
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
    2. com.mysql.jdbc.Util.getInstance(Util.java:387)
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:941)
    4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3870)
    5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3806)
    6. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2470)
    7. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2617)
    8. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2546)
    9. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2504)
    10. com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1370)
    11. com.mysql.jdbc.jdbc2.optional.StatementWrapper.executeQuery(StatementWrapper.java:669)
    11 frames
  4. Bitronix Transaction Manager :: Core
    JdbcStatementHandle.executeQuery
    1. bitronix.tm.resource.jdbc.JdbcStatementHandle.executeQuery(JdbcStatementHandle.java:83)
    1 frame
  5. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:497)
    4 frames
  6. Bitronix Transaction Manager :: Core
    BaseProxyHandlerClass.invoke
    1. bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)
    1 frame
  7. com.sun.proxy
    $Proxy47.executeQuery
    1. com.sun.proxy.$Proxy47.executeQuery(Unknown Source)
    1 frame
  8. Hibernate
    Configuration.buildSessionFactory
    1. org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:177)
    2. org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:91)
    3. org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:83)
    4. org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:221)
    5. org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:203)
    6. org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:509)
    7. org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1799)
    7 frames
  9. Hibernate EJB
    HibernatePersistence.createContainerEntityManagerFactory
    1. org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:96)
    2. org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:915)
    3. org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:900)
    4. org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:76)
    4 frames
  10. org.kie.server
    Bootstrap.contextInitialized
    1. org.kie.server.services.jbpm.JbpmKieServerExtension.build(JbpmKieServerExtension.java:424)
    2. org.kie.server.services.jbpm.JbpmKieServerExtension.init(JbpmKieServerExtension.java:134)
    3. org.kie.server.services.impl.KieServerImpl.<init>(KieServerImpl.java:93)
    4. org.kie.server.services.impl.KieServerLocator.<clinit>(KieServerLocator.java:20)
    5. org.kie.server.services.Bootstrap.contextInitialized(Bootstrap.java:50)
    5 frames
  11. Glassfish Core
    HostConfig$DeployWar.run
    1. org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4738)
    2. org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5181)
    3. org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
    4. org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
    5. org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
    6. org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
    7. org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)
    8. org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1798)
    8 frames
  12. Java RT
    Thread.run
    1. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    2. java.util.concurrent.FutureTask.run(FutureTask.java:266)
    3. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    4. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    5. java.lang.Thread.run(Thread.java:745)
    5 frames