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 web27

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 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 stackoverflow
PreparedStatementCallback; bad SQL grammar [SELECT * from Tablename WHERE id= ?]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected NUMBER got schema.app_id

Solution icon of sourceforge
PreparedStatementCallback; bad SQL grammar [update table_name set val = COALESCE(?, val)]; nested exception is java.sql.SQLSyntaxErrorException: incompatible data types in combination

Solution icon of coderanch
PreparedStatementCallback; bad SQL grammar [insert into people (first_name, last_name) values (?, ?)]; nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: PEOPLE

Solution icon of github
PreparedStatementCallback; bad SQL grammar [INSERT INTO names(name) VALUES (?)]; nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: NAMES

Solution icon of googlegroups
via Google Groups by cesar ricardo guerra arnaiz, 9 months ago
CallableStatementCallback; bad SQL grammar [{call RGUERRA.PKG_SERVICIO_LLAMADAS.SP_OBTENER_SERV_LLAM_TYPE(?, ?, ?, ?)}]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00902: tipo de dato no válido

Solution icon of stackoverflow
PreparedStatementCallback; bad SQL grammar [insert into T_DEVICE_EVENT (ID, DEVICE_ID, LATITUDE, LONGITUDE, MESSAGE, DATE_RECEIVED, RSSI, BATTERY, ALARM, PROCESSED) values (?,?,?,?,?,?,?,?,?,?);]; nested exception is java.sql.SQLSyntaxErrorException: incompatible data type in conversion

Solution icon of jasig
via Apereo Issues by Eric Dalquist, 1 year ago
= ? AND ss_id = ? AND ss_type = 2 AND param_name = ? ]; nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: UP_SS_USER_PARM

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

2 times, 2 weeks ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago