org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [insert into acl_object_identity (object_id_class, object_id_identity, owner_sid, entries_inheriting) values (?, ?, ?, ?)]; nested exception is org.postgresql.util.PSQLException: ERROR: column "object_id_identity" is of type bigint but expression is of type character varying Hint: You will need to rewrite or cast the expression. Position: 51

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 GitHub by spring-issuemaster
, 1 year ago
"object_id_identity" is of type bigint but expression is of type character varying Hint: You will need to rewrite or cast the expression. Position: 51
via Spring JIRA by Adam Dyga, 1 year ago
via Spring JIRA by Adam Dyga, 1 year ago
via Stack Overflow by user962206
, 2 years ago
PreparedStatementCallback; bad SQL grammar [INSERT INTO PERSON (empID,password) VALUES(?,?)]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'empID' in 'field list'
via Oracle Community by 807589, 1 year ago
StatementCallback; bad SQL grammar [select * from QRTZ_BLOB_TRIGGERS]; nested exception is java.sql.SQLException: Invalid object name 'QRTZ_BLOB_TRIGGERS'.. org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select * from QRTZ_BLOB_TRIGGERS]; nested exception is java.sql.SQLException: Invalid object name 'QRTZ_BLOB_TRIGGERS'.
via labkey.org by Unknown author, 1 year ago
ExecutingSelector; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: relation "bogustable" does not exist   Position: 1871
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [insert into acl_object_identity (object_id_class, object_id_identity, owner_sid, entries_inheriting) values (?, ?, ?, ?)]; nested exception is org.postgresql.util.PSQLException: ERROR: column "object_id_identity" is of type bigint but expression is of type character varying Hint: You will need to rewrite or cast the expression. Position: 51
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:276)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:792)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:850)
at org.springframework.security.acls.jdbc.JdbcMutableAclService.createObjectIdentity(JdbcMutableAclService.java:157)

Users with the same issue

2 times, 1 month ago

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