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

1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1102       return;     }     if (activation != null) {       ResultSet rs = activation.getResultSet();       if (rs instanceof BasicNoPutResultSetImpl) {         ((BasicNoPutResultSetImpl) rs).addWarning(w);       }     }

View Full Code Here

2068 2069 2070 2071 2072 2073 2074 2075 2076     PreparedStatement ps = lcc.prepareInternalStatement(updateStmt);         // 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(lcc, true, 0L);     rs.close();     rs.finish(); }

View Full Code Here

2090 2091 2092 2093 2094 2095 2096 2097 2098 2099 2100 2101     LanguageConnectionContext lcc = activation.getLanguageConnectionContext();     PreparedStatement ps = lcc.prepareInternalStatement(maxStmt);         // This is a substatement, for now we do not set any timeout for it         // We might change this later by linking timeout to parent statement     ResultSet rs = ps.execute(lcc, false, 0L);     DataValueDescriptor[] rowArray = rs.getNextRow().getRowArray();     rs.close();     rs.finish();     return rowArray[0].getLong(); }

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

1584 1585 1586 1587 1588 1589 1590 1591 1592 1593 1594 1595 1596 1597 1598 1599 1600 1601 1602 1603 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       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.elementAt(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

1672 1673 1674 1675 1676 1677 1678 1679 1680 1681 1682 1683 1684 1685 1686 1687 1688 1689 1690 1691 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         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.elementAt(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

303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354     checkStmt.append(td.getQualifiedName());     checkStmt.append(" WHERE NOT(");     checkStmt.append(constraintText);     checkStmt.append(")");     ResultSet rs = null;     try     {       PreparedStatement ps = lcc.prepareInternalStatement(checkStmt.toString());             // 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.       rs = ps.execute(lcc, false, 0L);       ExecRow row = rs.getNextRow();       if (SanityManager.DEBUG)       {         if (row == null)         {           SanityManager.THROWASSERT("did not get any rows back from query: "+checkStmt.toString());         }       }       DataValueDescriptor[] rowArray = row.getRowArray();       Number value = ((Number)((NumberDataValue)row.getRowArray()[0]).getObject());       /*       ** Value may be null if there are no rows in the       ** table.       */       if ((value != null) && (value.longValue() != 0))       {         //check constraint violated         if (isCheckConstraint)           throw StandardException.newException(SQLState.LANG_ADD_CHECK_CONSTRAINT_FAILED,             constraintName, td.getQualifiedName(), value.toString());         /*          * for not null constraint violations exception will be thrown in caller          * check constraint will not get here since exception is thrown          * above          */         return false;       }     }     finally     {       if (rs != null)       {         rs.close();       }     }     return true; }

View Full Code Here

348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383       if (executionConstants != null)       {         lccToUse.validateStmtExecution(executionConstants);       }       ResultSet resultSet = null;       try {         resultSet = activation.execute();         resultSet.open();       } catch (StandardException se) {         /* Cann't handle recompiling SPS action recompile here */         if (!se.getMessageId().equals(SQLState.LANG_STATEMENT_NEEDS_RECOMPILE)              || spsAction)           throw se;         statementContext.cleanupOnError(se);         continue recompileOutOfDatePlan;       }       if (needToClearSavePoint)       {         /* We're done with our updates */         statementContext.clearSavePoint();       }       lccToUse.popStatementContext(statementContext, null);                if (activation.isSingleExecution() && resultSet.isClosed())       {         // if the result set is 'done', i.e. not openable,         // then we can also release the activation.         // Note that a result set with output parameters         // or rows to return is explicitly finished

View Full Code Here

816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831         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

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 1657 1658 1659 1660 1661 1662 1663       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

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.