Var George wrote:
2. public void revokePermissions(Connection connection, Uri uri) throws ServiceAccessException method on CommonRDBMSAdaper seems to be redundant but interestingly here the SQL logic different in CommonRDBMSAdaper & StandardRDBMSAdaper (why?).
-- StandardRDMBSAdaper: delete PERMISSIONS from PERMISSIONS, URI u where OBJECT_ID = u.URI_ID and u.URI_STRING = ?");
-- CommonRDBMSAdaper : delete from PERMISSIONS where PERMISSIONS.OBJECT_ID in (select u.URI_ID from URI u where u.URI_STRING = ?
I think these two SQL fragments do exactly the same thing, except that the one in StandardRDMBSAdapter is valid for MySQL and MSSQL (I think) and the one in CommonRDBMSAdapter is valid for PostgreSQL and other databases. I think the latter is SQL99 compatible and so should be in the most generic class.
Carlos
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
