|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.ow2.jonas.dbm.internal.cm.JStatement
public class JStatement
Wrapper on a PreparedStatement. This wrapper is used to track close method in order to avoid closing the statement, and putting it instead in a pool.
Field Summary |
---|
Fields inherited from interface java.sql.Statement |
---|
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO |
Constructor Summary | |
---|---|
JStatement(PreparedStatement ps,
JManagedConnection mc,
String sql)
|
Method Summary | ||
---|---|---|
void |
addBatch()
|
|
void |
addBatch(String sql)
|
|
void |
cancel()
|
|
void |
clearBatch()
|
|
void |
clearParameters()
|
|
void |
clearWarnings()
|
|
void |
close()
|
|
boolean |
equals(Object stmt)
|
|
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()
|
|
ResultSet |
executeQuery()
|
|
ResultSet |
executeQuery(String sql)
|
|
int |
executeUpdate()
|
|
int |
executeUpdate(String sql)
|
|
int |
executeUpdate(String sql,
int autoGeneratedKeys)
|
|
int |
executeUpdate(String sql,
int[] columnIndexes)
|
|
int |
executeUpdate(String sql,
String[] columnNames)
|
|
boolean |
forceClose()
Force a close on the Prepare Statement. |
|
void |
forget()
Physically close this Statement |
|
Connection |
getConnection()
|
|
int |
getFetchDirection()
|
|
int |
getFetchSize()
|
|
ResultSet |
getGeneratedKeys()
|
|
int |
getMaxFieldSize()
|
|
int |
getMaxRows()
|
|
ResultSetMetaData |
getMetaData()
|
|
boolean |
getMoreResults()
|
|
boolean |
getMoreResults(int current)
|
|
ParameterMetaData |
getParameterMetaData()
|
|
int |
getQueryTimeout()
|
|
ResultSet |
getResultSet()
|
|
int |
getResultSetConcurrency()
|
|
int |
getResultSetHoldability()
|
|
int |
getResultSetType()
|
|
String |
getSql()
|
|
int |
getUpdateCount()
|
|
SQLWarning |
getWarnings()
|
|
int |
hashCode()
|
|
boolean |
isClosed()
Retrieves whether this Statement object has been closed. |
|
boolean |
isPoolable()
Returns a value indicating whether the Statement is poolable or not. |
|
boolean |
isWrapperFor(Class<?> iface)
Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does. |
|
void |
reuse()
|
|
void |
setArray(int i,
Array x)
|
|
void |
setAsciiStream(int parameterIndex,
InputStream x)
Sets the designated parameter to the given input stream. |
|
void |
setAsciiStream(int parameterIndex,
InputStream x,
int length)
|
|
void |
setAsciiStream(int parameterIndex,
InputStream x,
long length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
|
void |
setBigDecimal(int parameterIndex,
BigDecimal x)
|
|
void |
setBinaryStream(int parameterIndex,
InputStream x)
Sets the designated parameter to the given input stream. |
|
void |
setBinaryStream(int parameterIndex,
InputStream x,
int length)
|
|
void |
setBinaryStream(int parameterIndex,
InputStream x,
long length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
|
void |
setBlob(int i,
Blob x)
|
|
void |
setBlob(int parameterIndex,
InputStream inputStream)
Sets the designated parameter to a InputStream object. |
|
void |
setBlob(int parameterIndex,
InputStream inputStream,
long length)
Sets the designated parameter to a InputStream object. |
|
void |
setBoolean(int parameterIndex,
boolean x)
|
|
void |
setByte(int parameterIndex,
byte x)
|
|
void |
setBytes(int parameterIndex,
byte[] x)
|
|
void |
setCharacterStream(int parameterIndex,
Reader reader)
Sets the designated parameter to the given Reader object. |
|
void |
setCharacterStream(int parameterIndex,
Reader reader,
int length)
|
|
void |
setCharacterStream(int parameterIndex,
Reader reader,
long length)
Sets the designated parameter to the given Reader object, which is the given number of characters long. |
|
void |
setClob(int i,
Clob x)
|
|
void |
setClob(int parameterIndex,
Reader reader)
Sets the designated parameter to a Reader object. |
|
void |
setClob(int parameterIndex,
Reader reader,
long length)
Sets the designated parameter to a Reader object. |
|
void |
setCursorName(String name)
|
|
void |
setDate(int parameterIndex,
Date x)
|
|
void |
setDate(int parameterIndex,
Date x,
Calendar cal)
|
|
void |
setDouble(int parameterIndex,
double x)
|
|
void |
setEscapeProcessing(boolean enable)
|
|
void |
setFetchDirection(int direction)
|
|
void |
setFetchSize(int rows)
|
|
void |
setFloat(int parameterIndex,
float x)
|
|
void |
setInt(int parameterIndex,
int x)
|
|
void |
setLong(int parameterIndex,
long x)
|
|
void |
setMaxFieldSize(int max)
|
|
void |
setMaxRows(int max)
|
|
void |
setNCharacterStream(int parameterIndex,
Reader value)
Sets the designated parameter to a Reader object. |
|
void |
setNCharacterStream(int parameterIndex,
Reader value,
long length)
Sets the designated parameter to a Reader object. |
|
void |
setNClob(int parameterIndex,
NClob value)
Sets the designated parameter to a java.sql.NClob object. |
|
void |
setNClob(int parameterIndex,
Reader reader)
Sets the designated parameter to a Reader object. |
|
void |
setNClob(int parameterIndex,
Reader reader,
long length)
Sets the designated parameter to a Reader object. |
|
void |
setNString(int parameterIndex,
String value)
Sets the designated paramter to the given String object. |
|
void |
setNull(int parameterIndex,
int sqlType)
|
|
void |
setNull(int paramIndex,
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 scale)
|
|
void |
setPoolable(boolean poolable)
Requests that a Statement be pooled or not pooled. |
|
void |
setQueryTimeout(int seconds)
|
|
void |
setRef(int i,
Ref x)
|
|
void |
setRowId(int parameterIndex,
RowId x)
Sets the designated parameter to the given java.sql.RowId object. |
|
void |
setShort(int parameterIndex,
short x)
|
|
void |
setSQLXML(int parameterIndex,
SQLXML xmlObject)
Sets the designated parameter to the given java.sql.SQLXML object. |
|
void |
setString(int parameterIndex,
String x)
|
|
void |
setTime(int parameterIndex,
Time x)
|
|
void |
setTime(int parameterIndex,
Time x,
Calendar cal)
|
|
void |
setTimestamp(int parameterIndex,
Timestamp x)
|
|
void |
setTimestamp(int parameterIndex,
Timestamp x,
Calendar cal)
|
|
void |
setUnicodeStream(int parameterIndex,
InputStream x,
int length)
|
|
void |
setURL(int parameterIndex,
URL x)
|
|
|
unwrap(Class<T> iface)
Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy. |
Methods inherited from class java.lang.Object |
---|
clone, finalize, getClass, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public JStatement(PreparedStatement ps, JManagedConnection mc, String sql)
Method Detail |
---|
public String getSql()
public int hashCode()
hashCode
in class Object
public boolean equals(Object stmt)
equals
in class Object
stmt
- given statement for comparing it
public boolean forceClose()
public void reuse() throws SQLException
SQLException
public boolean isClosed()
Statement
object has been closed. A Statement
is closed if the method
close has been called on it, or if it is automatically closed.
isClosed
in interface Statement
Statement
object is closed; false if it is still open
SQLException
- if a database access error occurspublic void forget()
SQLException
public int executeUpdate() throws SQLException
executeUpdate
in interface PreparedStatement
SQLException
public void addBatch() throws SQLException
addBatch
in interface PreparedStatement
SQLException
public void clearParameters() throws SQLException
clearParameters
in interface PreparedStatement
SQLException
public boolean execute() throws SQLException
execute
in interface PreparedStatement
SQLException
public void setByte(int parameterIndex, byte x) throws SQLException
setByte
in interface PreparedStatement
SQLException
public void setDouble(int parameterIndex, double x) throws SQLException
setDouble
in interface PreparedStatement
SQLException
public void setFloat(int parameterIndex, float x) throws SQLException
setFloat
in interface PreparedStatement
SQLException
public void setInt(int parameterIndex, int x) throws SQLException
setInt
in interface PreparedStatement
SQLException
public void setNull(int parameterIndex, int sqlType) throws SQLException
setNull
in interface PreparedStatement
SQLException
public void setLong(int parameterIndex, long x) throws SQLException
setLong
in interface PreparedStatement
SQLException
public void setShort(int parameterIndex, short x) throws SQLException
setShort
in interface PreparedStatement
SQLException
public void setBoolean(int parameterIndex, boolean x) throws SQLException
setBoolean
in interface PreparedStatement
SQLException
public void setBytes(int parameterIndex, byte[] x) throws SQLException
setBytes
in interface PreparedStatement
SQLException
public void setAsciiStream(int parameterIndex, InputStream x, int length) throws SQLException
setAsciiStream
in interface PreparedStatement
SQLException
public void setBinaryStream(int parameterIndex, InputStream x, int length) throws SQLException
setBinaryStream
in interface PreparedStatement
SQLException
public void setUnicodeStream(int parameterIndex, InputStream x, int length) throws SQLException
setUnicodeStream
in interface PreparedStatement
SQLException
public void setCharacterStream(int parameterIndex, Reader reader, int 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 scale) throws SQLException
setObject
in interface PreparedStatement
SQLException
public void setNull(int paramIndex, int sqlType, String typeName) throws SQLException
setNull
in interface PreparedStatement
SQLException
public void setString(int parameterIndex, String x) throws SQLException
setString
in interface PreparedStatement
SQLException
public void setBigDecimal(int parameterIndex, BigDecimal x) throws SQLException
setBigDecimal
in interface PreparedStatement
SQLException
public void setURL(int parameterIndex, URL x) throws SQLException
setURL
in interface PreparedStatement
SQLException
public void setArray(int i, Array x) throws SQLException
setArray
in interface PreparedStatement
SQLException
public void setBlob(int i, Blob x) throws SQLException
setBlob
in interface PreparedStatement
SQLException
public void setClob(int i, Clob x) throws SQLException
setClob
in interface PreparedStatement
SQLException
public void setDate(int parameterIndex, Date x) throws SQLException
setDate
in interface PreparedStatement
SQLException
public ParameterMetaData getParameterMetaData() throws SQLException
getParameterMetaData
in interface PreparedStatement
SQLException
public void setRef(int i, Ref x) throws SQLException
setRef
in interface PreparedStatement
SQLException
public ResultSet executeQuery() throws SQLException
executeQuery
in interface PreparedStatement
SQLException
public ResultSetMetaData getMetaData() throws SQLException
getMetaData
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 int getFetchDirection() throws SQLException
getFetchDirection
in interface Statement
SQLException
public int getFetchSize() throws SQLException
getFetchSize
in interface Statement
SQLException
public int getMaxFieldSize() throws SQLException
getMaxFieldSize
in interface Statement
SQLException
public int getMaxRows() throws SQLException
getMaxRows
in interface Statement
SQLException
public int getQueryTimeout() throws SQLException
getQueryTimeout
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 int getResultSetType() throws SQLException
getResultSetType
in interface Statement
SQLException
public int getUpdateCount() throws SQLException
getUpdateCount
in interface Statement
SQLException
public void cancel() throws SQLException
cancel
in interface Statement
SQLException
public void clearBatch() throws SQLException
clearBatch
in interface Statement
SQLException
public void clearWarnings() throws SQLException
clearWarnings
in interface Statement
SQLException
public void close() throws SQLException
close
in interface Statement
SQLException
public boolean getMoreResults() throws SQLException
getMoreResults
in interface Statement
SQLException
public int[] executeBatch() throws SQLException
executeBatch
in interface Statement
SQLException
public void setFetchDirection(int direction) throws SQLException
setFetchDirection
in interface Statement
SQLException
public void setFetchSize(int rows) throws SQLException
setFetchSize
in interface Statement
SQLException
public void setMaxFieldSize(int max) throws SQLException
setMaxFieldSize
in interface Statement
SQLException
public void setMaxRows(int max) throws SQLException
setMaxRows
in interface Statement
SQLException
public void setQueryTimeout(int seconds) throws SQLException
setQueryTimeout
in interface Statement
SQLException
public boolean getMoreResults(int current) throws SQLException
getMoreResults
in interface Statement
SQLException
public void setEscapeProcessing(boolean enable) throws SQLException
setEscapeProcessing
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 void setCursorName(String name) throws SQLException
setCursorName
in interface Statement
SQLException
public boolean execute(String sql) throws SQLException
execute
in interface Statement
SQLException
public int executeUpdate(String sql, int autoGeneratedKeys) throws SQLException
executeUpdate
in interface Statement
SQLException
public boolean execute(String sql, int autoGeneratedKeys) throws SQLException
execute
in interface Statement
SQLException
public int executeUpdate(String sql, int[] columnIndexes) throws SQLException
executeUpdate
in interface Statement
SQLException
public boolean execute(String sql, int[] columnIndexes) throws SQLException
execute
in interface Statement
SQLException
public Connection getConnection() throws SQLException
getConnection
in interface Statement
SQLException
public ResultSet getGeneratedKeys() throws SQLException
getGeneratedKeys
in interface Statement
SQLException
public ResultSet getResultSet() throws SQLException
getResultSet
in interface Statement
SQLException
public SQLWarning getWarnings() throws SQLException
getWarnings
in interface Statement
SQLException
public int executeUpdate(String sql, String[] columnNames) throws SQLException
executeUpdate
in interface Statement
SQLException
public boolean execute(String sql, String[] columnNames) throws SQLException
execute
in interface Statement
SQLException
public ResultSet executeQuery(String sql) throws SQLException
executeQuery
in interface Statement
SQLException
public void setRowId(int parameterIndex, RowId x) throws SQLException
java.sql.RowId
object. The driver converts this to a SQL
ROWID
value when it sends it to the database
setRowId
in interface PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
SQLException
- if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access
error occurs or this method is called on a closed PreparedStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setNString(int parameterIndex, String value) throws SQLException
String
object. The driver converts this to a SQL NCHAR
or NVARCHAR
or LONGNVARCHAR
value (depending on the argument's size relative to the driver's
limits on NVARCHAR
values) when it sends it to the database.
setNString
in interface PreparedStatement
parameterIndex
- of the first parameter is 1, the second is 2, ...value
- the parameter value
SQLException
- if parameterIndex does not correspond to a parameter marker in the SQL statement; if the driver does
not support national character sets; if the driver can detect that a data conversion error could occur; if a database
access error occurs; or this method is called on a closed PreparedStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setNCharacterStream(int parameterIndex, Reader value, long length) throws SQLException
Reader
object. The Reader
reads the data till end-of-file is
reached. The driver does the necessary conversion from Java character format to the national character set in the database.
setNCharacterStream
in interface PreparedStatement
parameterIndex
- of the first parameter is 1, the second is 2, ...value
- the parameter valuelength
- the number of characters in the parameter data.
SQLException
- if parameterIndex does not correspond to a parameter marker in the SQL statement; if the driver does
not support national character sets; if the driver can detect that a data conversion error could occur; if a database
access error occurs; or this method is called on a closed PreparedStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setNClob(int parameterIndex, NClob value) throws SQLException
java.sql.NClob
object. The driver converts this to a SQL NCLOB
value when it sends it to the database.
setNClob
in interface PreparedStatement
parameterIndex
- of the first parameter is 1, the second is 2, ...value
- the parameter value
SQLException
- if parameterIndex does not correspond to a parameter marker in the SQL statement; if the driver does
not support national character sets; if the driver can detect that a data conversion error could occur; if a database
access error occurs; or this method is called on a closed PreparedStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setClob(int parameterIndex, Reader reader, long length) throws SQLException
Reader
object. The reader must contain the number of characters specified
by length otherwise a SQLException
will be generated when the PreparedStatement
is executed. This
method differs from the setCharacterStream (int, Reader, int)
method because it informs the driver that the
parameter value should be sent to the server as a CLOB
. When the setCharacterStream
method is
used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a
LONGVARCHAR
or a CLOB
setClob
in interface PreparedStatement
parameterIndex
- index of the first parameter is 1, the second is 2, ...reader
- An object that contains the data to set the parameter value to.length
- the number of characters in the parameter data.
SQLException
- if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access
error occurs; this method is called on a closed PreparedStatement
or if the length specified is less than
zero.
SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setBlob(int parameterIndex, InputStream inputStream, long length) throws SQLException
InputStream
object. The inputstream must contain the number of characters
specified by length otherwise a SQLException
will be generated when the PreparedStatement
is
executed. This method differs from the setBinaryStream (int, InputStream, int)
method because it informs the
driver that the parameter value should be sent to the server as a BLOB
. When the setBinaryStream
method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server
as a LONGVARBINARY
or a BLOB
setBlob
in interface PreparedStatement
parameterIndex
- index of the first parameter is 1, the second is 2, ...inputStream
- An object that contains the data to set the parameter value to.length
- the number of bytes in the parameter data.
SQLException
- if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access
error occurs; this method is called on a closed PreparedStatement
; if the length specified is less than zero
or if the number of bytes in the inputstream does not match the specfied length.
SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setNClob(int parameterIndex, Reader reader, long length) throws SQLException
Reader
object. The reader must contain the number of characters specified
by length otherwise a SQLException
will be generated when the PreparedStatement
is executed. This
method differs from the setCharacterStream (int, Reader, int)
method because it informs the driver that the
parameter value should be sent to the server as a NCLOB
. When the setCharacterStream
method is
used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a
LONGNVARCHAR
or a NCLOB
setNClob
in interface PreparedStatement
parameterIndex
- index of the first parameter is 1, the second is 2, ...reader
- An object that contains the data to set the parameter value to.length
- the number of characters in the parameter data.
SQLException
- if parameterIndex does not correspond to a parameter marker in the SQL statement; if the length
specified is less than zero; if the driver does not support national character sets; if the driver can detect that a data
conversion error could occur; if a database access error occurs or this method is called on a closed
PreparedStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setSQLXML(int parameterIndex, SQLXML xmlObject) throws SQLException
java.sql.SQLXML
object. The driver converts this to an SQL
XML
value when it sends it to the database.
setSQLXML
in interface PreparedStatement
parameterIndex
- index of the first parameter is 1, the second is 2, ...xmlObject
- a SQLXML
object that maps an SQL XML
value
SQLException
- if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access
error occurs; this method is called on a closed PreparedStatement
or the
java.xml.transform.Result
, Writer
or OutputStream
has not been closed for the
SQLXML
object
SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setAsciiStream(int parameterIndex, InputStream x, long length) throws SQLException
LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.InputStream
. Data will be read from the stream as needed until end-of-file is reached. The JDBC driver
will do any necessary conversion from ASCII to the database char format.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
setAsciiStream
in interface PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the Java input stream that contains the ASCII parameter valuelength
- the number of bytes in the stream
SQLException
- if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database
access error occurs or this method is called on a closed PreparedStatement
public void setBinaryStream(int parameterIndex, InputStream x, long length) throws SQLException
LONGVARBINARY
parameter, it may be more practical to send it via a
java.io.InputStream
object. The data will be read from the stream as needed until end-of-file is reached.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
setBinaryStream
in interface PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the java input stream which contains the binary parameter valuelength
- the number of bytes in the stream
SQLException
- if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database
access error occurs or this method is called on a closed PreparedStatement
public void setCharacterStream(int parameterIndex, Reader reader, long length) throws SQLException
Reader
object, which is the given number of characters long. When a
very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.Reader
object. The data will be read from the stream as needed until end-of-file is reached. The JDBC
driver will do any necessary conversion from UNICODE to the database char format.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
setCharacterStream
in interface PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...reader
- the java.io.Reader
object that contains the Unicode datalength
- the number of characters in the stream
SQLException
- if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database
access error occurs or this method is called on a closed PreparedStatement
public void setAsciiStream(int parameterIndex, InputStream x) throws SQLException
LONGVARCHAR
parameter, it may be more practical to send it via a java.io.InputStream
. Data will
be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII
to the database char format.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of
setAsciiStream
which takes a length parameter.
setAsciiStream
in interface PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the Java input stream that contains the ASCII parameter value
SQLException
- if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database
access error occurs or this method is called on a closed PreparedStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setBinaryStream(int parameterIndex, InputStream x) throws SQLException
LONGVARBINARY
parameter, it may be more practical to send it via a java.io.InputStream
object.
The data will be read from the stream as needed until end-of-file is reached.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of
setBinaryStream
which takes a length parameter.
setBinaryStream
in interface PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the java input stream which contains the binary parameter value
SQLException
- if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database
access error occurs or this method is called on a closed PreparedStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setCharacterStream(int parameterIndex, Reader reader) throws SQLException
Reader
object. When a very large UNICODE value is input to a
LONGVARCHAR
parameter, it may be more practical to send it via a java.io.Reader
object. The data
will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from
UNICODE to the database char format.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of
setCharacterStream
which takes a length parameter.
setCharacterStream
in interface PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...reader
- the java.io.Reader
object that contains the Unicode data
SQLException
- if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database
access error occurs or this method is called on a closed PreparedStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setNCharacterStream(int parameterIndex, Reader value) throws SQLException
Reader
object. The Reader
reads the data till end-of-file is
reached. The driver does the necessary conversion from Java character format to the national character set in the database.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of
setNCharacterStream
which takes a length parameter.
setNCharacterStream
in interface PreparedStatement
parameterIndex
- of the first parameter is 1, the second is 2, ...value
- the parameter value
SQLException
- if parameterIndex does not correspond to a parameter marker in the SQL statement; if the driver does
not support national character sets; if the driver can detect that a data conversion error could occur; if a database
access error occurs; or this method is called on a closed PreparedStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setClob(int parameterIndex, Reader reader) throws SQLException
Reader
object. This method differs from the
setCharacterStream (int, Reader)
method because it informs the driver that the parameter value should be sent
to the server as a CLOB
. When the setCharacterStream
method is used, the driver may have to do
extra work to determine whether the parameter data should be sent to the server as a LONGVARCHAR
or a
CLOB
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of
setClob
which takes a length parameter.
setClob
in interface PreparedStatement
parameterIndex
- index of the first parameter is 1, the second is 2, ...reader
- An object that contains the data to set the parameter value to.
SQLException
- if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access
error occurs; this method is called on a closed PreparedStatement
or if parameterIndex does not correspond to a
parameter marker in the SQL statement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setBlob(int parameterIndex, InputStream inputStream) throws SQLException
InputStream
object. This method differs from the
setBinaryStream (int, InputStream)
method because it informs the driver that the parameter value should be
sent to the server as a BLOB
. When the setBinaryStream
method is used, the driver may have to do
extra work to determine whether the parameter data should be sent to the server as a LONGVARBINARY
or a
BLOB
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of
setBlob
which takes a length parameter.
setBlob
in interface PreparedStatement
parameterIndex
- index of the first parameter is 1, the second is 2, ...inputStream
- An object that contains the data to set the parameter value to.
SQLException
- if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access
error occurs; this method is called on a closed PreparedStatement
or if parameterIndex does not correspond to
a parameter marker in the SQL statement,
SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setNClob(int parameterIndex, Reader reader) throws SQLException
Reader
object. This method differs from the
setCharacterStream (int, Reader)
method because it informs the driver that the parameter value should be sent
to the server as a NCLOB
. When the setCharacterStream
method is used, the driver may have to do
extra work to determine whether the parameter data should be sent to the server as a LONGNVARCHAR
or a
NCLOB
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of
setNClob
which takes a length parameter.
setNClob
in interface PreparedStatement
parameterIndex
- index of the first parameter is 1, the second is 2, ...reader
- An object that contains the data to set the parameter value to.
SQLException
- if parameterIndex does not correspond to a parameter marker in the SQL statement; if the driver does
not support national character sets; if the driver can detect that a data conversion error could occur; if a database
access error occurs or this method is called on a closed PreparedStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setPoolable(boolean poolable) throws SQLException
Statement
be pooled or not pooled. The value specified is a hint to the statement pool
implementation indicating whether the applicaiton wants the statement to be pooled. It is up to the statement pool manager
as to whether the hint is used.
The poolable value of a statement is applicable to both internal statement caches implemented by the driver and external statement caches implemented by application servers and other applications.
By default, a Statement
is not poolable when created, and a PreparedStatement
and
CallableStatement
are poolable when created.
setPoolable
in interface Statement
poolable
- requests that the statement be pooled if true and that the statement not be pooled if false
SQLException
- if this method is called on a closed Statement
public boolean isPoolable() throws SQLException
Statement
is poolable or not.
isPoolable
in interface Statement
true
if the Statement
is poolable; false
otherwise
SQLException
- if this method is called on a closed Statement
setPoolable(boolean)
public boolean isWrapperFor(Class<?> iface) throws SQLException
isWrapperFor
in interface Wrapper
iface
- a Class defining an interface.
SQLException
- if an error occurs while determining whether this is a wrapper for an object with the given interface.public <T> T unwrap(Class<T> iface) throws SQLException
unwrap
in interface Wrapper
iface
- A Class defining an interface that the result must implement.
SQLException
- If no object found that implements the interface
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |