Examples of org.apache.derby.iapi.sql.ResultSet

org.apache.derby.iapi.sql.ResultSet
The ResultSet interface provides a method to tell whether a statement returns rows, and if so, a method to get the rows. It also provides a method to get metadata about the contents of the rows. It also provide a method to accept rows as input.
There is no single implementation of the ResultSet interface. Instead, the various support operations involved in executing statements implement this interface.
Although ExecRow is used on the interface, it is not available to users of the API. They should use Row, the exposed super-interface of ExecRow. <>
Valid transitions:
@author Jeff Lichtman

168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189       try       {                 // This is a substatement; for now, we do not set any timeout                 // for it. We might change this behaviour later, by linking                 // timeout to its parent statement's timeout settings.                 ResultSet rs = ps.execute(spsActivation, false, 0L);                 if( rs.returnsRows())                 {                     // Fetch all the data to ensure that functions in the select list or values statement will                     // be evaluated and side effects will happen. Why else would the trigger action return                     // rows, but for side effects?                     // The result set was opened in ps.execute()                     while( rs.getNextRow() != null)                     {                     }                 }                 rs.close();       }       catch (StandardException e)       {         /*         ** When a trigger SPS action is executed and results in

View Full Code Here

1198 1199 1200 1201 1202 1203 1204 1205 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216 1217 1218 1219 1220 1221 1222 1223 1224 1225 1226 1227 1228 1229 1230 1231 1232 1233 1234 1235 1236 1237 1238 1239 1240 1241 1242 1243 1244 1245 1246 1247 1248 1249 1250 1251 1252 1253 1254 1255 1256 1257 1258 1259         //reset the activation to clear warnings         //and clear existing result sets in case this has been cached         a.reset();         a.setMaxRows(maxRows);                 ResultSet resultsToWrap = ps.execute(a,                                                      false,                                                      timeoutMillis);         addWarning(a.getWarnings());         if (resultsToWrap.returnsRows()) {                     // The statement returns rows, so calling it with                     // executeUpdate() is not allowed.                     if (executeUpdate) {                         throw StandardException.newException(                                 SQLState.LANG_INVALID_CALL_TO_EXECUTE_UPDATE);                     }           EmbedResultSet lresults = factory.newEmbedResultSet(getEmbedConnection(), resultsToWrap, forMetaData, this, ps.isAtomic());           results = lresults;           // Set up the finalization of the ResultSet to           // mark the activation as unused. It will be           // closed sometime later by the connection           // outside of finalization.           if (a.isSingleExecution())             lresults.singleUseActivation = a;           updateCount = -1;           retval = true;         }         else {           // Only applipable for an insert statement, which does not return rows.           //the auto-generated keys resultset will be null if used for non-insert statement           if (a.getAutoGeneratedKeysResultsetMode() && (resultsToWrap.getAutoGeneratedKeysResultset() != null))           {             resultsToWrap.getAutoGeneratedKeysResultset().open();             autoGeneratedKeysResultSet = factory.newEmbedResultSet(getEmbedConnection(),               resultsToWrap.getAutoGeneratedKeysResultset(), false, this, ps.isAtomic());           }           updateCount = resultsToWrap.modifiedRowCount();           results = null; // note that we have none.                     int dynamicResultCount = 0;           if (a.getDynamicResults() != null) {                         dynamicResultCount =                             processDynamicResults(a.getDynamicResults(),                                                   a.getMaxDynamicResults());           }                                         resultsToWrap.close(); // Don't need the result set any more                     // executeQuery() is not allowed if the statement                     // doesn't return exactly one ResultSet.                     if (executeQuery && dynamicResultCount != 1) {                         throw StandardException.newException(

View Full Code Here

809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824         String executingCursorName = a.getCursorName();          if (cursorName.equals(executingCursorName)) {           ResultSet rs = a.getResultSet();           if (rs == null)             continue;            // if the result set is closed, the the cursor doesn't exist            if (rs.isClosed()) {                      continue;            }            return (CursorActivation)a;          }

View Full Code Here

1604 1605 1606 1607 1608 1609 1610 1611 1612 1613 1614 1615 1616 1617 1618 1619 1620 1621 1622 1623 1624 1625 1626 1627 1628 1629 1630 1631 1632 1633 1634 1635 1636 1637 1638 1639 1640 1641 1642 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656       if (!a.getResultSetHoldability())       {         continue;       }       ResultSet rs = ((CursorActivation) a).getResultSet();       /* is there an open result set? */       if ((rs != null) && !rs.isClosed() && rs.returnsRows())       {         seenOpenResultSets = true;         break;       }     }     if (!seenOpenResultSets)       return(true);     // There may be open ResultSet's that are yet to be garbage collected     // let's try and force these out rather than throw an error     System.gc();     System.runFinalization();     /* For every activation */     for (int i = acts.size() - 1; i >= 0; i--) {               Activation a = (Activation) acts.get(i);       if (SanityManager.DEBUG)       {         SanityManager.ASSERT(a instanceof CursorActivation, "a is not a CursorActivation");       }       if (!a.isInUse())       {         continue;       }       if (!a.getResultSetHoldability())       {         continue;       }       ResultSet rs = ((CursorActivation) a).getResultSet();       /* is there an open held result set? */       if ((rs != null) && !rs.isClosed() && rs.returnsRows())       {         return(false);       }     }     return(true);

View Full Code Here

1692 1693 1694 1695 1696 1697 1698 1699 1700 1701 1702 1703 1704 1705 1706 1707 1708 1709 1710 1711 1712 1713 1714 1715 1716 1717 1718 1719 1720 1721 1722 1723 1724 1725 1726 1727 1728 1729 1730 1731 1732 1733 1734 1735 1736 1737 1738 1739 1740 1741 1742 1743 1744         continue;       }             /* for this prepared statement */       if (pStmt == a.getPreparedStatement()) {         ResultSet rs = a.getResultSet();         /* is there an open result set? */         if (rs != null && ! rs.isClosed())         {           if (!rs.returnsRows())             continue;           seenOpenResultSets = true;           break;         }               }     }     if (!seenOpenResultSets)       return false;     // There may be open ResultSet's that are yet to be garbage collected     // let's try and force these out rather than throw an error     System.gc();     System.runFinalization();     /* For every activation */     // synchronize on acts as other threads may be closing activations     // in this list, thus invalidating the Enumeration     for (int i = acts.size() - 1; i >= 0; i--) {               Activation a = (Activation) acts.get(i);       if (!a.isInUse())       {         continue;       }       /* for this prepared statement */       if (pStmt == a.getPreparedStatement()) {         ResultSet rs = a.getResultSet();         /* is there an open result set? */         if (rs != null && ! rs.isClosed())         {           if ((provider != null) && rs.returnsRows()) {           DependencyManager dmgr = getDataDictionary().getDependencyManager();           throw StandardException.newException(SQLState.LANG_CANT_INVALIDATE_OPEN_RESULT_SET,                   dmgr.getActionString(action),                   provider.getObjectName());

