public class PGCallableStatement extends Object implements CallableStatement
Modifier and Type | Field and Description |
---|---|
protected static String |
CACHED_STATEMENT_PREFIX |
protected static String |
NO_CACHE_STATEMENT_PREFIX |
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() |
void |
addBatch(String sql) |
void |
cancel() |
void |
clearBatch() |
void |
clearParameters() |
void |
clearWarnings() |
void |
close() |
void |
closeOnCompletion() |
static void |
dispose(PGConnectionImpl connection,
ServerObjectType objectType,
String objectName)
Disposes of the named server object
|
boolean |
execute() |
boolean |
execute(String sql) |
boolean |
execute(String sql,
int autoGeneratedKeys) |
boolean |
execute(String sql,
int[] columnIndexes) |
boolean |
execute(String sql,
String[] columnNames) |
int[] |
executeBatch() |
com.impossibl.postgres.jdbc.PGResultSet |
executeQuery() |
ResultSet |
executeQuery(String sql) |
boolean |
executeSimple(String sql)
Execute the given sql
|
boolean |
executeStatement(String statementName,
List<Type> parameterTypes,
List<Object> parameterValues)
Execute the named statement.
|
int |
executeUpdate() |
int |
executeUpdate(String sql) |
int |
executeUpdate(String sql,
int autoGeneratedKeys) |
int |
executeUpdate(String sql,
int[] columnIndexes) |
int |
executeUpdate(String sql,
String[] columnNames) |
Array |
getArray(int parameterIndex) |
Array |
getArray(String parameterName) |
BigDecimal |
getBigDecimal(int parameterIndex) |
BigDecimal |
getBigDecimal(int parameterIndex,
int scale)
Deprecated.
|
BigDecimal |
getBigDecimal(String parameterName) |
Blob |
getBlob(int parameterIndex) |
Blob |
getBlob(String parameterName) |
boolean |
getBoolean(int parameterIndex) |
boolean |
getBoolean(String parameterName) |
byte |
getByte(int parameterIndex) |
byte |
getByte(String parameterName) |
byte[] |
getBytes(int parameterIndex) |
byte[] |
getBytes(String parameterName) |
Reader |
getCharacterStream(int parameterIndex) |
Reader |
getCharacterStream(String parameterName) |
Clob |
getClob(int parameterIndex) |
Clob |
getClob(String parameterName) |
Connection |
getConnection() |
Date |
getDate(int parameterIndex) |
Date |
getDate(int parameterIndex,
Calendar cal) |
Date |
getDate(String parameterName) |
Date |
getDate(String parameterName,
Calendar cal) |
double |
getDouble(int parameterIndex) |
double |
getDouble(String parameterName) |
int |
getFetchDirection() |
int |
getFetchSize() |
float |
getFloat(int parameterIndex) |
float |
getFloat(String parameterName) |
ResultSet |
getGeneratedKeys() |
int |
getInt(int parameterIndex) |
int |
getInt(String parameterName) |
long |
getLong(int parameterIndex) |
long |
getLong(String parameterName) |
int |
getMaxFieldSize() |
int |
getMaxRows() |
ResultSetMetaData |
getMetaData() |
boolean |
getMoreResults() |
boolean |
getMoreResults(int current) |
Reader |
getNCharacterStream(int parameterIndex) |
Reader |
getNCharacterStream(String parameterName) |
NClob |
getNClob(int parameterIndex) |
NClob |
getNClob(String parameterName) |
String |
getNString(int parameterIndex) |
String |
getNString(String parameterName) |
Object |
getObject(int parameterIndex) |
<T> T |
getObject(int parameterIndex,
Class<T> type) |
Object |
getObject(int parameterIndex,
Map<String,Class<?>> map) |
Object |
getObject(String parameterName) |
<T> T |
getObject(String parameterName,
Class<T> type) |
Object |
getObject(String parameterName,
Map<String,Class<?>> map) |
ParameterMetaData |
getParameterMetaData() |
int |
getQueryTimeout() |
Ref |
getRef(int parameterIndex) |
Ref |
getRef(String parameterName) |
com.impossibl.postgres.jdbc.PGResultSet |
getResultSet() |
int |
getResultSetConcurrency() |
int |
getResultSetHoldability() |
int |
getResultSetType() |
RowId |
getRowId(int parameterIndex) |
RowId |
getRowId(String parameterName) |
short |
getShort(int parameterIndex) |
short |
getShort(String parameterName) |
SQLXML |
getSQLXML(int parameterIndex) |
SQLXML |
getSQLXML(String parameterName) |
String |
getString(int parameterIndex) |
String |
getString(String parameterName) |
Time |
getTime(int parameterIndex) |
Time |
getTime(int parameterIndex,
Calendar cal) |
Time |
getTime(String parameterName) |
Time |
getTime(String parameterName,
Calendar cal) |
Timestamp |
getTimestamp(int parameterIndex) |
Timestamp |
getTimestamp(int parameterIndex,
Calendar cal) |
Timestamp |
getTimestamp(String parameterName) |
Timestamp |
getTimestamp(String parameterName,
Calendar cal) |
int |
getUpdateCount() |
URL |
getURL(int parameterIndex) |
URL |
getURL(String parameterName) |
boolean |
getWantsGeneratedKeys() |
SQLWarning |
getWarnings() |
boolean |
isClosed() |
boolean |
isCloseOnCompletion() |
boolean |
isPoolable() |
boolean |
isWrapperFor(Class<?> iface) |
void |
registerOutParameter(int parameterIndex,
int sqlType) |
void |
registerOutParameter(int parameterIndex,
int sqlType,
int scale) |
void |
registerOutParameter(int parameterIndex,
int sqlType,
String typeName) |
void |
registerOutParameter(String parameterName,
int sqlType) |
void |
registerOutParameter(String parameterName,
int sqlType,
int scale) |
void |
registerOutParameter(String parameterName,
int sqlType,
String typeName) |
void |
setArray(int parameterIndex,
Array x) |
void |
setAsciiStream(int parameterIndex,
InputStream x) |
void |
setAsciiStream(int parameterIndex,
InputStream x,
int length) |
void |
setAsciiStream(int parameterIndex,
InputStream x,
long length) |
void |
setAsciiStream(String parameterName,
InputStream x) |
void |
setAsciiStream(String parameterName,
InputStream x,
int length) |
void |
setAsciiStream(String parameterName,
InputStream x,
long length) |
void |
setBigDecimal(int parameterIndex,
BigDecimal x) |
void |
setBigDecimal(String parameterName,
BigDecimal x) |
void |
setBinaryStream(int parameterIndex,
InputStream x) |
void |
setBinaryStream(int parameterIndex,
InputStream x,
int length) |
void |
setBinaryStream(int parameterIndex,
InputStream x,
long length) |
void |
setBinaryStream(String parameterName,
InputStream x) |
void |
setBinaryStream(String parameterName,
InputStream x,
int length) |
void |
setBinaryStream(String parameterName,
InputStream x,
long length) |
void |
setBlob(int parameterIndex,
Blob x) |
void |
setBlob(int parameterIndex,
InputStream inputStream) |
void |
setBlob(int parameterIndex,
InputStream inputStream,
long length) |
void |
setBlob(String parameterName,
Blob x) |
void |
setBlob(String parameterName,
InputStream inputStream) |
void |
setBlob(String parameterName,
InputStream inputStream,
long length) |
void |
setBoolean(int parameterIndex,
boolean x) |
void |
setBoolean(String parameterName,
boolean x) |
void |
setByte(int parameterIndex,
byte x) |
void |
setByte(String parameterName,
byte x) |
void |
setBytes(int parameterIndex,
byte[] x) |
void |
setBytes(String parameterName,
byte[] x) |
void |
setCharacterStream(int parameterIndex,
Reader reader) |
void |
setCharacterStream(int parameterIndex,
Reader reader,
int length) |
void |
setCharacterStream(int parameterIndex,
Reader reader,
long length) |
void |
setCharacterStream(String parameterName,
Reader reader) |
void |
setCharacterStream(String parameterName,
Reader reader,
int length) |
void |
setCharacterStream(String parameterName,
Reader reader,
long length) |
void |
setClob(int parameterIndex,
Clob x) |
void |
setClob(int parameterIndex,
Reader reader) |
void |
setClob(int parameterIndex,
Reader reader,
long length) |
void |
setClob(String parameterName,
Clob x) |
void |
setClob(String parameterName,
Reader reader) |
void |
setClob(String parameterName,
Reader reader,
long length) |
void |
setCursorName(String name) |
void |
setDate(int parameterIndex,
Date x) |
void |
setDate(int parameterIndex,
Date x,
Calendar cal) |
void |
setDate(String parameterName,
Date x) |
void |
setDate(String parameterName,
Date x,
Calendar cal) |
void |
setDouble(int parameterIndex,
double x) |
void |
setDouble(String parameterName,
double x) |
void |
setEscapeProcessing(boolean enable) |
void |
setFetchDirection(int direction) |
void |
setFetchSize(int rows) |
void |
setFloat(int parameterIndex,
float x) |
void |
setFloat(String parameterName,
float x) |
void |
setInt(int parameterIndex,
int x) |
void |
setInt(String parameterName,
int x) |
void |
setLong(int parameterIndex,
long x) |
void |
setLong(String parameterName,
long x) |
void |
setMaxFieldSize(int max) |
void |
setMaxRows(int max) |
void |
setNCharacterStream(int parameterIndex,
Reader value) |
void |
setNCharacterStream(int parameterIndex,
Reader value,
long length) |
void |
setNCharacterStream(String parameterName,
Reader value) |
void |
setNCharacterStream(String parameterName,
Reader value,
long length) |
void |
setNClob(int parameterIndex,
NClob value) |
void |
setNClob(int parameterIndex,
Reader reader) |
void |
setNClob(int parameterIndex,
Reader reader,
long length) |
void |
setNClob(String parameterName,
NClob value) |
void |
setNClob(String parameterName,
Reader reader) |
void |
setNClob(String parameterName,
Reader reader,
long length) |
void |
setNString(int parameterIndex,
String value) |
void |
setNString(String parameterName,
String value) |
void |
setNull(int parameterIndex,
int sqlType) |
void |
setNull(int parameterIndex,
int sqlType,
String typeName) |
void |
setNull(String parameterName,
int sqlType) |
void |
setNull(String parameterName,
int sqlType,
String typeName) |
void |
setObject(int parameterIndex,
Object x) |
void |
setObject(int parameterIndex,
Object x,
int targetSqlType) |
void |
setObject(int parameterIndex,
Object x,
int targetSqlType,
int scaleOrLength) |
void |
setObject(String parameterName,
Object x) |
void |
setObject(String parameterName,
Object x,
int targetSqlType) |
void |
setObject(String parameterName,
Object x,
int targetSqlType,
int scale) |
void |
setPoolable(boolean poolable) |
void |
setQueryTimeout(int queryTimeout) |
void |
setRef(int parameterIndex,
Ref x) |
void |
setRowId(int parameterIndex,
RowId x) |
void |
setRowId(String parameterName,
RowId x) |
void |
setShort(int parameterIndex,
short x) |
void |
setShort(String parameterName,
short x) |
void |
setSQLXML(int parameterIndex,
SQLXML xmlObject) |
void |
setSQLXML(String parameterName,
SQLXML xmlObject) |
void |
setString(int parameterIndex,
String x) |
void |
setString(String parameterName,
String x) |
void |
setTime(int parameterIndex,
Time x) |
void |
setTime(int parameterIndex,
Time x,
Calendar cal) |
void |
setTime(String parameterName,
Time x) |
void |
setTime(String parameterName,
Time x,
Calendar cal) |
void |
setTimestamp(int parameterIndex,
Timestamp x) |
void |
setTimestamp(int parameterIndex,
Timestamp x,
Calendar cal) |
void |
setTimestamp(String parameterName,
Timestamp x) |
void |
setTimestamp(String parameterName,
Timestamp x,
Calendar cal) |
void |
setUnicodeStream(int parameterIndex,
InputStream x,
int length)
Deprecated.
|
void |
setURL(int parameterIndex,
URL x) |
void |
setURL(String parameterName,
URL val) |
void |
setWantsGeneratedKeys(boolean wantsGeneratedKeys) |
<T> T |
unwrap(Class<T> iface) |
boolean |
wasNull() |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
addBatch, clearParameters, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL
addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
isWrapperFor, unwrap
protected static final String CACHED_STATEMENT_PREFIX
protected static final String NO_CACHE_STATEMENT_PREFIX
public boolean execute() throws SQLException
execute
in interface PreparedStatement
SQLException
public void registerOutParameter(int parameterIndex, int sqlType) throws SQLException
registerOutParameter
in interface CallableStatement
SQLException
public void registerOutParameter(int parameterIndex, int sqlType, int scale) throws SQLException
registerOutParameter
in interface CallableStatement
SQLException
public void registerOutParameter(int parameterIndex, int sqlType, String typeName) throws SQLException
registerOutParameter
in interface CallableStatement
SQLException
public void registerOutParameter(String parameterName, int sqlType) throws SQLException
registerOutParameter
in interface CallableStatement
SQLException
public void registerOutParameter(String parameterName, int sqlType, int scale) throws SQLException
registerOutParameter
in interface CallableStatement
SQLException
public void registerOutParameter(String parameterName, int sqlType, String typeName) throws SQLException
registerOutParameter
in interface CallableStatement
SQLException
public boolean wasNull() throws SQLException
wasNull
in interface CallableStatement
SQLException
public String getString(int parameterIndex) throws SQLException
getString
in interface CallableStatement
SQLException
public boolean getBoolean(int parameterIndex) throws SQLException
getBoolean
in interface CallableStatement
SQLException
public byte getByte(int parameterIndex) throws SQLException
getByte
in interface CallableStatement
SQLException
public short getShort(int parameterIndex) throws SQLException
getShort
in interface CallableStatement
SQLException
public int getInt(int parameterIndex) throws SQLException
getInt
in interface CallableStatement
SQLException
public long getLong(int parameterIndex) throws SQLException
getLong
in interface CallableStatement
SQLException
public float getFloat(int parameterIndex) throws SQLException
getFloat
in interface CallableStatement
SQLException
public double getDouble(int parameterIndex) throws SQLException
getDouble
in interface CallableStatement
SQLException
@Deprecated public BigDecimal getBigDecimal(int parameterIndex, int scale) throws SQLException
getBigDecimal
in interface CallableStatement
SQLException
public BigDecimal getBigDecimal(int parameterIndex) throws SQLException
getBigDecimal
in interface CallableStatement
SQLException
public byte[] getBytes(int parameterIndex) throws SQLException
getBytes
in interface CallableStatement
SQLException
public Date getDate(int parameterIndex) throws SQLException
getDate
in interface CallableStatement
SQLException
public Time getTime(int parameterIndex) throws SQLException
getTime
in interface CallableStatement
SQLException
public Timestamp getTimestamp(int parameterIndex) throws SQLException
getTimestamp
in interface CallableStatement
SQLException
public Date getDate(int parameterIndex, Calendar cal) throws SQLException
getDate
in interface CallableStatement
SQLException
public Time getTime(int parameterIndex, Calendar cal) throws SQLException
getTime
in interface CallableStatement
SQLException
public Timestamp getTimestamp(int parameterIndex, Calendar cal) throws SQLException
getTimestamp
in interface CallableStatement
SQLException
public Array getArray(int parameterIndex) throws SQLException
getArray
in interface CallableStatement
SQLException
public URL getURL(int parameterIndex) throws SQLException
getURL
in interface CallableStatement
SQLException
public Reader getCharacterStream(int parameterIndex) throws SQLException
getCharacterStream
in interface CallableStatement
SQLException
public Blob getBlob(int parameterIndex) throws SQLException
getBlob
in interface CallableStatement
SQLException
public Clob getClob(int parameterIndex) throws SQLException
getClob
in interface CallableStatement
SQLException
public SQLXML getSQLXML(int parameterIndex) throws SQLException
getSQLXML
in interface CallableStatement
SQLException
public Object getObject(int parameterIndex) throws SQLException
getObject
in interface CallableStatement
SQLException
public Object getObject(int parameterIndex, Map<String,Class<?>> map) throws SQLException
getObject
in interface CallableStatement
SQLException
public <T> T getObject(int parameterIndex, Class<T> type) throws SQLException
getObject
in interface CallableStatement
SQLException
public RowId getRowId(int parameterIndex) throws SQLException
getRowId
in interface CallableStatement
SQLException
public Ref getRef(int parameterIndex) throws SQLException
getRef
in interface CallableStatement
SQLException
public NClob getNClob(int parameterIndex) throws SQLException
getNClob
in interface CallableStatement
SQLException
public String getNString(int parameterIndex) throws SQLException
getNString
in interface CallableStatement
SQLException
public Reader getNCharacterStream(int parameterIndex) throws SQLException
getNCharacterStream
in interface CallableStatement
SQLException
public String getString(String parameterName) throws SQLException
getString
in interface CallableStatement
SQLException
public boolean getBoolean(String parameterName) throws SQLException
getBoolean
in interface CallableStatement
SQLException
public byte getByte(String parameterName) throws SQLException
getByte
in interface CallableStatement
SQLException
public short getShort(String parameterName) throws SQLException
getShort
in interface CallableStatement
SQLException
public int getInt(String parameterName) throws SQLException
getInt
in interface CallableStatement
SQLException
public long getLong(String parameterName) throws SQLException
getLong
in interface CallableStatement
SQLException
public float getFloat(String parameterName) throws SQLException
getFloat
in interface CallableStatement
SQLException
public double getDouble(String parameterName) throws SQLException
getDouble
in interface CallableStatement
SQLException
public byte[] getBytes(String parameterName) throws SQLException
getBytes
in interface CallableStatement
SQLException
public Date getDate(String parameterName) throws SQLException
getDate
in interface CallableStatement
SQLException
public Time getTime(String parameterName) throws SQLException
getTime
in interface CallableStatement
SQLException
public Timestamp getTimestamp(String parameterName) throws SQLException
getTimestamp
in interface CallableStatement
SQLException
public Object getObject(String parameterName) throws SQLException
getObject
in interface CallableStatement
SQLException
public BigDecimal getBigDecimal(String parameterName) throws SQLException
getBigDecimal
in interface CallableStatement
SQLException
public Object getObject(String parameterName, Map<String,Class<?>> map) throws SQLException
getObject
in interface CallableStatement
SQLException
public Ref getRef(String parameterName) throws SQLException
getRef
in interface CallableStatement
SQLException
public Blob getBlob(String parameterName) throws SQLException
getBlob
in interface CallableStatement
SQLException
public Clob getClob(String parameterName) throws SQLException
getClob
in interface CallableStatement
SQLException
public Array getArray(String parameterName) throws SQLException
getArray
in interface CallableStatement
SQLException
public Date getDate(String parameterName, Calendar cal) throws SQLException
getDate
in interface CallableStatement
SQLException
public Time getTime(String parameterName, Calendar cal) throws SQLException
getTime
in interface CallableStatement
SQLException
public Timestamp getTimestamp(String parameterName, Calendar cal) throws SQLException
getTimestamp
in interface CallableStatement
SQLException
public URL getURL(String parameterName) throws SQLException
getURL
in interface CallableStatement
SQLException
public RowId getRowId(String parameterName) throws SQLException
getRowId
in interface CallableStatement
SQLException
public NClob getNClob(String parameterName) throws SQLException
getNClob
in interface CallableStatement
SQLException
public SQLXML getSQLXML(String parameterName) throws SQLException
getSQLXML
in interface CallableStatement
SQLException
public String getNString(String parameterName) throws SQLException
getNString
in interface CallableStatement
SQLException
public Reader getNCharacterStream(String parameterName) throws SQLException
getNCharacterStream
in interface CallableStatement
SQLException
public Reader getCharacterStream(String parameterName) throws SQLException
getCharacterStream
in interface CallableStatement
SQLException
public <T> T getObject(String parameterName, Class<T> type) throws SQLException
getObject
in interface CallableStatement
SQLException
public void setNull(String parameterName, int sqlType) throws SQLException
setNull
in interface CallableStatement
SQLException
public void setBoolean(String parameterName, boolean x) throws SQLException
setBoolean
in interface CallableStatement
SQLException
public void setByte(String parameterName, byte x) throws SQLException
setByte
in interface CallableStatement
SQLException
public void setShort(String parameterName, short x) throws SQLException
setShort
in interface CallableStatement
SQLException
public void setInt(String parameterName, int x) throws SQLException
setInt
in interface CallableStatement
SQLException
public void setLong(String parameterName, long x) throws SQLException
setLong
in interface CallableStatement
SQLException
public void setFloat(String parameterName, float x) throws SQLException
setFloat
in interface CallableStatement
SQLException
public void setDouble(String parameterName, double x) throws SQLException
setDouble
in interface CallableStatement
SQLException
public void setBigDecimal(String parameterName, BigDecimal x) throws SQLException
setBigDecimal
in interface CallableStatement
SQLException
public void setString(String parameterName, String x) throws SQLException
setString
in interface CallableStatement
SQLException
public void setBytes(String parameterName, byte[] x) throws SQLException
setBytes
in interface CallableStatement
SQLException
public void setDate(String parameterName, Date x) throws SQLException
setDate
in interface CallableStatement
SQLException
public void setTime(String parameterName, Time x) throws SQLException
setTime
in interface CallableStatement
SQLException
public void setTimestamp(String parameterName, Timestamp x) throws SQLException
setTimestamp
in interface CallableStatement
SQLException
public void setAsciiStream(String parameterName, InputStream x, int length) throws SQLException
setAsciiStream
in interface CallableStatement
SQLException
public void setBinaryStream(String parameterName, InputStream x, int length) throws SQLException
setBinaryStream
in interface CallableStatement
SQLException
public void setObject(String parameterName, Object x, int targetSqlType, int scale) throws SQLException
setObject
in interface CallableStatement
SQLException
public void setObject(String parameterName, Object x, int targetSqlType) throws SQLException
setObject
in interface CallableStatement
SQLException
public void setObject(String parameterName, Object x) throws SQLException
setObject
in interface CallableStatement
SQLException
public void setCharacterStream(String parameterName, Reader reader, int length) throws SQLException
setCharacterStream
in interface CallableStatement
SQLException
public void setDate(String parameterName, Date x, Calendar cal) throws SQLException
setDate
in interface CallableStatement
SQLException
public void setTime(String parameterName, Time x, Calendar cal) throws SQLException
setTime
in interface CallableStatement
SQLException
public void setTimestamp(String parameterName, Timestamp x, Calendar cal) throws SQLException
setTimestamp
in interface CallableStatement
SQLException
public void setNull(String parameterName, int sqlType, String typeName) throws SQLException
setNull
in interface CallableStatement
SQLException
public void setRowId(String parameterName, RowId x) throws SQLException
setRowId
in interface CallableStatement
SQLException
public void setNString(String parameterName, String value) throws SQLException
setNString
in interface CallableStatement
SQLException
public void setNCharacterStream(String parameterName, Reader value, long length) throws SQLException
setNCharacterStream
in interface CallableStatement
SQLException
public void setNClob(String parameterName, NClob value) throws SQLException
setNClob
in interface CallableStatement
SQLException
public void setClob(String parameterName, Reader reader, long length) throws SQLException
setClob
in interface CallableStatement
SQLException
public void setBlob(String parameterName, InputStream inputStream, long length) throws SQLException
setBlob
in interface CallableStatement
SQLException
public void setNClob(String parameterName, Reader reader, long length) throws SQLException
setNClob
in interface CallableStatement
SQLException
public void setBlob(String parameterName, Blob x) throws SQLException
setBlob
in interface CallableStatement
SQLException
public void setClob(String parameterName, Clob x) throws SQLException
setClob
in interface CallableStatement
SQLException
public void setSQLXML(String parameterName, SQLXML xmlObject) throws SQLException
setSQLXML
in interface CallableStatement
SQLException
public void setURL(String parameterName, URL val) throws SQLException
setURL
in interface CallableStatement
SQLException
public void setAsciiStream(String parameterName, InputStream x, long length) throws SQLException
setAsciiStream
in interface CallableStatement
SQLException
public void setBinaryStream(String parameterName, InputStream x, long length) throws SQLException
setBinaryStream
in interface CallableStatement
SQLException
public void setCharacterStream(String parameterName, Reader reader, long length) throws SQLException
setCharacterStream
in interface CallableStatement
SQLException
public void setAsciiStream(String parameterName, InputStream x) throws SQLException
setAsciiStream
in interface CallableStatement
SQLException
public void setBinaryStream(String parameterName, InputStream x) throws SQLException
setBinaryStream
in interface CallableStatement
SQLException
public void setCharacterStream(String parameterName, Reader reader) throws SQLException
setCharacterStream
in interface CallableStatement
SQLException
public void setNCharacterStream(String parameterName, Reader value) throws SQLException
setNCharacterStream
in interface CallableStatement
SQLException
public void setClob(String parameterName, Reader reader) throws SQLException
setClob
in interface CallableStatement
SQLException
public void setBlob(String parameterName, InputStream inputStream) throws SQLException
setBlob
in interface CallableStatement
SQLException
public void setNClob(String parameterName, Reader reader) throws SQLException
setNClob
in interface CallableStatement
SQLException
public boolean getWantsGeneratedKeys()
public void setWantsGeneratedKeys(boolean wantsGeneratedKeys)
public com.impossibl.postgres.jdbc.PGResultSet executeQuery() throws SQLException
executeQuery
in interface PreparedStatement
SQLException
public int executeUpdate() throws SQLException
executeUpdate
in interface PreparedStatement
SQLException
public void addBatch() throws SQLException
addBatch
in interface PreparedStatement
SQLException
public void clearBatch() throws SQLException
clearBatch
in interface Statement
SQLException
public int[] executeBatch() throws SQLException
executeBatch
in interface Statement
SQLException
public void clearParameters() throws SQLException
clearParameters
in interface PreparedStatement
SQLException
public ParameterMetaData getParameterMetaData() throws SQLException
getParameterMetaData
in interface PreparedStatement
SQLException
public ResultSetMetaData getMetaData() throws SQLException
getMetaData
in interface PreparedStatement
SQLException
public void setNull(int parameterIndex, int sqlType) throws SQLException
setNull
in interface PreparedStatement
SQLException
public void setBoolean(int parameterIndex, boolean x) throws SQLException
setBoolean
in interface PreparedStatement
SQLException
public void setByte(int parameterIndex, byte x) throws SQLException
setByte
in interface PreparedStatement
SQLException
public void setShort(int parameterIndex, short x) throws SQLException
setShort
in interface PreparedStatement
SQLException
public void setInt(int parameterIndex, int x) throws SQLException
setInt
in interface PreparedStatement
SQLException
public void setLong(int parameterIndex, long x) throws SQLException
setLong
in interface PreparedStatement
SQLException
public void setFloat(int parameterIndex, float x) throws SQLException
setFloat
in interface PreparedStatement
SQLException
public void setDouble(int parameterIndex, double x) throws SQLException
setDouble
in interface PreparedStatement
SQLException
public void setBigDecimal(int parameterIndex, BigDecimal x) throws SQLException
setBigDecimal
in interface PreparedStatement
SQLException
public void setString(int parameterIndex, String x) throws SQLException
setString
in interface PreparedStatement
SQLException
public void setBytes(int parameterIndex, byte[] x) throws SQLException
setBytes
in interface PreparedStatement
SQLException
public void setDate(int parameterIndex, Date x) throws SQLException
setDate
in interface PreparedStatement
SQLException
public void setTime(int parameterIndex, Time x) throws SQLException
setTime
in interface PreparedStatement
SQLException
public void setTimestamp(int parameterIndex, Timestamp x) throws SQLException
setTimestamp
in interface PreparedStatement
SQLException
public void setDate(int parameterIndex, Date x, Calendar cal) throws SQLException
setDate
in interface PreparedStatement
SQLException
public void setTime(int parameterIndex, Time x, Calendar cal) throws SQLException
setTime
in interface PreparedStatement
SQLException
public void setTimestamp(int parameterIndex, Timestamp x, Calendar cal) throws SQLException
setTimestamp
in interface PreparedStatement
SQLException
public void setBinaryStream(int parameterIndex, InputStream x) throws SQLException
setBinaryStream
in interface PreparedStatement
SQLException
public void setBinaryStream(int parameterIndex, InputStream x, int length) throws SQLException
setBinaryStream
in interface PreparedStatement
SQLException
public void setBinaryStream(int parameterIndex, InputStream x, long length) throws SQLException
setBinaryStream
in interface PreparedStatement
SQLException
@Deprecated public void setUnicodeStream(int parameterIndex, InputStream x, int length) throws SQLException
setUnicodeStream
in interface PreparedStatement
SQLException
public void setAsciiStream(int parameterIndex, InputStream x) throws SQLException
setAsciiStream
in interface PreparedStatement
SQLException
public void setAsciiStream(int parameterIndex, InputStream x, int length) throws SQLException
setAsciiStream
in interface PreparedStatement
SQLException
public void setAsciiStream(int parameterIndex, InputStream x, long length) throws SQLException
setAsciiStream
in interface PreparedStatement
SQLException
public void setCharacterStream(int parameterIndex, Reader reader) throws SQLException
setCharacterStream
in interface PreparedStatement
SQLException
public void setCharacterStream(int parameterIndex, Reader reader, int length) throws SQLException
setCharacterStream
in interface PreparedStatement
SQLException
public void setCharacterStream(int parameterIndex, Reader reader, long length) throws SQLException
setCharacterStream
in interface PreparedStatement
SQLException
public void setObject(int parameterIndex, Object x) throws SQLException
setObject
in interface PreparedStatement
SQLException
public void setObject(int parameterIndex, Object x, int targetSqlType) throws SQLException
setObject
in interface PreparedStatement
SQLException
public void setObject(int parameterIndex, Object x, int targetSqlType, int scaleOrLength) throws SQLException
setObject
in interface PreparedStatement
SQLException
public void setBlob(int parameterIndex, Blob x) throws SQLException
setBlob
in interface PreparedStatement
SQLException
public void setBlob(int parameterIndex, InputStream inputStream, long length) throws SQLException
setBlob
in interface PreparedStatement
SQLException
public void setBlob(int parameterIndex, InputStream inputStream) throws SQLException
setBlob
in interface PreparedStatement
SQLException
public void setClob(int parameterIndex, Clob x) throws SQLException
setClob
in interface PreparedStatement
SQLException
public void setClob(int parameterIndex, Reader reader, long length) throws SQLException
setClob
in interface PreparedStatement
SQLException
public void setClob(int parameterIndex, Reader reader) throws SQLException
setClob
in interface PreparedStatement
SQLException
public void setArray(int parameterIndex, Array x) throws SQLException
setArray
in interface PreparedStatement
SQLException
public void setNull(int parameterIndex, int sqlType, String typeName) throws SQLException
setNull
in interface PreparedStatement
SQLException
public void setURL(int parameterIndex, URL x) throws SQLException
setURL
in interface PreparedStatement
SQLException
public void setSQLXML(int parameterIndex, SQLXML xmlObject) throws SQLException
setSQLXML
in interface PreparedStatement
SQLException
public void setRowId(int parameterIndex, RowId x) throws SQLException
setRowId
in interface PreparedStatement
SQLException
public void setRef(int parameterIndex, Ref x) throws SQLException
setRef
in interface PreparedStatement
SQLException
public void setNString(int parameterIndex, String value) throws SQLException
setNString
in interface PreparedStatement
SQLException
public void setNClob(int parameterIndex, NClob value) throws SQLException
setNClob
in interface PreparedStatement
SQLException
public void setNClob(int parameterIndex, Reader reader, long length) throws SQLException
setNClob
in interface PreparedStatement
SQLException
public void setNClob(int parameterIndex, Reader reader) throws SQLException
setNClob
in interface PreparedStatement
SQLException
public void setNCharacterStream(int parameterIndex, Reader value) throws SQLException
setNCharacterStream
in interface PreparedStatement
SQLException
public void setNCharacterStream(int parameterIndex, Reader value, long length) throws SQLException
setNCharacterStream
in interface PreparedStatement
SQLException
public int executeUpdate(String sql, int autoGeneratedKeys) throws SQLException
executeUpdate
in interface Statement
SQLException
public int executeUpdate(String sql, int[] columnIndexes) throws SQLException
executeUpdate
in interface Statement
SQLException
public int executeUpdate(String sql, String[] columnNames) throws SQLException
executeUpdate
in interface Statement
SQLException
public boolean execute(String sql, int autoGeneratedKeys) throws SQLException
execute
in interface Statement
SQLException
public boolean execute(String sql, int[] columnIndexes) throws SQLException
execute
in interface Statement
SQLException
public boolean execute(String sql, String[] columnNames) throws SQLException
execute
in interface Statement
SQLException
public boolean execute(String sql) throws SQLException
execute
in interface Statement
SQLException
public ResultSet executeQuery(String sql) throws SQLException
executeQuery
in interface Statement
SQLException
public int executeUpdate(String sql) throws SQLException
executeUpdate
in interface Statement
SQLException
public void addBatch(String sql) throws SQLException
addBatch
in interface Statement
SQLException
public static void dispose(PGConnectionImpl connection, ServerObjectType objectType, String objectName) throws SQLException
objectType
- Type of object to dispose ofobjectName
- Name of the object to dispose ofSQLException
- If an error occurs during disposalpublic boolean executeSimple(String sql) throws SQLException
sql
- SQL text to executeSQLException
- If an error occurred during statement executionpublic boolean executeStatement(String statementName, List<Type> parameterTypes, List<Object> parameterValues) throws SQLException
statementName
- Name of backend statement to execute or nullparameterTypes
- List of parameter typesparameterValues
- List of parmaeter valuesSQLException
- If an error occurred durring statement executionpublic Connection getConnection() throws SQLException
getConnection
in interface Statement
SQLException
public int getResultSetType() throws SQLException
getResultSetType
in interface Statement
SQLException
public int getResultSetConcurrency() throws SQLException
getResultSetConcurrency
in interface Statement
SQLException
public int getResultSetHoldability() throws SQLException
getResultSetHoldability
in interface Statement
SQLException
public boolean isPoolable() throws SQLException
isPoolable
in interface Statement
SQLException
public void setPoolable(boolean poolable) throws SQLException
setPoolable
in interface Statement
SQLException
public boolean isCloseOnCompletion() throws SQLException
isCloseOnCompletion
in interface Statement
SQLException
public void closeOnCompletion() throws SQLException
closeOnCompletion
in interface Statement
SQLException
public int getMaxFieldSize() throws SQLException
getMaxFieldSize
in interface Statement
SQLException
public void setMaxFieldSize(int max) throws SQLException
setMaxFieldSize
in interface Statement
SQLException
public int getMaxRows() throws SQLException
getMaxRows
in interface Statement
SQLException
public void setMaxRows(int max) throws SQLException
setMaxRows
in interface Statement
SQLException
public int getFetchDirection() throws SQLException
getFetchDirection
in interface Statement
SQLException
public void setFetchDirection(int direction) throws SQLException
setFetchDirection
in interface Statement
SQLException
public int getFetchSize() throws SQLException
getFetchSize
in interface Statement
SQLException
public void setFetchSize(int rows) throws SQLException
setFetchSize
in interface Statement
SQLException
public void setEscapeProcessing(boolean enable) throws SQLException
setEscapeProcessing
in interface Statement
SQLException
public int getQueryTimeout() throws SQLException
getQueryTimeout
in interface Statement
SQLException
public void setQueryTimeout(int queryTimeout) throws SQLException
setQueryTimeout
in interface Statement
SQLException
public void setCursorName(String name) throws SQLException
setCursorName
in interface Statement
SQLException
public com.impossibl.postgres.jdbc.PGResultSet getResultSet() throws SQLException
getResultSet
in interface Statement
SQLException
public int getUpdateCount() throws SQLException
getUpdateCount
in interface Statement
SQLException
public boolean getMoreResults() throws SQLException
getMoreResults
in interface Statement
SQLException
public boolean getMoreResults(int current) throws SQLException
getMoreResults
in interface Statement
SQLException
public ResultSet getGeneratedKeys() throws SQLException
getGeneratedKeys
in interface Statement
SQLException
public void cancel() throws SQLException
cancel
in interface Statement
SQLException
public boolean isClosed() throws SQLException
isClosed
in interface Statement
SQLException
public void close() throws SQLException
close
in interface AutoCloseable
close
in interface Statement
SQLException
public SQLWarning getWarnings() throws SQLException
getWarnings
in interface Statement
SQLException
public void clearWarnings() throws SQLException
clearWarnings
in interface Statement
SQLException
public <T> T unwrap(Class<T> iface) throws SQLException
unwrap
in interface Wrapper
SQLException
public boolean isWrapperFor(Class<?> iface) throws SQLException
isWrapperFor
in interface Wrapper
SQLException
Copyright © 2013–2017 impossibl.com. All rights reserved.