List of executeSubStatement() Examples

Examples of executeSubStatement()

org.apache.derby.iapi.sql.PreparedStatement.executeSubStatement()
Execute a statement as part of another statement (ithout a nested connection) 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 parent The activation of the superstatement @param activation The activation containing all the local stateto execute the plan for substatement @param rollbackParentContext True if in the event of a statement-levelexception, 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
org.apache.derby.iapi.sql.execute.ExecPreparedStatement.executeSubStatement()

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

    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.executeSubStatement(lcc, true, 0L);
    rs.close();
  }


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

View Full Code Here

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


    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.executeSubStatement(lcc, false, 0L);
    DataValueDescriptor[] rowArray = rs.getNextRow().getRowArray();
    rs.close();
    rs.finish();


    return rowArray[0].getLong();

View Full Code Here

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

    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.executeSubStatement(lcc, true, 0L);
    rs.close();
  }


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

View Full Code Here

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

    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.executeSubStatement(lcc, false, 0L);
    DataValueDescriptor[] rowArray = rs.getNextRow().getRowArray();
    rs.close();
    rs.finish();


    return rowArray[0].getLong();

View Full Code Here

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

    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.executeSubStatement(lcc, true, 0L);
    rs.close();
  }


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

View Full Code Here

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

    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.executeSubStatement(lcc, false, 0L);
    DataValueDescriptor[] rowArray = rs.getNextRow().getRowArray();
    rs.close();
    rs.finish();


    return rowArray[0].getLong();

View Full Code Here

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

    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.executeSubStatement(lcc, true, 0L);
    rs.close();
  }


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

View Full Code Here

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

    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.executeSubStatement(lcc, false, 0L);
    DataValueDescriptor[] rowArray = rs.getNextRow().getRowArray();
    rs.close();
    rs.finish();


    return rowArray[0].getLong();

View Full Code Here

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

    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.executeSubStatement(lcc, true, 0L);
    rs.close();
  }


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

View Full Code Here

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


    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.executeSubStatement(lcc, false, 0L);
    DataValueDescriptor[] rowArray = rs.getNextRow().getRowArray();
    rs.close();
    rs.finish();


    return rowArray[0].getLong();

View Full Code Here

0 1 2

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.