[mptstore-codewatch] SF.net SVN: mptstore: [112] trunk/src/java/org/nsdl/mptstore/query/ SQLUnionQueryResults.java

[<bir...@us...>]

Revision: 112
          http://mptstore.svn.sourceforge.net/mptstore/?rev=112&view=rev
Author:   birkland
Date:     2007-10-15 09:59:41 -0700 (Mon, 15 Oct 2007)

Log Message:
-----------
Set fetch direction explicitly to forward direction, which could allow certain result fetching optimizations from the JDBC driver.

Modified Paths:
--------------
    trunk/src/java/org/nsdl/mptstore/query/SQLUnionQueryResults.java

Modified: trunk/src/java/org/nsdl/mptstore/query/SQLUnionQueryResults.java
===================================================================
--- trunk/src/java/org/nsdl/mptstore/query/SQLUnionQueryResults.java	2007-08-13 15:07:34 UTC (rev 111)
+++ trunk/src/java/org/nsdl/mptstore/query/SQLUnionQueryResults.java	2007-10-15 16:59:41 UTC (rev 112)
@@ -176,6 +176,7 @@
             }
             _statement = _conn.createStatement();
             _statement.setFetchSize(_fetchSize);
+            _statement.setFetchDirection(ResultSet.FETCH_FORWARD);
             String query = _queries.next();
             LOG.info("Executing query:\n" + query);
             _results = _statement.executeQuery(query);


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