This forum is now a read-only archive. All commenting, posting, registration services have been turned off. Those needing community support and/or wanting to ask questions should refer to the Tag/Forum map, and to http://spring.io/questions for a curated list of stackoverflow tags that Pivotal engineers, and the community, monitor.

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [update acl_object_identity set parent_object = ?, owner_sid = ?, entries_inheriting = ? where id = ?]; An attempt was made to get a data value of type '<UNKNOWN>' from a data value of type 'BIGINT'.; nested exception is java.sql.SQLDataException: An attempt was made to get a data value of type '<UNKNOWN>' from a data value of type 'BIGINT'.

I suspect the problem is with how the identity queries are being defined for the ACL service bean. The book was written to use an older version of Spring Security, as it defined an 'identityQuery' for the JdbcMutableAclService. I'm using Spring Security 2.0.6, which does not define such a property, rather it has the properties 'classIdentityQuery' and 'sidIdentityQuery'.

Can someone familiar with configuring ACL services with Apache Derby shed some light on the cause of my problem?