unico       2004/10/30 09:02:30

  Modified:    src/stores/org/apache/slide/store/impl/rdbms Tag:
                        SLIDE_2_1_RELEASE_BRANCH CommonRDBMSAdapter.java
  Log:
  fix Bugzilla Bug 31820
  
  Revision  Changes    Path
  No                   revision
  No                   revision
  1.4.2.3   +4 -5      
jakarta-slide/src/stores/org/apache/slide/store/impl/rdbms/CommonRDBMSAdapter.java
  
  Index: CommonRDBMSAdapter.java
  ===================================================================
  RCS file: 
/home/cvs/jakarta-slide/src/stores/org/apache/slide/store/impl/rdbms/CommonRDBMSAdapter.java,v
  retrieving revision 1.4.2.2
  retrieving revision 1.4.2.3
  diff -u -r1.4.2.2 -r1.4.2.3
  --- CommonRDBMSAdapter.java   5 Oct 2004 20:56:09 -0000       1.4.2.2
  +++ CommonRDBMSAdapter.java   30 Oct 2004 16:02:30 -0000      1.4.2.3
  @@ -228,11 +228,10 @@
               NodeRevisionNumber revisionNumber = permission.getRevisionNumber();
               statement =
                   connection.prepareStatement(
  -                    "delete from PERMISSIONS where PERMISSIONS.OBJECT_ID in (select 
ou.URI_ID from URI ou, URI su, URI au where ou.URI_STRING = ? and SUBJECT_ID = 
su.URI_ID and su.URI_STRING = ? and ACTION_ID = au.URI_ID and au.URI_STRING = ? and 
VERSION_NO = ?)");
  +                    "delete from PERMISSIONS where PERMISSIONS.OBJECT_ID in (select 
ou.URI_ID from URI ou, URI su, URI au where ou.URI_STRING = ? and SUBJECT_ID = 
su.URI_ID and su.URI_STRING = ? and ACTION_ID = au.URI_ID and au.URI_STRING = ? and 
VERSION_NO" + ((revisionNumber == null) ? " IS NULL " : " = '" + 
revisionNumber.toString() + "'"));
               statement.setString(1, permission.getObjectUri());
               statement.setString(2, permission.getSubjectUri());
               statement.setString(3, permission.getActionUri());
  -            statement.setString(4, revisionNumber.toString());
               statement.executeUpdate();
           } catch (SQLException e) {
               throw createException(e, uri.toString());
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to