org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar ; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mifostenant-default.x' doesn't exist

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Google Groups by Michael Vorburger (JIRA), 5 months ago
StatementCallback; bad SQL grammar ; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mifostenant-default.x' doesn't exist
via Stack Overflow by Bappaditya Sasmal
, 2 years ago
StatementCallback; bad SQL grammar [INSERT INTO employee(id, name,salary) VALUES(99,'ABC',12333)]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00900: invalid SQL statement
via Atlassian JIRA by Renan Battaglin, 1 year ago
StatementCallback; bad SQL grammar [SELECT id, directory_name FROM CWD_DIRECTORY WHERE directory_type = 'INTERNAL']; nested exception is java.sql.SQLException: Table 'jira4.CWD_DIRECTORY' doesn't exist
via Atlassian JIRA by Renan Battaglin, 1 year ago
StatementCallback; bad SQL grammar [SELECT id, directory_name FROM CWD_DIRECTORY WHERE directory_type = 'INTERNAL']; nested exception is java.sql.SQLException: Table 'jira4.CWD_DIRECTORY' doesn't exist
via Stack Overflow by subhashis
, 7 months ago
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
via Stack Overflow by Chakri
, 1 year ago
PreparedStatementCallback; bad SQL grammar [ SELECT DISTINCT O.ORGID FROM ORGANISATIONS O WHERE O.ORGTYPE NOT IN ('P','G') AND O.USERID = 40]; nested exception is java.sql.SQLException: Invalid column name
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar ; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mifostenant-default.x' doesn't exist
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
at org.mifosplatform.infrastructure.dataqueries.service.ReadReportingServiceImpl.getSql(ReadReportingServiceImpl.java:221)
at org.mifosplatform.infrastructure.dataqueries.service.ReadReportingServiceImpl.getSQLtoRun(ReadReportingServiceImpl.java:193)
at org.mifosplatform.infrastructure.dataqueries.service.ReadReportingServiceImpl.retrieveGenericResultset(ReadReportingServiceImpl.java:182)
at org.mifosplatform.infrastructure.dataqueries.api.RunreportsApiResource.runReport(RunreportsApiResource.java:107)

Users with the same issue

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

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.