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

    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

  }


  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

    ResultSet rs = null;
    try
    {
      PreparedStatement ps = lcc.prepareInternalStatement(td.getSchemaDescriptor(), checkStmt.toString());


      rs = ps.execute(lcc, false);
      ExecRow row = rs.getNextRow();
      if (SanityManager.DEBUG)
      {
        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);
        getWarnings(a.getWarnings());




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

View Full Code Here

    ResultSet rs = null;
    try
    {
      PreparedStatement ps = lcc.prepareInternalStatement(td.getSchemaDescriptor(), checkStmt.toString());


      rs = ps.execute(lcc, false);
      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

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.