org.springframework.jdbc.BadSqlGrammarException

PreparedStatementCallback; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended 12:32:49,105 ERROR [stderr] (default task-26)


Solutions on the web291

Solution icon of stackoverflow
PreparedStatementCallback; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended 12:32:49,105 ERROR [stderr] (default task-26)

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

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 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 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 oraclecommunity
via Oracle Community by 32f12df2-4334-407e-892f-a534b1ec7839, 1 year ago
, IsPublicRedordEnmrolled,IdLawyerVobo,ApplicationDate,IdUserDictamenVoBo, IdUserProjectReviewVoBo,IdUserSignVoBo,IdFlow,IsStandarized,DateFirstProject FROM REQUISITIONOWNERS WHERE IdRequisitionOwners =? ]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

Solution icon of spring
via Spring JIRA by Rafael Winterhalter, 1 year ago
PreparedStatementCallback; bad SQL grammar [This is not valid SQL]; nested exception is java.sql.SQLException: ORA-00900: invalid SQL statement

Solution icon of spring
via Spring JIRA by Rafael Winterhalter, 1 year ago
PreparedStatementCallback; bad SQL grammar [This is not valid SQL]; nested exception is java.sql.SQLException: ORA-00900: invalid SQL statement

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

Stack trace

  • org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended 12:32:49,105 ERROR [stderr] (default task-26) at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:91) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:645) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:900) at com.caja.creditprocess.daoimpl.AdminComponentDAOImpl.saveParentComponentDetails(AdminComponentDAOImpl.java:55) at com.caja.creditprocess.adminmanager.AdminComponentEjb.saveComponentDetails(AdminComponentEjb.java:41) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498)

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

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago