org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select * from QRTZ_BLOB_TRIGGERS]; nested exception is java.sql.SQLException: Invalid object name 'QRTZ_BLOB_TRIGGERS'.. org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select * from QRTZ_BLOB_TRIGGERS]; nested exception is java.sql.SQLException: Invalid object name 'QRTZ_BLOB_TRIGGERS'.

Oracle Community | 807589 | 9 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    quartz

    Oracle Community | 9 years ago | 807589
    org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select * from QRTZ_BLOB_TRIGGERS]; nested exception is java.sql.SQLException: Invalid object name 'QRTZ_BLOB_TRIGGERS'.. org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select * from QRTZ_BLOB_TRIGGERS]; nested exception is java.sql.SQLException: Invalid object name 'QRTZ_BLOB_TRIGGERS'.

    Root Cause Analysis

    1. org.springframework.jdbc.BadSqlGrammarException

      StatementCallback; bad SQL grammar [select * from QRTZ_BLOB_TRIGGERS]; nested exception is java.sql.SQLException: Invalid object name 'QRTZ_BLOB_TRIGGERS'.. org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select * from QRTZ_BLOB_TRIGGERS]; nested exception is java.sql.SQLException: Invalid object name 'QRTZ_BLOB_TRIGGERS'.

      at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate()
    2. Spring Framework
      JdbcTemplate.queryForRowSet
      1. org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:230)
      2. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:353)
      3. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:404)
      4. org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:447)
      4 frames
    3. com.eglue.infra
      EglueJdbcTemplate.queryForRowSet
      1. com.eglue.infra.utils.db.EglueJdbcTemplate.queryForRowSet(EglueJdbcTemplate.java:36)
      1 frame