JdbcDaoImpl object properties query throws exception

[dreed]

Hi:

I discovered what I think may be a typo in net.sf.acegisecurity.acl.basic.jdbc.JdbcDaoImpl. The default value for the object properties query is as follows:

public static final String DEF_OBJECT_PROPERTIES_QUERY = "SELECT CHILD.ID, CHILD.OBJECT_IDENTITY, CHILD.ACL_CLASS, PARENT.OBJECT_IDENTITY as PARENT_OBJECT_IDENTITY FROM acl_object_identity as CHILD LEFT OUTER JOIN acl_object_identity as PARENT ON CHILD.parent_object=parent.id WHERE CHILD.object_identity = ?";

Using MySQL 4 an SQL exception is thrown saying that the table parent doesn't exist. I got it to work by extending the class, overriding the object properties query string and changing parent.id to PARENT.id.

The new query looks like this:

public static final String DEF_OBJECT_PROPERTIES_QUERY = "SELECT CHILD.ID, CHILD.OBJECT_IDENTITY, CHILD.ACL_CLASS, PARENT.OBJECT_IDENTITY as PARENT_OBJECT_IDENTITY FROM acl_object_identity as CHILD LEFT OUTER JOIN acl_object_identity as PARENT ON CHILD.parent_object=PARENT.id WHERE CHILD.object_identity = ?";

Is JIRA a more appropriate place for this type of post?

Thanks for the great work on Acegi

Dave

[Ben Alex]

Dave, thanks for the feedback. That bug had previously been identified and fixed. We'll be setting up some issue tracking via JIRA soon.