masonjm     2004/11/29 23:08:36

  Modified:    src/stores/org/apache/slide/store/impl/rdbms Tag:
                        SLIDE_2_1_RELEASE_BRANCH StandardRDBMSAdapter.java
  Log:
  Fix for bug 32072, submitted by Warwick Burrows
  
  Revision  Changes    Path
  No                   revision
  No                   revision
  1.32.2.4  +5 -5      
jakarta-slide/src/stores/org/apache/slide/store/impl/rdbms/StandardRDBMSAdapter.java
  
  Index: StandardRDBMSAdapter.java
  ===================================================================
  RCS file: 
/home/cvs/jakarta-slide/src/stores/org/apache/slide/store/impl/rdbms/StandardRDBMSAdapter.java,v
  retrieving revision 1.32.2.3
  retrieving revision 1.32.2.4
  diff -u -r1.32.2.3 -r1.32.2.4
  --- StandardRDBMSAdapter.java 10 Nov 2004 22:09:12 -0000      1.32.2.3
  +++ StandardRDBMSAdapter.java 30 Nov 2004 07:08:36 -0000      1.32.2.4
  @@ -916,7 +916,7 @@
                   try {
                       statement =
                           connection.prepareStatement(
  -                            "select pvh.REVISION_NO from VERSION_HISTORY vh, 
VERSION_HISTORY pvh, VERSION_PREDS vp, URI u where pvh.VERSION_ID = 
vp.VERSION_ID and vp.VERSION_ID = vh.VERSION_ID and vh.URI_ID = u.URI_ID and 
u.URI_STRING = ? and vh.REVISION_NO = ?");
  +                            "select distinct pvh.REVISION_NO from 
VERSION_HISTORY vh, VERSION_HISTORY pvh, VERSION_PREDS vp, URI u where 
pvh.VERSION_ID = vp.VERSION_ID and vp.VERSION_ID = vh.VERSION_ID and vh.URI_ID 
= u.URI_ID and u.URI_STRING = ? and vh.REVISION_NO = ?");
                       statement.setString(1, uri.toString());
                       statement.setString(2, revisionNumber.toString());
                       res = statement.executeQuery();
  
  
  

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

Reply via email to