CursorResultSet


1   /*
2    * $Id: CursorResultSet.java 5462 2005-08-05 18:35:48Z jonesde $
3    *
4    * Copyright (c) 2001-2005 The Open For Business Project - www.ofbiz.org
5    *
6    * Permission is hereby granted, free of charge, to any person obtaining a
7    * copy of this software and associated documentation files (the "Software"),
8    * to deal in the Software without restriction, including without limitation
9    * the rights to use, copy, modify, merge, publish, distribute, sublicense,
10   * and/or sell copies of the Software, and to permit persons to whom the
11   * Software is furnished to do so, subject to the following conditions:
12   *
13   * The above copyright notice and this permission notice shall be included
14   * in all copies or substantial portions of the Software.
15   *
16   * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS
17   * OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
18   * MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
19   * IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY
20   * CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT
21   * OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR
22   * THE USE OR OTHER DEALINGS IN THE SOFTWARE.
23   */
24  package org.ofbiz.entity.jdbc;
25  
26  import java.lang.reflect.Method  ;
27  import java.sql.ResultSet  ;
28  import java.sql.SQLException  ;
29  import java.sql.Statement  ;
30  
31  /**
32   *
33   * @version    $Rev: 5462 $
34   * @since      3.1
35   */
36  public class CursorResultSet extends AbstractCursorHandler {
37  
38      protected ResultSet   rs;
39      protected Statement   stmt;
40      protected String   query;
41  
42      protected CursorResultSet(Statement   stmt, String   cursorName, int fetchSize) throws SQLException   {
43          super(cursorName, fetchSize);
44          this.stmt = stmt;
45          query = "FETCH FORWARD " + fetchSize + " IN " + cursorName;
46          System.err.println("executing page fetch(1)");
47          rs = stmt.executeQuery(query);
48      }
49  
50      public Object   invoke(Object   proxy, Method   method, Object  [] args) throws Throwable   {
51          if ("close".equals(method.getName())) {
52              close();
53              return null;
54          } else if ("next".equals(method.getName())) {
55              return next() ? Boolean.TRUE : Boolean.FALSE;
56          }
57          return super.invoke(rs, proxy, method, args);
58      }
59  
60      protected boolean next() throws SQLException   {
61          if (rs.next()) return true;
62          System.err.println("executing page fetch(2)");
63          rs = stmt.executeQuery(query);
64          return rs.next();
65      }
66  
67      protected void close() throws SQLException   {
68          stmt.executeUpdate("CLOSE " + cursorName);
69          rs.close();
70      }
71  
72      public static ResultSet   newCursorResultSet(Statement   stmt, String   cursorName, int fetchSize) throws SQLException  , Exception   {
73          return (ResultSet  ) newHandler(new CursorResultSet(stmt, cursorName, fetchSize), ResultSet  .class);
74      }
75  }
76
A to Z: JavaDoc & Examples Daily Java News & Articles Open Source Projects Open Source Codes Free Computer Books Remove Frame
Popular Tags