public class ClientStatement extends Object implements Statement
| Modifier and Type | Field and Description |
|---|---|
protected com.pivotal.gemfirexd.thrift.StatementAttrs |
attrs |
protected ArrayList<String> |
batchSQLs |
protected ClientConnection |
conn |
protected com.pivotal.gemfirexd.thrift.RowSet |
currentGeneratedKeys |
protected com.pivotal.gemfirexd.thrift.RowSet |
currentRowSet |
protected int |
currentUpdateCount |
protected ClientFinalizer |
finalizer |
protected boolean |
isOpen |
protected ClientService |
service |
protected int |
statementId |
protected com.pivotal.gemfirexd.thrift.GFXDExceptionData |
warnings |
protected boolean |
wasNull |
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO| Modifier and Type | Method and Description |
|---|---|
void |
addBatch(String sql) |
void |
cancel() |
protected void |
checkClosed() |
void |
clearBatch() |
protected void |
clearFinalizer() |
void |
clearWarnings() |
void |
close() |
void |
closeOnCompletion() |
Blob |
createBlob(com.pivotal.gemfirexd.thrift.BlobChunk firstChunk) |
Clob |
createClob(com.pivotal.gemfirexd.thrift.ClobChunk firstChunk) |
boolean |
execute(String sql) |
protected boolean |
execute(String sql,
boolean getAutoInc,
int[] autoIncColumns,
String[] autoIncColumnNames) |
boolean |
execute(String sql,
int autoGeneratedKeys) |
boolean |
execute(String sql,
int[] columnIndexes) |
boolean |
execute(String sql,
String[] columnNames) |
int[] |
executeBatch() |
ResultSet |
executeQuery(String sql) |
int |
executeUpdate(String sql) |
protected int |
executeUpdate(String sql,
boolean getAutoInc,
int[] autoIncColumns,
String[] autoIncColumnNames) |
int |
executeUpdate(String sql,
int autoGeneratedKeys) |
int |
executeUpdate(String sql,
int[] columnIndexes) |
int |
executeUpdate(String sql,
String[] columnNames) |
protected Array |
getArray(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
protected InputStream |
getAsciiStream(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
com.pivotal.gemfirexd.thrift.StatementAttrs |
getAttributes() |
protected BigDecimal |
getBigDecimal(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
protected BigDecimal |
getBigDecimal(int columnIndex,
int scale,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
protected InputStream |
getBinaryStream(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
protected Blob |
getBlob(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
com.pivotal.gemfirexd.thrift.BlobChunk |
getBlobChunk(int lobId,
long offset,
int chunkSize,
boolean freeLobAtEnd) |
protected boolean |
getBoolean(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
protected byte |
getByte(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
protected byte[] |
getBytes(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
protected Reader |
getCharacterStream(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
protected Clob |
getClob(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
com.pivotal.gemfirexd.thrift.ClobChunk |
getClobChunk(int lobId,
long offset,
int chunkSize,
boolean freeLobAtEnd) |
Connection |
getConnection() |
protected Date |
getDate(int columnIndex,
Calendar cal,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
protected double |
getDouble(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
int |
getFetchDirection() |
int |
getFetchSize() |
protected float |
getFloat(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
ResultSet |
getGeneratedKeys() |
protected int |
getInt(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
protected HostConnection |
getLobSource(boolean throwOnFailure,
String op) |
protected long |
getLong(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
int |
getMaxFieldSize() |
int |
getMaxRows() |
boolean |
getMoreResults() |
boolean |
getMoreResults(int current) |
protected Reader |
getNCharacterStream(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
protected NClob |
getNClob(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
protected String |
getNString(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
protected <T> T |
getObject(int columnIndex,
Class<T> type,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
protected Object |
getObject(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
protected Object |
getObject(int columnIndex,
Map<String,Class<?>> map,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
int |
getQueryTimeout() |
protected Ref |
getRef(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
ResultSet |
getResultSet() |
int |
getResultSetConcurrency() |
int |
getResultSetHoldability() |
int |
getResultSetType() |
protected RowId |
getRowId(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
protected short |
getShort(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
protected SQLXML |
getSQLXML(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
protected String |
getString(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
protected Time |
getTime(int columnIndex,
Calendar cal,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
protected Timestamp |
getTimestamp(int columnIndex,
Calendar cal,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
int |
getUpdateCount() |
protected URL |
getURL(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row) |
SQLWarning |
getWarnings() |
protected void |
initializeProcedureOutParams(com.pivotal.gemfirexd.thrift.StatementResult sr) |
boolean |
isClosed() |
boolean |
isCloseOnCompletion() |
boolean |
isPoolable() |
boolean |
isWrapperFor(Class<?> iface) |
protected void |
reset() |
protected void |
setAutoIncAttributes(boolean getAutoInc,
int[] autoIncColumns,
String[] autoIncColumnNames) |
protected void |
setCurrentRowSet(com.pivotal.gemfirexd.thrift.RowSet rs) |
protected void |
setCurrentSource(byte entityId,
int newId,
com.pivotal.gemfirexd.thrift.RowSet rs) |
void |
setCursorName(String name) |
void |
setEscapeProcessing(boolean enable) |
void |
setFetchDirection(int direction) |
void |
setFetchSize(int rows) |
void |
setMaxFieldSize(int max) |
void |
setMaxRows(int max) |
void |
setPoolable(boolean poolable) |
void |
setQueryTimeout(int seconds) |
<T> T |
unwrap(Class<T> iface) |
protected final ClientConnection conn
protected final com.pivotal.gemfirexd.thrift.StatementAttrs attrs
protected volatile int statementId
protected com.pivotal.gemfirexd.thrift.RowSet currentRowSet
protected int currentUpdateCount
protected com.pivotal.gemfirexd.thrift.RowSet currentGeneratedKeys
protected volatile com.pivotal.gemfirexd.thrift.GFXDExceptionData warnings
protected volatile boolean isOpen
protected final ClientService service
protected ClientFinalizer finalizer
protected boolean wasNull
protected final void checkClosed()
throws SQLException
SQLExceptionpublic final com.pivotal.gemfirexd.thrift.StatementAttrs getAttributes()
protected void reset()
protected void setCurrentRowSet(com.pivotal.gemfirexd.thrift.RowSet rs)
public ResultSet executeQuery(String sql) throws SQLException
executeQuery in interface StatementSQLExceptionpublic int executeUpdate(String sql) throws SQLException
executeUpdate in interface StatementSQLExceptionpublic int getMaxFieldSize()
throws SQLException
getMaxFieldSize in interface StatementSQLExceptionpublic void setMaxFieldSize(int max)
throws SQLException
setMaxFieldSize in interface StatementSQLExceptionpublic int getMaxRows()
throws SQLException
getMaxRows in interface StatementSQLExceptionpublic void setMaxRows(int max)
throws SQLException
setMaxRows in interface StatementSQLExceptionpublic void setEscapeProcessing(boolean enable)
throws SQLException
setEscapeProcessing in interface StatementSQLExceptionpublic int getQueryTimeout()
throws SQLException
getQueryTimeout in interface StatementSQLExceptionpublic void setQueryTimeout(int seconds)
throws SQLException
setQueryTimeout in interface StatementSQLExceptionpublic void close()
throws SQLException
close in interface AutoCloseableclose in interface StatementSQLExceptionpublic void cancel()
throws SQLException
cancel in interface StatementSQLExceptionpublic SQLWarning getWarnings() throws SQLException
getWarnings in interface StatementSQLExceptionpublic void clearWarnings()
throws SQLException
clearWarnings in interface StatementSQLExceptionpublic void setCursorName(String name) throws SQLException
setCursorName in interface StatementSQLExceptionpublic boolean execute(String sql) throws SQLException
execute in interface StatementSQLExceptionpublic ResultSet getResultSet() throws SQLException
getResultSet in interface StatementSQLExceptionpublic int getUpdateCount()
throws SQLException
getUpdateCount in interface StatementSQLExceptionpublic boolean getMoreResults()
throws SQLException
getMoreResults in interface StatementSQLExceptionpublic void setFetchDirection(int direction)
throws SQLException
setFetchDirection in interface StatementSQLExceptionpublic int getFetchDirection()
throws SQLException
getFetchDirection in interface StatementSQLExceptionpublic void setFetchSize(int rows)
throws SQLException
setFetchSize in interface StatementSQLExceptionpublic int getFetchSize()
getFetchSize in interface Statementpublic int getResultSetConcurrency()
throws SQLException
getResultSetConcurrency in interface StatementSQLExceptionpublic int getResultSetType()
throws SQLException
getResultSetType in interface StatementSQLExceptionpublic void addBatch(String sql) throws SQLException
addBatch in interface StatementSQLExceptionpublic void clearBatch()
throws SQLException
clearBatch in interface StatementSQLExceptionpublic int[] executeBatch()
throws SQLException
executeBatch in interface StatementSQLExceptionpublic Connection getConnection() throws SQLException
getConnection in interface StatementSQLExceptionpublic boolean getMoreResults(int current)
throws SQLException
getMoreResults in interface StatementSQLExceptionpublic ResultSet getGeneratedKeys() throws SQLException
getGeneratedKeys in interface StatementSQLExceptionpublic int executeUpdate(String sql, int autoGeneratedKeys) throws SQLException
executeUpdate in interface StatementSQLExceptionpublic int executeUpdate(String sql, int[] columnIndexes) throws SQLException
executeUpdate in interface StatementSQLExceptionpublic int executeUpdate(String sql, String[] columnNames) throws SQLException
executeUpdate in interface StatementSQLExceptionprotected final void setAutoIncAttributes(boolean getAutoInc,
int[] autoIncColumns,
String[] autoIncColumnNames)
protected int executeUpdate(String sql, boolean getAutoInc, int[] autoIncColumns, String[] autoIncColumnNames) throws SQLException
SQLExceptionpublic boolean execute(String sql, int autoGeneratedKeys) throws SQLException
execute in interface StatementSQLExceptionpublic boolean execute(String sql, int[] columnIndexes) throws SQLException
execute in interface StatementSQLExceptionpublic boolean execute(String sql, String[] columnNames) throws SQLException
execute in interface StatementSQLExceptionprotected final boolean execute(String sql, boolean getAutoInc, int[] autoIncColumns, String[] autoIncColumnNames) throws SQLException
SQLExceptionprotected void initializeProcedureOutParams(com.pivotal.gemfirexd.thrift.StatementResult sr)
public int getResultSetHoldability()
throws SQLException
getResultSetHoldability in interface StatementSQLExceptionpublic boolean isClosed()
throws SQLException
isClosed in interface StatementSQLExceptionpublic void setPoolable(boolean poolable)
throws SQLException
setPoolable in interface StatementSQLExceptionpublic boolean isPoolable()
throws SQLException
isPoolable in interface StatementSQLExceptionpublic <T> T unwrap(Class<T> iface) throws SQLException
unwrap in interface WrapperSQLExceptionpublic boolean isWrapperFor(Class<?> iface) throws SQLException
isWrapperFor in interface WrapperSQLExceptionpublic void closeOnCompletion()
throws SQLException
closeOnCompletion in interface StatementSQLExceptionpublic boolean isCloseOnCompletion()
throws SQLException
isCloseOnCompletion in interface StatementSQLExceptionprotected final HostConnection getLobSource(boolean throwOnFailure, String op) throws SQLException
SQLExceptionprotected final void setCurrentSource(byte entityId,
int newId,
com.pivotal.gemfirexd.thrift.RowSet rs)
protected final void clearFinalizer()
public final Blob createBlob(com.pivotal.gemfirexd.thrift.BlobChunk firstChunk) throws SQLException
createBlob in interface com.pivotal.gemfirexd.thrift.common.LobServiceSQLExceptionpublic final Clob createClob(com.pivotal.gemfirexd.thrift.ClobChunk firstChunk) throws SQLException
createClob in interface com.pivotal.gemfirexd.thrift.common.LobServiceSQLExceptionpublic final com.pivotal.gemfirexd.thrift.BlobChunk getBlobChunk(int lobId,
long offset,
int chunkSize,
boolean freeLobAtEnd)
throws SQLException
getBlobChunk in interface com.pivotal.gemfirexd.thrift.common.LobServiceSQLExceptionpublic final com.pivotal.gemfirexd.thrift.ClobChunk getClobChunk(int lobId,
long offset,
int chunkSize,
boolean freeLobAtEnd)
throws SQLException
getClobChunk in interface com.pivotal.gemfirexd.thrift.common.LobServiceSQLExceptionprotected final String getString(int columnIndex, com.pivotal.gemfirexd.thrift.GFXDType gfxdType, com.pivotal.gemfirexd.thrift.Row row) throws SQLException
SQLExceptionprotected final boolean getBoolean(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row)
throws SQLException
SQLExceptionprotected final byte getByte(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row)
throws SQLException
SQLExceptionprotected final short getShort(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row)
throws SQLException
SQLExceptionprotected final int getInt(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row)
throws SQLException
SQLExceptionprotected final long getLong(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row)
throws SQLException
SQLExceptionprotected final float getFloat(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row)
throws SQLException
SQLExceptionprotected final double getDouble(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row)
throws SQLException
SQLExceptionprotected final BigDecimal getBigDecimal(int columnIndex, com.pivotal.gemfirexd.thrift.GFXDType gfxdType, com.pivotal.gemfirexd.thrift.Row row) throws SQLException
SQLExceptionprotected final BigDecimal getBigDecimal(int columnIndex, int scale, com.pivotal.gemfirexd.thrift.GFXDType gfxdType, com.pivotal.gemfirexd.thrift.Row row) throws SQLException
SQLExceptionprotected final byte[] getBytes(int columnIndex,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row)
throws SQLException
SQLExceptionprotected final Date getDate(int columnIndex, Calendar cal, com.pivotal.gemfirexd.thrift.GFXDType gfxdType, com.pivotal.gemfirexd.thrift.Row row) throws SQLException
SQLExceptionprotected final Time getTime(int columnIndex, Calendar cal, com.pivotal.gemfirexd.thrift.GFXDType gfxdType, com.pivotal.gemfirexd.thrift.Row row) throws SQLException
SQLExceptionprotected final Timestamp getTimestamp(int columnIndex, Calendar cal, com.pivotal.gemfirexd.thrift.GFXDType gfxdType, com.pivotal.gemfirexd.thrift.Row row) throws SQLException
SQLExceptionprotected final Object getObject(int columnIndex, com.pivotal.gemfirexd.thrift.GFXDType gfxdType, com.pivotal.gemfirexd.thrift.Row row) throws SQLException
SQLExceptionprotected final Blob getBlob(int columnIndex, com.pivotal.gemfirexd.thrift.GFXDType gfxdType, com.pivotal.gemfirexd.thrift.Row row) throws SQLException
SQLExceptionprotected final InputStream getBinaryStream(int columnIndex, com.pivotal.gemfirexd.thrift.GFXDType gfxdType, com.pivotal.gemfirexd.thrift.Row row) throws SQLException
SQLExceptionprotected final Clob getClob(int columnIndex, com.pivotal.gemfirexd.thrift.GFXDType gfxdType, com.pivotal.gemfirexd.thrift.Row row) throws SQLException
SQLExceptionprotected final Reader getCharacterStream(int columnIndex, com.pivotal.gemfirexd.thrift.GFXDType gfxdType, com.pivotal.gemfirexd.thrift.Row row) throws SQLException
SQLExceptionprotected final InputStream getAsciiStream(int columnIndex, com.pivotal.gemfirexd.thrift.GFXDType gfxdType, com.pivotal.gemfirexd.thrift.Row row) throws SQLException
SQLExceptionprotected Object getObject(int columnIndex, Map<String,Class<?>> map, com.pivotal.gemfirexd.thrift.GFXDType gfxdType, com.pivotal.gemfirexd.thrift.Row row) throws SQLException
SQLExceptionprotected Ref getRef(int columnIndex, com.pivotal.gemfirexd.thrift.GFXDType gfxdType, com.pivotal.gemfirexd.thrift.Row row) throws SQLException
SQLExceptionprotected Array getArray(int columnIndex, com.pivotal.gemfirexd.thrift.GFXDType gfxdType, com.pivotal.gemfirexd.thrift.Row row) throws SQLException
SQLExceptionprotected URL getURL(int columnIndex, com.pivotal.gemfirexd.thrift.GFXDType gfxdType, com.pivotal.gemfirexd.thrift.Row row) throws SQLException
SQLExceptionprotected RowId getRowId(int columnIndex, com.pivotal.gemfirexd.thrift.GFXDType gfxdType, com.pivotal.gemfirexd.thrift.Row row) throws SQLException
SQLExceptionprotected NClob getNClob(int columnIndex, com.pivotal.gemfirexd.thrift.GFXDType gfxdType, com.pivotal.gemfirexd.thrift.Row row) throws SQLException
SQLExceptionprotected SQLXML getSQLXML(int columnIndex, com.pivotal.gemfirexd.thrift.GFXDType gfxdType, com.pivotal.gemfirexd.thrift.Row row) throws SQLException
SQLExceptionprotected String getNString(int columnIndex, com.pivotal.gemfirexd.thrift.GFXDType gfxdType, com.pivotal.gemfirexd.thrift.Row row) throws SQLException
SQLExceptionprotected Reader getNCharacterStream(int columnIndex, com.pivotal.gemfirexd.thrift.GFXDType gfxdType, com.pivotal.gemfirexd.thrift.Row row) throws SQLException
SQLExceptionprotected <T> T getObject(int columnIndex,
Class<T> type,
com.pivotal.gemfirexd.thrift.GFXDType gfxdType,
com.pivotal.gemfirexd.thrift.Row row)
throws SQLException
SQLExceptionCopyright © 2010-2015 Pivotal Software, Inc. All rights reserved.