SEC-43: JdbcExtendedDaoImpl doesn't work with Postgres about spring-security

[spring-projects-issues]

Stein Martin Hustad said:

Attached patch that updates the aclObjectIdentityInsertStatement and aclPermissionInsertStatement so that they do not reference the primary key columns, and removed the primary key parameter declarations from the AclObjectIdentityInsertStatement and AclPermissionInsertStatement. This way, if some database should require a null to be inserted to trigger the generation of the id, one can obtain exactly the same behaviour as before by injecting the following two sql statements for the JdbcExtendedDaoImpl bean:

aclObjectIdentityInsertStatement:
“INSERT INTO acl_object_identity (id, object_identity, parent_object, acl_class) VALUES (null, ?, ?, ?)”;
aclPermissionInsertStatement:
“INSERT INTO acl_permission (id, acl_object_identity, recipient, mask) VALUES (null, ?, ?, ?)”;

[spring-projects-issues]

Ben Alex said:

Patch applied, unit tests all pass.