View Full Code Here

2738 2739 2740 2741 2742 2743 2744 2745 2746 2747 2748 2749 2750 2751 2752 2753 2754 2755 2756 2757 2758 2759 2760 2761 2762 2763 2764 2765 2766 2767 2768 2769 2770 2771 2772 2773 2774 2775 2776 2777 2778 2779 2780 2781 2782 2783 2784 2785 2786 2787 2788       //Determine if the activation has a resultset and if that resultset       //returns rows. For such an activation, we need to take special       //actions during commit and rollback as explained in the comments       //below.       ResultSet activationResultSet = a.getResultSet();       boolean resultsetReturnsRows =         (activationResultSet != null) && activationResultSet.returnsRows(); ;       if (forRollback) {         if (resultsetReturnsRows)           //Since we are dealing with rollback, we need to reset           //the activation no matter what the holdability might           //be provided that resultset returns rows. An example           //where we do not want to close a resultset that does           //not return rows would be a java procedure which has           //user invoked rollback inside of it. That rollback           //should not reset the activation associated with           //the call to java procedure because that activation           //is still being used.           a.reset();         // Only invalidate statements if we performed DDL.         if (dataDictionaryInWriteMode()) {           ExecPreparedStatement ps = a.getPreparedStatement();           if (ps != null) {             ps.makeInvalid(DependencyManager.ROLLBACK, this);           }         }       } else {         //We are dealing with commit here.         if (resultsetReturnsRows){           if (a.getResultSetHoldability() == false)             //Close result sets that return rows and are not held             //across commit. This is to implement closing JDBC             //result sets that are CLOSE_CURSOR_ON_COMMIT at commit             //time.             activationResultSet.close();           else             //Clear the current row of the result sets that return             //rows and are held across commit. This is to implement             //keeping JDBC result sets open that are             //HOLD_CURSORS_OVER_COMMIT at commit time and marking             //the resultset to be not on a valid row position. The             //user will need to reposition within the resultset             //before doing any row operations.             activationResultSet.clearCurrentRow();                      }         a.clearHeapConglomerateController();       }     } }

View Full Code Here

1184 1185 1186 1187 1188 1189 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199                     continue;                 }                  if (cursorName.equals(executingCursorName)) {                     ResultSet rs = a.getResultSet();                     if (rs == null)                         continue;                      // if the result set is closed, the the cursor doesn't exist                      if (rs.isClosed()) {                                           continue;                      }                     return (CursorActivation)a;                  }

View Full Code Here

1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047             if (!a.getResultSetHoldability())             {                 continue;             }             ResultSet rs = ((CursorActivation) a).getResultSet();             /* is there an open result set? */             if ((rs != null) && !rs.isClosed() && rs.returnsRows())             {                 seenOpenResultSets = true;                 break;             }         }         if (!seenOpenResultSets)             return(true);         // There may be open ResultSet's that are yet to be garbage collected         // let's try and force these out rather than throw an error         System.gc();         System.runFinalization();         /* For every activation */         for (int i = acts.size() - 1; i >= 0; i--) {                             Activation a = (Activation) acts.get(i);             if (SanityManager.DEBUG)             {                 SanityManager.ASSERT(a instanceof CursorActivation, "a is not a CursorActivation");             }             if (!a.isInUse())             {                 continue;             }             if (!a.getResultSetHoldability())             {                 continue;             }             ResultSet rs = ((CursorActivation) a).getResultSet();             /* is there an open held result set? */             if ((rs != null) && !rs.isClosed() && rs.returnsRows())             {                 return(false);             }         }         return(true);

