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 web88

Solution icon of web
via nabble.com by Unknown author, 9 months ago
PreparedStatementCallback; bad SQL grammar []; 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 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 github
via GitHub by iav
, 5 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

Solution icon of spring
via Spring JIRA by Sven Bonacker, 1 year ago
PreparedStatementCallback; bad SQL grammar [SELECT JOB_EXECUTION_ID, START_TIME, END_TIME, STATUS, EXIT_CODE, EXIT_MESSAGE, CREATE_TIME, LAST_UPDATED, VERSION from BATCH_JOB_EXECUTION where JOB_EXECUTION_ID = ?]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: Tabelle oder View nicht vorhanden

Solution icon of spring
via Spring JIRA by Sven Bonacker, 1 year ago
PreparedStatementCallback; bad SQL grammar [SELECT JOB_EXECUTION_ID, START_TIME, END_TIME, STATUS, EXIT_CODE, EXIT_MESSAGE, CREATE_TIME, LAST_UPDATED, VERSION from BATCH_JOB_EXECUTION where JOB_EXECUTION_ID = ?]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: Tabelle oder View nicht vorhanden

Solution icon of web
via com.br by Unknown author, 1 year ago
Executing query; bad SQL grammar [select ar.num_artigo_st ,ar.des_artigo from artigo_st1 ar]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: a tabela ou view não existe

Solution icon of web
via com.br by Unknown author, 1 year ago
Executing query; bad SQL grammar [select ar.num_artigo_st ,ar.des_artigo from artigo_st1 ar]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: a tabela ou view não existe

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

2 times, 2 weeks ago
12 times, 8 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