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.

                    if (SanityManager.DEBUG) {
                        SanityManager.ASSERT(rs.getNextRow() == null,
                                "WHEN clause returned more than one row");
                    }
                }
                else 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

                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

            }


            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

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

            }


            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

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.