View Full Code Here

2083 2084 2085 2086 2087 2088 2089 2090 2091 2092 2093 2094 2095 2096 2097 2098 2099 2100 2101 2102 2103 2104 2105 2106 2107 2108 2109 2110 2111 2112 2113 2114 2115 2116 2117 2118 2119 2120 2121 2122 2123 2124 2125 2126 2127 2128 2129 2130 2131 2132 2133 2134 2135                 continue;             }                         /* for this prepared statement */             if (pStmt == a.getPreparedStatement()) {                 ResultSet rs = a.getResultSet();                 /* is there an open result set? */                 if (rs != null && ! rs.isClosed())                 {                     if (!rs.returnsRows())                         continue;                     seenOpenResultSets = true;                     break;                 }                             }         }         if (!seenOpenResultSets)             return false;         // There may be open ResultSet's that are yet to be garbage collected         // let's try and force these out rather than throw an error         System.gc();         System.runFinalization();         /* For every activation */         // synchronize on acts as other threads may be closing activations         // in this list, thus invalidating the Enumeration         for (int i = acts.size() - 1; i >= 0; i--) {                             Activation a = (Activation) acts.get(i);             if (!a.isInUse())             {                 continue;             }             /* for this prepared statement */             if (pStmt == a.getPreparedStatement()) {                 ResultSet rs = a.getResultSet();                 /* is there an open result set? */                 if (rs != null && ! rs.isClosed())                 {                     if ((provider != null) && rs.returnsRows()) {                     DependencyManager dmgr = getDataDictionary().getDependencyManager();                     throw StandardException.newException(SQLState.LANG_CANT_INVALIDATE_OPEN_RESULT_SET,                                     dmgr.getActionString(action),                                     provider.getObjectName());

View Full Code Here

3211 3212 3213 3214 3215 3216 3217 3218 3219 3220 3221 3222 3223 3224 3225 3226 3227 3228 3229 3230 3231 3232 3233 3234 3235 3236 3237 3238 3239 3240 3241 3242 3243 3244 3245 3246 3247 3248 3249 3250 3251 3252 3253 3254 3255 3256 3257 3258 3259 3260 3261             //Determine if the activation has a resultset and if that resultset             //returns rows. For such an activation, we need to take special             //actions during commit and rollback as explained in the comments             //below.             ResultSet activationResultSet = a.getResultSet();             boolean resultsetReturnsRows =                 (activationResultSet != null) && activationResultSet.returnsRows(); ;             if (forRollback) {                 if (resultsetReturnsRows)                     //Since we are dealing with rollback, we need to reset                     //the activation no matter what the holdability might                     //be provided that resultset returns rows. An example                     //where we do not want to close a resultset that does                     //not return rows would be a java procedure which has                     //user invoked rollback inside of it. That rollback                     //should not reset the activation associated with                     //the call to java procedure because that activation                     //is still being used.                     a.reset();                 // Only invalidate statements if we performed DDL.                 if (dataDictionaryInWriteMode()) {                     ExecPreparedStatement ps = a.getPreparedStatement();                     if (ps != null) {                         ps.makeInvalid(DependencyManager.ROLLBACK, this);                     }                 }             } else {                 //We are dealing with commit here.                 if (resultsetReturnsRows){                     if (a.getResultSetHoldability() == false)                         //Close result sets that return rows and are not held                         //across commit. This is to implement closing JDBC                         //result sets that are CLOSE_CURSOR_ON_COMMIT at commit                         //time.                         activationResultSet.close();                     else                         //Clear the current row of the result sets that return                         //rows and are held across commit. This is to implement                         //keeping JDBC result sets open that are                         //HOLD_CURSORS_OVER_COMMIT at commit time and marking                         //the resultset to be not on a valid row position. The                         //user will need to reposition within the resultset                         //before doing any row operations.                         activationResultSet.clearCurrentRow();                                          }                 a.clearHeapConglomerateController();             }         }     }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.derby.iapi.sql.ResultSet

org.apache.derby.impl.jdbc.EmbedStatement

org.apache.derby.impl.sql.compile.ExecSPSNode

org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext

org.apache.derby.impl.sql.execute.AlterTableConstantAction

org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl

org.apache.derby.impl.sql.execute.ConstraintConstantAction

org.apache.derby.impl.sql.execute.GenericSPSConstantAction

org.apache.derby.impl.sql.execute.GenericTriggerExecutor

org.apache.derby.impl.sql.GenericPreparedStatement

Copyright © 2018 www.massapicom. All rights reserved.

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.