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.
Reality V15.0 ()
: Class RealSQLStatement (RealSQL-JDBC) (realsqlstatement.html)
|
|
|||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||
| SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||
java.lang.Object | +--com.northgateis.reality.realsql.RealSQLStatement
The RealSQLStatement class is an implementation of the JDBC 2.0 Statement interface.
Connection.createStatement()
| Method Summary | |
void
|
addBatch(java.lang.String sql)
Not supported by the RealSQL-JDBC driver. |
protected void
|
addResultSet(RealSQLResultSet rs)
|
void
|
cancel()
Cancels currently executing statement. |
void
|
clearBatch()
Not supported by the RealSQL-JDBC driver. |
void
|
clearWarnings()
Clears all the warnings reported on this Statement object. |
void
|
close()
Closes the statement and any associated ResultSet. |
protected void
|
completeLoad()
|
boolean
|
execute(java.lang.String sql)
Executes a SQL statement that may return multiple results. |
int[]
|
executeBatch()
Not supported by the RealSQL-JDBC driver. |
protected java.sql.ResultSet
|
executeCatalogQuery(java.lang.String sql)
|
protected boolean
|
executeCommon(RealSQLResultSetMetaData rsmd)
|
java.sql.ResultSet
|
executeQuery(java.lang.String sql)
Executes a SQL statement that returns a single ResultSet. |
protected java.sql.ResultSet
|
executeQueryCommon(RealSQLResultSetMetaData rsmd)
|
protected RealSQLResultSet
|
executeStmt(RealSQLResultSetMetaData rsmd)
|
int
|
executeUpdate(java.lang.String sql)
Executes an SQL INSERT, UPDATE or DELETE statement. |
protected int
|
executeUpdateCommon(RealSQLResultSetMetaData rsmd)
|
java.sql.Connection
|
getConnection()
JDBC 2.0 Returns the Connection object that produced this Statement object. |
int
|
getFetchDirection()
JDBC 2.0 Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this Statement object. |
int
|
getFetchSize()
JDBC 2.0 Retrieves the number of result set rows that is the default fetch size for result sets generated from this Statement object. |
int
|
getMaxFieldSize()
Returns the maximum number of bytes allowed for any column value. |
int
|
getMaxRows()
Retrieves the maximum number of rows that a ResultSet can contain. |
boolean
|
getMoreResults()
Moves to a Statement's next result. |
int
|
getQueryTimeout()
Retrieves the number of seconds the driver will wait for a Statement to execute. |
java.sql.ResultSet
|
getResultSet()
Returns the current result as a ResultSet object. |
int
|
getResultSetConcurrency()
JDBC 2.0 result set concurrency. |
int
|
getResultSetType()
JDBC 2.0 Determine the result set type. |
int
|
getUpdateCount()
Returns the current result as an update count. |
java.sql.SQLWarning
|
getWarnings()
Retrieves the first warning reported by calls on this Statement. |
protected boolean
|
isCatalogQuery()
|
protected java.sql.SQLException
|
methodNotSupported()
|
protected RealSQLResultSetMetaData
|
prepareStmt(java.lang.String sql)
|
protected void
|
reset()
|
void
|
setCursorName(java.lang.String unused)
Not supported by the RealSQL-JDBC driver. |
void
|
setEscapeProcessing(boolean enable)
Not supported by the RealSQL-JDBC driver. |
void
|
setFetchDirection(int dir)
JDBC 2.0 Gives the driver a hint as to the direction in which the rows in a result set will be processed. |
void
|
setFetchSize(int unused)
Not supported by the RealSQL-JDBC driver. |
void
|
setMaxFieldSize(int max)
Not supported by the RealSQL-JDBC driver. |
void
|
setMaxRows(int max)
Not supported by the RealSQL-JDBC driver. |
void
|
setQueryTimeout(int unused)
Not supported by the RealSQL-JDBC driver. |
| Methods inherited from class java.lang.Object |
clone,
equals,
finalize,
getClass,
hashCode,
notify,
notifyAll,
toString,
wait,
wait,
wait |
| Method Detail |
public void addBatch(java.lang.String sql) throws java.sql.SQLException
JDBC 2.0 Adds a SQL command to the current batch of commmands for the statement.
sql - the SQL statement to be added to the batchpublic void cancel() throws java.sql.SQLException
public void clearBatch() throws java.sql.SQLException
JDBC 2.0 Makes the set of commands in the current batch empty.
public void clearWarnings() throws java.sql.SQLException
public void close() throws java.sql.SQLException
public boolean execute(java.lang.String sql) throws java.sql.SQLException
sql - the SQL to be sent to the databaseprotected boolean executeCommon(RealSQLResultSetMetaData rsmd) throws java.sql.SQLException
public int[] executeBatch() throws java.sql.SQLException
JDBC 2.0 Submits a batch of commands to the database for execution.
public java.sql.ResultSet executeQuery(java.lang.String sql) throws java.sql.SQLException
sql - the SQL to send to the database.protected java.sql.ResultSet executeQueryCommon(RealSQLResultSetMetaData rsmd) throws java.sql.SQLException
public int executeUpdate(java.lang.String sql) throws java.sql.SQLException
sql - the UPDATE SQL.protected int executeUpdateCommon(RealSQLResultSetMetaData rsmd) throws java.sql.SQLException
public java.sql.Connection getConnection()
public int getFetchDirection() throws java.sql.SQLException
public int getFetchSize() throws java.sql.SQLException
public int getMaxFieldSize() throws java.sql.SQLException
public int getMaxRows() throws java.sql.SQLException
public boolean getMoreResults() throws java.sql.SQLException
public int getQueryTimeout() throws java.sql.SQLException
public java.sql.ResultSet getResultSet() throws java.sql.SQLException
public int getResultSetConcurrency() throws java.sql.SQLException
public int getResultSetType() throws java.sql.SQLException
public int getUpdateCount() throws java.sql.SQLException
If the result is a ResultSet or there are no more results, -1 is returned.
public final java.sql.SQLWarning getWarnings() throws java.sql.SQLException
public void setQueryTimeout(int unused) throws java.sql.SQLException
Sets the number of seconds the driver will wait for a Statement to execute to the given number of seconds.
unused - the number of seconds the Statement should waitpublic void setCursorName(java.lang.String unused) throws java.sql.SQLException
Defines the SQL cursor name that will be used by subsequent Statement execute methods.
unused - the name of the cursorpublic void setEscapeProcessing(boolean enable) throws java.sql.SQLException
Sets escape processing on or off.
enable - indicate whether to enable or disable escape processingpublic void setFetchDirection(int dir) throws java.sql.SQLException
Reality only supports FETCH_FORWARD.
dir - the directionpublic void setFetchSize(int unused) throws java.sql.SQLException
JDBC 2.0 Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed.
unused - the suggested fetch sizepublic void setMaxFieldSize(int max) throws java.sql.SQLException
Sets the limit for the maximum number of bytes in a column to the given number of bytes.
max - the maximum field sizepublic void setMaxRows(int max) throws java.sql.SQLException
Sets the limit for the maximum number of rows that any ResultSet can contain to the given number.
max - the maximum number of rowsprotected void completeLoad()
protected void reset() throws java.sql.SQLException
protected java.sql.ResultSet executeCatalogQuery(java.lang.String sql) throws java.sql.SQLException
protected boolean isCatalogQuery()
protected RealSQLResultSetMetaData prepareStmt(java.lang.String sql) throws java.sql.SQLException
protected RealSQLResultSet executeStmt(RealSQLResultSetMetaData rsmd) throws java.sql.SQLException
protected void addResultSet(RealSQLResultSet rs)
protected java.sql.SQLException methodNotSupported()
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||
| SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||