Class ExecutionPlan

public Portal cursorOpen(String cursorName,
                         Object[] parameters)
            throws SQLException

Set up a cursor that will execute the plan using the internal SPI_cursor_open function

Parameters:

cursorName - Name of the cursor or null for a system generated name.

parameters - Values for the parameters.

Returns:

The Portal that represents the opened cursor.

public int execute(Object[] parameters,
                   int rowCount)
            throws SQLException

Execute the plan using the internal SPI_execp function.

Parameters:

parameters - Values for the parameters.

rowCount - The maximum number of tuples to create. A value of rowCount of zero is interpreted as no limit, i.e., run to completion.

Returns:

One of the status codes declared in class SPI.

public boolean isCursorPlan()
            throws SQLException

Checks if this ExecutionPlan can create a Portal using cursorOpen(String,Object[]). This is true if the plan contains only one regular SELECT query.

Returns:

true if the plan can create a Portal

public static ExecutionPlan prepare(String statement,
                                    Oid[] argTypes)
            throws SQLException

Create an execution plan for a statement to be executed later using the internal SPI_prepare function.

Parameters:

statement - The command string.

argTypes - SQL types of argument types.

Returns:

An execution plan for the prepared statement.

See Also:

java.sql.Types