org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [DELETE FROM SPRING_SESSION WHERE LAST_ACCESS_TIME < ?]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'test.spring_session' doesn't exist

Stack Overflow | javatechnology | 8 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'test.spring_session' doesn't exist - Spring Boot

    Stack Overflow | 8 months ago | javatechnology
    org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [DELETE FROM SPRING_SESSION WHERE LAST_ACCESS_TIME < ?]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'test.spring_session' doesn't exist
  2. 0

    Bunch of Errors after I run my Code

    Stack Overflow | 5 years ago | user962206
    org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [INSERT INTO PERSON (empID,password) VALUES(?,?)]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'empID' in 'field list'
  3. 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.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    SQL exception & stacktrace

    GitHub | 3 years ago | mibby
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
  6. 0

    Error com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

    Stack Overflow | 3 years ago | CODE FISH
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'testspring.user' doesn't exist
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

    Table 'test.spring_session' doesn't exist

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
  2. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[na:1.8.0_45]
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[na:1.8.0_45]
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[na:1.8.0_45]
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:422)[na:1.8.0_45]
    4 frames
  3. MySQL jdbc
    PreparedStatement.executeUpdate
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:404)[mysql-connector-java-5.1.39.jar:5.1.39]
    2. com.mysql.jdbc.Util.getInstance(Util.java:387)[mysql-connector-java-5.1.39.jar:5.1.39]
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:942)[mysql-connector-java-5.1.39.jar:5.1.39]
    4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966)[mysql-connector-java-5.1.39.jar:5.1.39]
    5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)[mysql-connector-java-5.1.39.jar:5.1.39]
    6. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526)[mysql-connector-java-5.1.39.jar:5.1.39]
    7. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673)[mysql-connector-java-5.1.39.jar:5.1.39]
    8. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)[mysql-connector-java-5.1.39.jar:5.1.39]
    9. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)[mysql-connector-java-5.1.39.jar:5.1.39]
    10. com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)[mysql-connector-java-5.1.39.jar:5.1.39]
    11. com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2009)[mysql-connector-java-5.1.39.jar:5.1.39]
    12. com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5098)[mysql-connector-java-5.1.39.jar:5.1.39]
    13. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1994)[mysql-connector-java-5.1.39.jar:5.1.39]
    13 frames
  4. Spring Framework
    JdbcTemplate.update
    1. org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:877)[spring-jdbc-4.3.2.RELEASE.jar:4.3.2.RELEASE]
    2. org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:870)[spring-jdbc-4.3.2.RELEASE.jar:4.3.2.RELEASE]
    3. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:633)[spring-jdbc-4.3.2.RELEASE.jar:4.3.2.RELEASE]
    4. org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:870)[spring-jdbc-4.3.2.RELEASE.jar:4.3.2.RELEASE]
    5. org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:931)[spring-jdbc-4.3.2.RELEASE.jar:4.3.2.RELEASE]
    6. org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:941)[spring-jdbc-4.3.2.RELEASE.jar:4.3.2.RELEASE]
    6 frames
  5. org.springframework.session
    JdbcOperationsSessionRepository$6.doInTransaction
    1. org.springframework.session.jdbc.JdbcOperationsSessionRepository$6.doInTransaction(JdbcOperationsSessionRepository.java:481)[spring-session-1.2.1.RELEASE.jar:na]
    2. org.springframework.session.jdbc.JdbcOperationsSessionRepository$6.doInTransaction(JdbcOperationsSessionRepository.java:478)[spring-session-1.2.1.RELEASE.jar:na]
    2 frames
  6. Spring Tx
    TransactionTemplate.execute
    1. org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)[spring-tx-4.3.2.RELEASE.jar:4.3.2.RELEASE]
    1 frame
  7. org.springframework.session
    JdbcOperationsSessionRepository.cleanUpExpiredSessions
    1. org.springframework.session.jdbc.JdbcOperationsSessionRepository.cleanUpExpiredSessions(JdbcOperationsSessionRepository.java:478)[spring-session-1.2.1.RELEASE.jar:na]
    1 frame
  8. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.8.0_45]
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)[na:1.8.0_45]
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.8.0_45]
    4. java.lang.reflect.Method.invoke(Method.java:497)[na:1.8.0_45]
    4 frames
  9. Spring Context
    ReschedulingRunnable.run
    1. org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65)[spring-context-4.3.2.RELEASE.jar:4.3.2.RELEASE]
    2. org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)[spring-context-4.3.2.RELEASE.jar:4.3.2.RELEASE]
    3. org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)[spring-context-4.3.2.RELEASE.jar:4.3.2.RELEASE]
    3 frames
  10. Java RT
    Thread.run
    1. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)[na:1.8.0_45]
    2. java.util.concurrent.FutureTask.run(FutureTask.java:266)[na:1.8.0_45]
    3. java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)[na:1.8.0_45]
    4. java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)[na:1.8.0_45]
    5. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)[na:1.8.0_45]
    6. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)[na:1.8.0_45]
    7. java.lang.Thread.run(Thread.java:745)[na:1.8.0_45]
    7 frames