ozeigermann 2004/03/24 03:07:32
Modified: src/stores/org/apache/slide/store/impl/rdbms
StandardRDBMSAdapter.java
Log:
Corrected patch by Christophe Lombart to use upper case table and row names needed
by SQL server.
Revision Changes Path
1.22 +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.21
retrieving revision 1.22
diff -u -r1.21 -r1.22
--- StandardRDBMSAdapter.java 23 Mar 2004 14:07:41 -0000 1.21
+++ StandardRDBMSAdapter.java 24 Mar 2004 11:07:32 -0000 1.22
@@ -1015,13 +1015,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]
