Examples of org.apache.derby.iapi.sql.ResultSet.returnsRows()

Class org.apache.derby.iapi.sql.ResultSet

Examples of org.apache.derby.iapi.sql.ResultSet.returnsRows()

org.apache.derby.iapi.sql.ResultSet.returnsRows()
Returns TRUE if the statement returns rows (i.e. is a SELECT or FETCH statement), FALSE if it returns no rows. @return TRUE if the statement returns rows, FALSE if not.

                ResultSet rs = a.getResultSet();


                /* is there an open result set? */
                if (rs != null && ! rs.isClosed())
                {
                    if (!rs.returnsRows())
                        continue;
                    seenOpenResultSets = true;
                    break;
                }

View Full Code Here

                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

            //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

View Full Code Here

      }


      ResultSet rs = ((CursorActivation) a).getResultSet();


      /* is there an open result set? */
      if ((rs != null) && !rs.isClosed() && rs.returnsRows())
      {
        seenOpenResultSets = true;
        break;
      }
    }

View Full Code Here

      }


      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

        ResultSet rs = a.getResultSet();


        /* is there an open result set? */
        if (rs != null && ! rs.isClosed())
        {
          if (!rs.returnsRows())
            continue;
          seenOpenResultSets = true;
          break;
        }

View Full Code Here

        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

      //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

View Full Code Here

                ResultSet resultsToWrap = ps.execute(a, timeoutMillis);
                addWarning(ps.getCompileTimeWarnings());
        addWarning(a.getWarnings());




        if (resultsToWrap.returnsRows()) {


                    // The statement returns rows, so calling it with
                    // executeUpdate() is not allowed.
                    if (executeUpdate) {
                        throw StandardException.newException(

View Full Code Here

                // 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.executeSubStatement
          (activation, 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()

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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.