Examples of org.apache.derby.iapi.sql.PreparedStatement.execute()

Class org.apache.derby.iapi.sql.PreparedStatement

Examples of org.apache.derby.iapi.sql.PreparedStatement.execute()

org.apache.derby.iapi.sql.PreparedStatement.execute()
Execute the PreparedStatement and return results.
There is no executeQuery() or executeUpdate(); a method is provided in ResultSet to tell whether to expect rows to be returned. @param activation The activation containing all the local stateto execute the plan. @param rollbackParentContext True if 1) the statement context isNOT a top-level context, AND 2) in the event of a statement-level exception, the parent context needs to be rolled back, too. @param timeoutMillis timeout value in milliseconds. @return A ResultSet for a statement. A ResultSet representsthe results returned from the statement, if any. Will return NULL if the plan for the PreparedStatement has aged out of cache, or the plan is out of date. @exception StandardException Thrown on failure


        //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());

View Full Code Here

    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();
  }


  /**
   * computes the minimum/maximum value in a column of a table.

View Full Code Here

    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

        //reset the activation to clear warnings
        //and clear existing result sets in case this has been cached
        a.reset();
        a.setMaxRows(maxRows);
                long timeoutMillis = (long)timeoutSeconds * 1000L;
                ResultSet resultsToWrap = ps.execute(a,
                                                     false,
                                                     timeoutMillis);
        addWarning(a.getWarnings());

View Full Code Here

    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

    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

      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)
        {

View Full Code Here

    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

    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


        //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, timeoutMillis);
                addWarning(ps.getCompileTimeWarnings());
        addWarning(a.getWarnings());




        if (resultsToWrap.returnsRows()) {

View Full Code Here

0 1 2 3

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.