ozeigermann 2004/03/24 02:51:11
Modified: src/stores/org/apache/slide/store/impl/rdbms Tag:
SLIDE_2_0_RELEASE_BRANCH StandardRDBMSAdapter.java
Log:
Corrected patch by Christophe Lombart to use upper case table and row names needed
by SQL server.
Revision Changes Path
No revision
No revision
1.14.2.7 +11 -11
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.14.2.6
retrieving revision 1.14.2.7
diff -u -r1.14.2.6 -r1.14.2.7
--- StandardRDBMSAdapter.java 23 Mar 2004 14:04:13 -0000 1.14.2.6
+++ StandardRDBMSAdapter.java 24 Mar 2004 10:51:11 -0000 1.14.2.7
@@ -1016,13 +1016,13 @@
statement =
connection.prepareStatement(
"insert into VERSION_PREDS (VERSION_ID,
PREDECESSOR_ID) " +
- " select vr.version_id , suc.version_id" +
- " FROM uri, version_history vr,
version_history suc " +
- " where vr.uri_id = uri.uri_id " +
- " and suc.uri_id = uri.uri_id " +
- " and uri_string = ? " +
- " and vr.revision_no = ? " +
- " and suc.revision_no = ? " );
+ " select vr.VERSION_ID, suc.VERSION_ID" +
+ " FROM URI uri, VERSION_HISTORY vr,
VERSION_HISTORY suc " +
+ " where vr.URI_ID = uri.URI_ID " +
+ " and suc.URI_ID = uri.URI_ID " +
+ " and uri.URI_STRING = ? " +
+ " and vr.REVISION_NO = ? " +
+ " and suc.REVISION_NO = ? " );
statement.setString(1, uri.toString());
statement.setString(2, nodeRevisionNumber.toString());
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
