You are viewing a plain text version of this content. The canonical link for it is here.
Posted to slide-dev@jakarta.apache.org by oz...@apache.org on 2004/06/07 13:29:13 UTC

cvs commit: jakarta-slide/src/stores/org/apache/slide/store/impl/rdbms StandardRDBMSAdapter.java

ozeigermann    2004/06/07 04:29:13

  Modified:    src/stores/org/apache/slide/store/impl/rdbms
                        StandardRDBMSAdapter.java
  Log:
  Fix for bug #29359 only tested with SQL server and Sybase
  
  Revision  Changes    Path
  1.25      +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.24
  retrieving revision 1.25
  diff -u -r1.24 -r1.25
  --- StandardRDBMSAdapter.java	17 May 2004 07:34:38 -0000	1.24
  +++ StandardRDBMSAdapter.java	7 Jun 2004 11:29:13 -0000	1.25
  @@ -893,7 +893,7 @@
               try {
                   statement =
                       connection.prepareStatement(
  -                    "select vh.REVISION_NO, b.BRANCH_STRING from VERSION_HISTORY vh, BRANCH b, URI u where vh.BRANCH_ID = b.BRANCH_ID and vh.URI_ID = u.URI_ID and u.URI_STRING = ? order by vh.REVISION_NO ");
  +                    "select vh.REVISION_NO, b.BRANCH_STRING from VERSION_HISTORY vh, BRANCH b, URI u where vh.BRANCH_ID = b.BRANCH_ID and vh.URI_ID = u.URI_ID and u.URI_STRING = ? order by convert(numeric, vh.REVISION_NO)");
                   statement.setString(1, uri.toString());
                   res = statement.executeQuery();
                   while (res.next()) {
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: slide-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-dev-help@jakarta.apache.org