org.postgresql.core

Interface ResultHandler

All Known Implementing Classes:

AbstractJdbc2ResultSet.CursorResultHandler, AbstractJdbc2Statement.StatementResultHandler

public interface ResultHandler

Callback interface for passing query results from the protocol-specific layer to the protocol-independent JDBC implementation code.

In general, a single query execution will consist of a number of calls to handleResultRows, handleCommandStatus, handleWarning, and handleError, followed by a single call to handleCompletion when query execution is complete. If the caller wants to throw SQLException, this can be done in handleCompletion.

Each executed query ends with a call to handleResultRows, handleCommandStatus, or handleError. If an error occurs, subsequent queries won't generate callbacks.

Author:

Oliver Jowett (oliver@opencloud.com)

Method Summary

Methods

Modifier and Type	Method and Description
void	handleCommandStatus(java.lang.String status, int updateCount, long insertOID) Called when a query that did not return a resultset completes.
void	handleCompletion() Called before a QueryExecutor method returns.
void	handleError(java.sql.SQLException error) Called when an error occurs.
void	handleResultRows(Query fromQuery, Field[] fields, java.util.Vector tuples, ResultCursor cursor) Called when result rows are received from a query.
void	handleWarning(java.sql.SQLWarning warning) Called when a warning is emitted.

Method Detail

handleResultRows

void handleResultRows(Query fromQuery,
                    Field[] fields,
                    java.util.Vector tuples,
                    ResultCursor cursor)

Called when result rows are received from a query.

Parameters:

fromQuery - the underlying query that generated these results; this may not be very specific (e.g. it may be a query that includes multiple statements).

fields - column metadata for the resultset; might be null if Query.QUERY_NO_METADATA was specified.

tuples - the actual data

cursor - a cursor to use to fetch additional data; null if no further results are present.

handleCommandStatus

void handleCommandStatus(java.lang.String status,
                       int updateCount,
                       long insertOID)

Called when a query that did not return a resultset completes.

Parameters:

status - the command status string (e.g. "SELECT") returned by the backend

updateCount - the number of rows affected by an INSERT, UPDATE, DELETE, FETCH, or MOVE command; -1 if not available.

insertOID - for a single-row INSERT query, the OID of the newly inserted row; 0 if not available.

handleWarning

void handleWarning(java.sql.SQLWarning warning)

Called when a warning is emitted.

Parameters:

warning - the warning that occured.

handleError

void handleError(java.sql.SQLException error)

Called when an error occurs. Subsequent queries are abandoned; in general the only calls between a handleError call and a subsequent handleCompletion call are handleError or handleWarning.

Parameters:

error - the error that occurred

handleCompletion

void handleCompletion()
                      throws java.sql.SQLException

Called before a QueryExecutor method returns. This method may throw a SQLException if desired; if it does, the QueryExecutor method will propagate that exception to the original caller.

Throws:

java.sql.SQLException - if the handler wishes the original method to throw an exception.