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




        if (resultsToWrap.returnsRows()) {

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, executeQuery, executeUpdate, false);
        getWarnings(a.getWarnings());




        if (resultsToWrap.returnsRows()) {
          EmbedResultSet lresults = factory.newEmbedResultSet(getEmbedConnection(), resultsToWrap, forMetaData, this, ps.isAtomic());

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

  }


  private static void executeUpdate(LanguageConnectionContext lcc, String updateStmt) throws StandardException
  {
    PreparedStatement ps = lcc.prepareInternalStatement(updateStmt);
    ResultSet rs = ps.execute(lcc, true);
    rs.close();
    rs.finish();
  }


  /**

View Full Code Here




    LanguageConnectionContext lcc = activation.getLanguageConnectionContext();
    PreparedStatement ps = lcc.prepareInternalStatement(maxStmt);


    ResultSet rs = ps.execute(lcc, false);
    DataValueDescriptor[] rowArray = rs.getNextRow().getRowArray();
    rs.close();
    rs.finish();


    return rowArray[0].getLong();

View Full Code Here

    LanguageConnectionContext lcc = (LanguageConnectionContext)
      ContextService.getContext(LanguageConnectionContext.CONTEXT_ID);


    PreparedStatement ps = lcc.prepareInternalStatement(usingText);


    ResultSet rs = ps.execute(lcc, false);
    ExecRow row = null;
    row = rs.getNextRow();
    if (row == null)
    {
      throw StandardException.newException(SQLState.LANG_NO_ROWS_FROM_USING_DURING_EXECUTION);

View Full Code Here

    */
    LanguageConnectionContext lcc = getLanguageConnectionContext();


    PreparedStatement ps = lcc.prepareInternalStatement(usingText);
  
    ResultSet rs = ps.execute(lcc, false);
    
    try {
      ExecRow row = rs.getNextRow();
      if (row == null)
      {

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, executeQuery, executeUpdate, false);
        addWarning(a.getWarnings());




        if (resultsToWrap.returnsRows()) {
          EmbedResultSet lresults = factory.newEmbedResultSet(getEmbedConnection(), resultsToWrap, forMetaData, this, ps.isAtomic());

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


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

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.