org.springframework.jdbc.BadSqlGrammarException

PreparedStatementCallback; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist


Solutions on the web293

Solution icon of web
via nabble.com by Unknown author, 7 months ago
PreparedStatementCallback; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Solution icon of oraclecommunity
via Oracle Community by a9e60255-d7a7-4e6d-924a-3b85a7ea9ace, 1 year ago
PreparedStatementCallback; bad SQL grammar [select * from SNP_LOC_REP]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Solution icon of github
PreparedStatementCallback; bad SQL grammar [SELECT COUNT(*) FROM TASK_EXECUTION ]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Solution icon of oraclecommunity
via Oracle Community by a9e60255-d7a7-4e6d-924a-3b85a7ea9ace, 1 year ago
PreparedStatementCallback; bad SQL grammar [select * from SNP_LOC_REP]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Solution icon of github
StatementCallback; bad SQL grammar [DROP TABLE EXAMPLE."MLOG$_T" CASCADE CONSTRAINTS PURGE]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Solution icon of stackoverflow
StatementCallback; bad SQL grammar [ SELECT 'SCHEDULE_TYPE', SCHEDULED_DATE , 'EMAIL_IDS', LAST_RUN_DATE FROM PIL_GUI_QUARTZ_REPORTS ]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Solution icon of web
PreparedStatementCallback; bad SQL grammar [SELECT JOB_INSTANCE_ID, JOB_NAME from BATCH_JOB_INSTANCE where JOB_NAME = ? and JOB_KEY = ?]; nested exception is java.sql.SQLException: ORA-00942: table or view does not exist

Solution icon of stackoverflow
PreparedStatementCallback; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

Solution icon of oraclecommunity
via Oracle Community by Marley............, 1 year ago
PreparedStatementCallback; bad SQL grammar [select REP_SHORT_ID, REP_NAME, REP_TYPE, REP_TIMESTAMP, REP_VERSION, MIN_EXE_VERSION, IND_INSTALL_OK from SNP_LOC_REP]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: a tabela ou view não existe

Solution icon of github
via GitHub by iav
, 3 months ago
StatementCallback; bad SQL grammar [select db_link as object_name, 'PUBLIC DATABASE LINK' as object_type from DBA_DB_LINKS where owner='PUBLIC']; nested exception is java.sql.SQLException: ORA-00942: table or view does not exist

Stack trace

  • org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:649) at org.apache.camel.component.sql.SqlProducer.process(SqlProducer.java:116)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

12 times, 6 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago