RealSQLStatement

The RealSQLStatement class is responsible for executing statements and returning results. The client calls RealSQLStatement's executeQuery()  method to execute an SQL statement. This creates new RealSQLResultSetMetaData and RealSQLResultSet objects for each SQL statement processed. Only one ResultSet can be active at any point in time - executing an SQL statement will close an active ResultSet, which means that any further data access methods invoked on that ResultSet will throw an exception.

Two classes extend RealSQLStatement:

• The RealSQLPreparedStatement class asks the server to prepare the supplied SQL statement. Parameterised inputs are supplied separately using the setXXX()  methods. The statement can be executed multiple times.

• The RealSQLCallableStatement class asks the server to prepare the supplied stored procedure. Parameterised inputs are supplied separately using the setXXX() methods inherited from the PreparedStatement class.

Reality does not support the return of a ResultSet from a stored procedure.