[Wonder-cvs] SF.net SVN: wonder:[10797] trunk/Wonder/Frameworks/Core/ERExtensions/ Sources/er/extensions/jdbc/ERXSQLHelper.java

[<ld...@us...>]

Revision: 10797
          http://wonder.svn.sourceforge.net/wonder/?rev=10797&view=rev
Author:   ldeck
Date:     2010-04-26 00:08:15 +0000 (Mon, 26 Apr 2010)

Log Message:
-----------
[WONDER-519] adding Pascal Robert's patch to add the limit expression support for h2.

Modified Paths:
--------------
    trunk/Wonder/Frameworks/Core/ERExtensions/Sources/er/extensions/jdbc/ERXSQLHelper.java

Modified: trunk/Wonder/Frameworks/Core/ERExtensions/Sources/er/extensions/jdbc/ERXSQLHelper.java
===================================================================
--- trunk/Wonder/Frameworks/Core/ERExtensions/Sources/er/extensions/jdbc/ERXSQLHelper.java	2010-04-23 22:49:49 UTC (rev 10796)
+++ trunk/Wonder/Frameworks/Core/ERExtensions/Sources/er/extensions/jdbc/ERXSQLHelper.java	2010-04-26 00:08:15 UTC (rev 10797)
@@ -1808,6 +1808,11 @@
 	public static class H2SQLHelper extends ERXSQLHelper {
 		
 		@Override
+		public String limitExpressionForSQL(EOSQLExpression expression, EOFetchSpecification fetchSpecification, String sql, long start, long end) {
+			return sql + " LIMIT " + (end - start) + " OFFSET " + start;
+		}
+		
+		@Override
 		public String sqlForCreateUniqueIndex(String indexName, String tableName, ColumnIndex... columnIndexes) {
 			NSMutableArray<String> columnNames = columnNamesFromColumnIndexes(columnIndexes);
 			return "ALTER TABLE " + tableName + " ADD CONSTRAINT \"" + indexName + "\" UNIQUE(" + new NSArray<String>(columnNames).componentsJoinedByString(", ") + ")";


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.