Spring SecurityAcl对象

Question

@Autowired
JdbcMutableAclService aclService;

public void createAcl(AclDTO aclDTO) throws ClassNotFoundException {

    ObjectIdentity oi = new ObjectIdentityImpl(getClass().getClassLoader().loadClass(aclDTO.getClassPath()),
        aclDTO.getObjectIdentityId());
    Sid sid = new PrincipalSid(aclDTO.getSid());

    Permission p = getPermission(aclDTO.getPermissionDesc());

    // Create or update the relevant ACL
    MutableAcl acl = null;
    try {
        acl = (MutableAcl) this.aclService.readAclById(oi);
    } catch (NotFoundException nfe) {
        acl = aclService.createAcl(oi);
    }

    // Now grant some permissions via an access control entry (ACE)
    acl.insertAce(acl.getEntries().size(), p, sid, true);
    this.aclService.updateAcl(acl);
}

2019-02-25 11:02:18.410错误10608--[XNIO-2任务-1]c.ss.acl.aop.logging.loggingAspect：com.spring.security.acl.service.AccessGrantService.CreateACL（）中出现异常，原因=“com.mysql.jdbc.exceptions.jdbc4.mysqlsyntaxerrorexception：过程security_acl.identity不存在”，异常=“StatementCallback；错误的SQL语法[call identity()]；嵌套异常为com.mysql.jdbc.exceptions.jdbc4.mysqlSyntaxerRoreXception：过程security_acl.identity不存在‘

如果有人能帮我处理这件事，我会很感激的！

Answer 1

看来你在使用MySQL。

我遇到了相同的错误,并通过如下方式设置JdbcMutableAclService来解决该错误：

// Based on https://github.com/eugenp/tutorials/blob/master/spring-security-acl/src/main/java/org/baeldung/acl/config/ACLContext.java
@Bean
public JdbcMutableAclService aclService() {
  JdbcMutableAclService jdbcMutableAclService = new JdbcMutableAclService(dataSource, lookupStrategy(), aclCache());

  // TODO: for MySQL ONLY
  jdbcMutableAclService.setClassIdentityQuery("SELECT @@IDENTITY");
  jdbcMutableAclService.setSidIdentityQuery("SELECT @@IDENTITY");

  return jdbcMutableAclService;
}

希望能有所帮助。