org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [ select straight_join r.record_id, r.oai_datestamp, r.format_id, r.status, r.type, r.prev_status , x.xml, max(u.date_updated) as date_updated from xc_testting2.record_updates u force index (idx_record_updates_record_id), xc_testting2.records r , xc_testting2.records_xml x where r.record_id = x.record_id and (r.record_id > ? or ? is null) and r.record_id = u.record_id and (u.date_updated >= ? or ? is null) and u.date_updated <= ? and status in ('A','D') group by u.record_id order by u.record_id limit 1000]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Key 'idx_record_updates_record_id' doesn't exist in table 'u'

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

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via GitHub by patrickzurek
, 1 year ago
PreparedStatementCallback; bad SQL grammar [ select straight_join r.record_id, r.oai_datestamp, r.format_id, r.status, r.type, r.prev_status , x.xml, max(u.date_updated) as date_updated from xc_testting2.record_updates u force index
via Stack Overflow by Unknown author, 2 years ago
PreparedStatementCallback; bad SQL grammar [CALL sp_myStoredProcedure(?) ]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '@P0'.
via Stack Overflow by User146378
, 1 year ago
PreparedStatementCallback; bad SQL grammar [{call storeproc1(?,?,?,?,?,?,?,?)}]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: The server failed to resume the transaction. Desc:a600000018.
via Stack Overflow by Rushikesh
, 2 years ago
PreparedStatementCallback; bad SQL grammar [SELECT * FROM CASE_UPLOADS WHERE UPLOAD_DT >=01/05/15AND UPLOAD_DT <=31/05/15]; nested exception is java.sql.SQLException: ORA-00932: inconsistent datatypes: expected DATE got NUMBER
via Stack Overflow by jmmut
, 1 week ago
LIKE ?) AND ((ss_id > ?)) ORDER BY ss_id ASC LIMIT 100]; nested exception is org.postgresql.util.PSQLException: ERROR: column "ss_id" does not exist Position: 1472
via Stack Overflow by gohil90
, 2 years ago
CallableStatementCallback; bad SQL grammar [{call schemaname.my_pkg_name.update_email(?, ?)}]; nested exception is org.postgresql.util.PSQLException: ERROR: function schemaname.my_pkg_name.update_email(integer) does not exist
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [ select straight_join r.record_id, r.oai_datestamp, r.format_id, r.status, r.type, r.prev_status , x.xml, max(u.date_updated) as date_updated from xc_testting2.record_updates u force index (idx_record_updates_record_id), xc_testting2.records r , xc_testting2.records_xml x where r.record_id = x.record_id and (r.record_id > ? or ? is null) and r.record_id = u.record_id and (u.date_updated >= ? or ? is null) and u.date_updated <= ? and status in ('A','D') group by u.record_id order by u.record_id limit 1000]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Key 'idx_record_updates_record_id' doesn't exist in table 'u'
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673)
at xc.mst.repo.RepositoryDAO.getRecords(RepositoryDAO.java:1112)
at xc.mst.repo.RepositoryDAO.getRecordsWSets(RepositoryDAO.java:1436)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 2 years 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, 1 year ago

Write tip

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