Documentation Comments
Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.
RealityV15.1Online Documentation (MoTW) Revision 7
RealSQLStatement (RealSQL-JDBC) (statemnt.htm)
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:
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.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.