Class JtdsPreparedStatement
- java.lang.Object
-
- net.sourceforge.jtds.jdbc.JtdsStatement
-
- net.sourceforge.jtds.jdbc.JtdsPreparedStatement
-
- All Implemented Interfaces:
java.lang.AutoCloseable
,java.sql.PreparedStatement
,java.sql.Statement
,java.sql.Wrapper
- Direct Known Subclasses:
JtdsCallableStatement
public class JtdsPreparedStatement extends JtdsStatement implements java.sql.PreparedStatement
jTDS implementation of the java.sql.PreparedStatement interface.Implementation notes:
- Generally a simple subclass of Statement mainly adding support for the setting of parameters.
- The stream logic is taken over from the work Brian did to add Blob support to the original jTDS.
- Use of Statement specific method calls eg executeQuery(sql) is blocked by this version of the driver. This is unlike the original jTDS but inline with all the other JDBC drivers that I have been able to test.
- Author:
- Brian Heineman, Mike Hutchinson, Holger Rehn
-
-
Field Summary
Fields Modifier and Type Field Description private static java.text.NumberFormat
f
Used to format numeric values when scale is specified.(package private) java.util.Collection
handles
Collection of handles used by this statementprivate java.lang.String
originalSql
The original SQL statement provided at construction time.protected ParamInfo[]
parameters
The parameter list for the call.protected ParamInfo[]
paramMetaData
The cached parameter meta data.protected java.lang.String
procName
The procedure name for CallableStatements.private boolean
returnKeys
True to return generated keys.protected java.lang.String
sql
The SQL statement being prepared.protected java.lang.String
sqlWord
The first SQL keyword in the SQL string.-
Fields inherited from class net.sourceforge.jtds.jdbc.JtdsStatement
batchValues, BOOLEAN, CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, colMetaData, connection, currentResult, cursorName, DATALINK, DEFAULT_FETCH_SIZE, escapeProcessing, EXECUTE_FAILED, fetchDirection, fetchSize, GENKEYCOL, genKeyResultSet, KEEP_CURRENT_RESULT, maxFieldSize, maxRows, messages, NO_GENERATED_KEYS, openResultSets, queryTimeout, resultQueue, resultSetConcurrency, resultSetType, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO, tds
-
-
Constructor Summary
Constructors Constructor Description JtdsPreparedStatement(JtdsConnection connection, java.lang.String sql, int resultSetType, int concurrency, boolean returnKeys)
Construct a new preparedStatement object.
-
Method Summary
All Methods Static Methods Instance Methods Concrete Methods Modifier and Type Method Description void
addBatch()
void
addBatch(java.lang.String sql)
protected void
checkOpen()
Check that this statement is still open.void
clearParameters()
void
close()
boolean
execute()
boolean
execute(java.lang.String sql)
boolean
execute(java.lang.String arg0, int arg1)
boolean
execute(java.lang.String arg0, int[] arg1)
boolean
execute(java.lang.String arg0, java.lang.String[] arg1)
protected java.sql.SQLException
executeMSBatch(int size, int executeSize, java.util.ArrayList counts)
Execute the SQL batch on a MS server.java.sql.ResultSet
executeQuery()
java.sql.ResultSet
executeQuery(java.lang.String sql)
protected java.sql.SQLException
executeSybaseBatch(int size, int executeSize, java.util.ArrayList counts)
Execute the SQL batch on a Sybase server.int
executeUpdate()
int
executeUpdate(java.lang.String sql)
int
executeUpdate(java.lang.String sql, int getKeys)
int
executeUpdate(java.lang.String arg0, int[] arg1)
int
executeUpdate(java.lang.String arg0, java.lang.String[] arg1)
java.sql.ResultSetMetaData
getMetaData()
protected ParamInfo
getParameter(int parameterIndex)
Check the supplied index and return the selected parameter.java.sql.ParameterMetaData
getParameterMetaData()
private static java.lang.String
normalize(java.lang.String sql, int level)
This method converts native call syntax into (hopefully) valid JDBC escape syntax.protected static java.lang.String
normalizeCall(java.lang.String sql)
This method converts native call syntax into (hopefully) valid JDBC escape syntax.protected void
notSupported(java.lang.String method)
Report that user tried to call a method not supported on this type of statement.private static boolean
openComment(java.lang.String sql, int offset)
void
setArray(int arg0, java.sql.Array arg1)
void
setAsciiStream(int parameterIndex, java.io.InputStream x)
void
setAsciiStream(int parameterIndex, java.io.InputStream inputStream, int length)
void
setAsciiStream(int parameterIndex, java.io.InputStream x, long length)
void
setBigDecimal(int parameterIndex, java.math.BigDecimal x)
void
setBinaryStream(int parameterIndex, java.io.InputStream x)
void
setBinaryStream(int parameterIndex, java.io.InputStream x, int length)
void
setBinaryStream(int parameterIndex, java.io.InputStream x, long length)
void
setBlob(int parameterIndex, java.io.InputStream inputStream)
void
setBlob(int parameterIndex, java.io.InputStream inputStream, long length)
void
setBlob(int parameterIndex, java.sql.Blob x)
void
setBoolean(int parameterIndex, boolean x)
void
setByte(int parameterIndex, byte x)
void
setBytes(int parameterIndex, byte[] x)
void
setCharacterStream(int parameterIndex, java.io.Reader reader)
void
setCharacterStream(int parameterIndex, java.io.Reader reader, int length)
void
setCharacterStream(int parameterIndex, java.io.Reader reader, long length)
void
setClob(int parameterIndex, java.io.Reader reader)
void
setClob(int parameterIndex, java.io.Reader reader, long length)
void
setClob(int parameterIndex, java.sql.Clob x)
(package private) void
setColMetaData(ColInfo[] value)
Update the cached column meta data information.void
setDate(int parameterIndex, java.sql.Date x)
void
setDate(int parameterIndex, java.sql.Date x, java.util.Calendar cal)
void
setDouble(int parameterIndex, double x)
void
setFloat(int parameterIndex, float x)
void
setInt(int parameterIndex, int x)
void
setLong(int parameterIndex, long x)
void
setNCharacterStream(int parameterIndex, java.io.Reader value)
void
setNCharacterStream(int parameterIndex, java.io.Reader value, long length)
void
setNClob(int parameterIndex, java.io.Reader reader)
void
setNClob(int parameterIndex, java.io.Reader reader, long length)
void
setNClob(int parameterIndex, java.sql.NClob value)
void
setNString(int parameterIndex, java.lang.String value)
void
setNull(int parameterIndex, int sqlType)
void
setNull(int parameterIndex, int sqlType, java.lang.String typeName)
void
setObject(int parameterIndex, java.lang.Object x)
void
setObject(int parameterIndex, java.lang.Object x, int targetSqlType)
void
setObject(int parameterIndex, java.lang.Object x, int targetSqlType, int scale)
void
setObjectBase(int parameterIndex, java.lang.Object x, int targetSqlType, int scale)
Generic setObject method.protected void
setParameter(int parameterIndex, java.lang.Object x, int targetSqlType, int scale, int length)
Update the ParamInfo object for the specified parameter.(package private) void
setParamMetaData(ParamInfo[] value)
Update the cached parameter meta data information.void
setRef(int parameterIndex, java.sql.Ref x)
void
setRowId(int parameterIndex, java.sql.RowId x)
void
setShort(int parameterIndex, short x)
void
setSQLXML(int parameterIndex, java.sql.SQLXML xmlObject)
void
setString(int parameterIndex, java.lang.String x)
void
setTime(int parameterIndex, java.sql.Time x)
void
setTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal)
void
setTimestamp(int parameterIndex, java.sql.Timestamp x)
void
setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal)
void
setUnicodeStream(int parameterIndex, java.io.InputStream inputStream, int length)
void
setURL(int parameterIndex, java.net.URL url)
java.lang.String
toString()
Returns the SQL command provided at construction time.-
Methods inherited from class net.sourceforge.jtds.jdbc.JtdsStatement
addWarning, cacheResults, cancel, checkCursorException, clearBatch, clearWarnings, closeAllResultSets, closeCurrentResultSet, closeOnCompletion, executeBatch, executeSQL, executeSQLQuery, finalize, getConnection, getDefaultFetchSize, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMessages, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getTds, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, notImplemented, reset, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, unwrap, useCursor
-
Methods inherited from class java.lang.Object
clone, equals, getClass, hashCode, notify, notifyAll, wait, wait, wait
-
Methods inherited from interface java.sql.PreparedStatement
executeLargeUpdate, setObject, setObject
-
Methods inherited from interface java.sql.Statement
cancel, clearBatch, clearWarnings, closeOnCompletion, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, executeBatch, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isSimpleIdentifier, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
-
-
-
-
Field Detail
-
sql
protected final java.lang.String sql
The SQL statement being prepared.
-
originalSql
private final java.lang.String originalSql
The original SQL statement provided at construction time.
-
sqlWord
protected java.lang.String sqlWord
The first SQL keyword in the SQL string.
-
procName
protected java.lang.String procName
The procedure name for CallableStatements.
-
parameters
protected ParamInfo[] parameters
The parameter list for the call.
-
returnKeys
private boolean returnKeys
True to return generated keys.
-
paramMetaData
protected ParamInfo[] paramMetaData
The cached parameter meta data.
-
f
private static final java.text.NumberFormat f
Used to format numeric values when scale is specified.
-
handles
java.util.Collection handles
Collection of handles used by this statement
-
-
Constructor Detail
-
JtdsPreparedStatement
JtdsPreparedStatement(JtdsConnection connection, java.lang.String sql, int resultSetType, int concurrency, boolean returnKeys) throws java.sql.SQLException
Construct a new preparedStatement object.- Parameters:
connection
- The parent connection.sql
- The SQL statement to prepare.resultSetType
- The result set type eg SCROLLABLE etc.concurrency
- The result set concurrency eg READONLY.returnKeys
- True if generated keys should be returned.- Throws:
java.sql.SQLException
-
-
Method Detail
-
toString
public java.lang.String toString()
Returns the SQL command provided at construction time.- Overrides:
toString
in classjava.lang.Object
-
normalizeCall
protected static java.lang.String normalizeCall(java.lang.String sql) throws java.sql.SQLException
This method converts native call syntax into (hopefully) valid JDBC escape syntax.
Note: This method is required for backwards compatibility with previous versions of jTDS. Strictly speaking only the JDBC syntax needs to be recognized, constructions such as "?=#testproc ?,?" are neither valid native syntax nor valid escapes. All the substrings and trims below are not as bad as they look. The objects created all refer back to the original SQL string it is just the start and length positions which change.
- Parameters:
sql
- the SQL statement to process- Returns:
- the SQL, possibly in original form
- Throws:
java.sql.SQLException
- if the SQL statement is detected to be a normal SQL INSERT, UPDATE or DELETE statement instead of a procedure call
-
normalize
private static java.lang.String normalize(java.lang.String sql, int level) throws java.sql.SQLException
This method converts native call syntax into (hopefully) valid JDBC escape syntax.
Note: This method is required for backwards compatibility with previous versions of jTDS. Strictly speaking only the JDBC syntax needs to be recognized, constructions such as "?=#testproc ?,?" are neither valid native syntax nor valid escapes. All the substrings and trims below are not as bad as they look. The objects created all refer back to the original SQL string it is just the start and length positions which change.
- Parameters:
sql
- the SQL statement to process- Returns:
- the SQL, possibly in original form
- Throws:
java.sql.SQLException
- if the SQL statement is detected to be a normal SQL INSERT, UPDATE or DELETE statement instead of a procedure call
-
openComment
private static boolean openComment(java.lang.String sql, int offset) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
checkOpen
protected void checkOpen() throws java.sql.SQLException
Check that this statement is still open.- Overrides:
checkOpen
in classJtdsStatement
- Throws:
java.sql.SQLException
- if statement closed.
-
notSupported
protected void notSupported(java.lang.String method) throws java.sql.SQLException
Report that user tried to call a method not supported on this type of statement.- Parameters:
method
- The method name to report in the error message.- Throws:
java.sql.SQLException
-
executeMSBatch
protected java.sql.SQLException executeMSBatch(int size, int executeSize, java.util.ArrayList counts) throws java.sql.SQLException
Execute the SQL batch on a MS server. When running withprepareSQL=1
or3
, the driver will first prepare temporary stored procedures or statements for each parameter combination found in the batch. The handles to these pre-preared statements will then be used to execute the actual batch statements.- Overrides:
executeMSBatch
in classJtdsStatement
- Parameters:
size
- the total size of the batchexecuteSize
- the maximum number of statements to send in one requestcounts
- the returned update counts- Returns:
- chained exceptions linked to a
SQLException
- Throws:
java.sql.SQLException
- if a serious error occurs during execution
-
executeSybaseBatch
protected java.sql.SQLException executeSybaseBatch(int size, int executeSize, java.util.ArrayList counts) throws java.sql.SQLException
Execute the SQL batch on a Sybase server. Sybase needs to have the SQL concatenated into one TDS language packet followed by up to 1000 parameters. This method will be overridden forCallableStatements
.- Overrides:
executeSybaseBatch
in classJtdsStatement
- Parameters:
size
- the total size of the batchexecuteSize
- the maximum number of statements to send in one requestcounts
- the returned update counts- Returns:
- chained exceptions linked to a
SQLException
- Throws:
java.sql.SQLException
- if a serious error occurs during execution
-
getParameter
protected ParamInfo getParameter(int parameterIndex) throws java.sql.SQLException
Check the supplied index and return the selected parameter.- Parameters:
parameterIndex
- the parameter index 1 to n.- Returns:
- the parameter as a
ParamInfo
object. - Throws:
java.sql.SQLException
- if the statement is closed; ifparameterIndex
is less than 0; ifparameterIndex
is greater than the number of parameters; ifcheckIfSet
wastrue
and the parameter was not set
-
setObjectBase
public void setObjectBase(int parameterIndex, java.lang.Object x, int targetSqlType, int scale) throws java.sql.SQLException
Generic setObject method.- Parameters:
parameterIndex
- Parameter index 1 to n.x
- The value to set.targetSqlType
- The java.sql.Types constant describing the data.scale
- The decimal scale -1 if not set.- Throws:
java.sql.SQLException
-
setParameter
protected void setParameter(int parameterIndex, java.lang.Object x, int targetSqlType, int scale, int length) throws java.sql.SQLException
Update the ParamInfo object for the specified parameter.- Parameters:
parameterIndex
- Parameter index 1 to n.x
- The value to set.targetSqlType
- The java.sql.Types constant describing the data.scale
- The decimal scale -1 if not set.length
- The length of the data item.- Throws:
java.sql.SQLException
-
setColMetaData
void setColMetaData(ColInfo[] value)
Update the cached column meta data information.- Parameters:
value
- The Column meta data array.
-
setParamMetaData
void setParamMetaData(ParamInfo[] value)
Update the cached parameter meta data information.- Parameters:
value
- The Column meta data array.
-
close
public void close() throws java.sql.SQLException
- Specified by:
close
in interfacejava.lang.AutoCloseable
- Specified by:
close
in interfacejava.sql.Statement
- Overrides:
close
in classJtdsStatement
- Throws:
java.sql.SQLException
-
executeUpdate
public int executeUpdate() throws java.sql.SQLException
- Specified by:
executeUpdate
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
addBatch
public void addBatch() throws java.sql.SQLException
- Specified by:
addBatch
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
clearParameters
public void clearParameters() throws java.sql.SQLException
- Specified by:
clearParameters
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
execute
public boolean execute() throws java.sql.SQLException
- Specified by:
execute
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setByte
public void setByte(int parameterIndex, byte x) throws java.sql.SQLException
- Specified by:
setByte
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setDouble
public void setDouble(int parameterIndex, double x) throws java.sql.SQLException
- Specified by:
setDouble
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setFloat
public void setFloat(int parameterIndex, float x) throws java.sql.SQLException
- Specified by:
setFloat
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setInt
public void setInt(int parameterIndex, int x) throws java.sql.SQLException
- Specified by:
setInt
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setNull
public void setNull(int parameterIndex, int sqlType) throws java.sql.SQLException
- Specified by:
setNull
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setLong
public void setLong(int parameterIndex, long x) throws java.sql.SQLException
- Specified by:
setLong
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setShort
public void setShort(int parameterIndex, short x) throws java.sql.SQLException
- Specified by:
setShort
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setBoolean
public void setBoolean(int parameterIndex, boolean x) throws java.sql.SQLException
- Specified by:
setBoolean
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setBytes
public void setBytes(int parameterIndex, byte[] x) throws java.sql.SQLException
- Specified by:
setBytes
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setAsciiStream
public void setAsciiStream(int parameterIndex, java.io.InputStream inputStream, int length) throws java.sql.SQLException
- Specified by:
setAsciiStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(int parameterIndex, java.io.InputStream x, int length) throws java.sql.SQLException
- Specified by:
setBinaryStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setUnicodeStream
public void setUnicodeStream(int parameterIndex, java.io.InputStream inputStream, int length) throws java.sql.SQLException
- Specified by:
setUnicodeStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(int parameterIndex, java.io.Reader reader, int length) throws java.sql.SQLException
- Specified by:
setCharacterStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(int parameterIndex, java.lang.Object x) throws java.sql.SQLException
- Specified by:
setObject
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(int parameterIndex, java.lang.Object x, int targetSqlType) throws java.sql.SQLException
- Specified by:
setObject
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(int parameterIndex, java.lang.Object x, int targetSqlType, int scale) throws java.sql.SQLException
- Specified by:
setObject
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setNull
public void setNull(int parameterIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException
- Specified by:
setNull
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setString
public void setString(int parameterIndex, java.lang.String x) throws java.sql.SQLException
- Specified by:
setString
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setBigDecimal
public void setBigDecimal(int parameterIndex, java.math.BigDecimal x) throws java.sql.SQLException
- Specified by:
setBigDecimal
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setURL
public void setURL(int parameterIndex, java.net.URL url) throws java.sql.SQLException
- Specified by:
setURL
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setArray
public void setArray(int arg0, java.sql.Array arg1) throws java.sql.SQLException
- Specified by:
setArray
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setBlob
public void setBlob(int parameterIndex, java.sql.Blob x) throws java.sql.SQLException
- Specified by:
setBlob
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setClob
public void setClob(int parameterIndex, java.sql.Clob x) throws java.sql.SQLException
- Specified by:
setClob
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setDate
public void setDate(int parameterIndex, java.sql.Date x) throws java.sql.SQLException
- Specified by:
setDate
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
getParameterMetaData
public java.sql.ParameterMetaData getParameterMetaData() throws java.sql.SQLException
- Specified by:
getParameterMetaData
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setRef
public void setRef(int parameterIndex, java.sql.Ref x) throws java.sql.SQLException
- Specified by:
setRef
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
executeQuery
public java.sql.ResultSet executeQuery() throws java.sql.SQLException
- Specified by:
executeQuery
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
getMetaData
public java.sql.ResultSetMetaData getMetaData() throws java.sql.SQLException
- Specified by:
getMetaData
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setTime
public void setTime(int parameterIndex, java.sql.Time x) throws java.sql.SQLException
- Specified by:
setTime
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setTimestamp
public void setTimestamp(int parameterIndex, java.sql.Timestamp x) throws java.sql.SQLException
- Specified by:
setTimestamp
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setDate
public void setDate(int parameterIndex, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
setDate
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setTime
public void setTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
setTime
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setTimestamp
public void setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
setTimestamp
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
executeUpdate
public int executeUpdate(java.lang.String sql) throws java.sql.SQLException
- Specified by:
executeUpdate
in interfacejava.sql.Statement
- Overrides:
executeUpdate
in classJtdsStatement
- Throws:
java.sql.SQLException
-
addBatch
public void addBatch(java.lang.String sql) throws java.sql.SQLException
- Specified by:
addBatch
in interfacejava.sql.Statement
- Overrides:
addBatch
in classJtdsStatement
- Throws:
java.sql.SQLException
-
execute
public boolean execute(java.lang.String sql) throws java.sql.SQLException
- Specified by:
execute
in interfacejava.sql.Statement
- Overrides:
execute
in classJtdsStatement
- Throws:
java.sql.SQLException
-
executeUpdate
public int executeUpdate(java.lang.String sql, int getKeys) throws java.sql.SQLException
- Specified by:
executeUpdate
in interfacejava.sql.Statement
- Overrides:
executeUpdate
in classJtdsStatement
- Throws:
java.sql.SQLException
-
execute
public boolean execute(java.lang.String arg0, int arg1) throws java.sql.SQLException
- Specified by:
execute
in interfacejava.sql.Statement
- Overrides:
execute
in classJtdsStatement
- Throws:
java.sql.SQLException
-
executeUpdate
public int executeUpdate(java.lang.String arg0, int[] arg1) throws java.sql.SQLException
- Specified by:
executeUpdate
in interfacejava.sql.Statement
- Overrides:
executeUpdate
in classJtdsStatement
- Throws:
java.sql.SQLException
-
execute
public boolean execute(java.lang.String arg0, int[] arg1) throws java.sql.SQLException
- Specified by:
execute
in interfacejava.sql.Statement
- Overrides:
execute
in classJtdsStatement
- Throws:
java.sql.SQLException
-
executeUpdate
public int executeUpdate(java.lang.String arg0, java.lang.String[] arg1) throws java.sql.SQLException
- Specified by:
executeUpdate
in interfacejava.sql.Statement
- Overrides:
executeUpdate
in classJtdsStatement
- Throws:
java.sql.SQLException
-
execute
public boolean execute(java.lang.String arg0, java.lang.String[] arg1) throws java.sql.SQLException
- Specified by:
execute
in interfacejava.sql.Statement
- Overrides:
execute
in classJtdsStatement
- Throws:
java.sql.SQLException
-
executeQuery
public java.sql.ResultSet executeQuery(java.lang.String sql) throws java.sql.SQLException
- Specified by:
executeQuery
in interfacejava.sql.Statement
- Overrides:
executeQuery
in classJtdsStatement
- Throws:
java.sql.SQLException
-
setAsciiStream
public void setAsciiStream(int parameterIndex, java.io.InputStream x) throws java.sql.SQLException
- Specified by:
setAsciiStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setAsciiStream
public void setAsciiStream(int parameterIndex, java.io.InputStream x, long length) throws java.sql.SQLException
- Specified by:
setAsciiStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(int parameterIndex, java.io.InputStream x) throws java.sql.SQLException
- Specified by:
setBinaryStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(int parameterIndex, java.io.InputStream x, long length) throws java.sql.SQLException
- Specified by:
setBinaryStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setBlob
public void setBlob(int parameterIndex, java.io.InputStream inputStream) throws java.sql.SQLException
- Specified by:
setBlob
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setBlob
public void setBlob(int parameterIndex, java.io.InputStream inputStream, long length) throws java.sql.SQLException
- Specified by:
setBlob
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(int parameterIndex, java.io.Reader reader) throws java.sql.SQLException
- Specified by:
setCharacterStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(int parameterIndex, java.io.Reader reader, long length) throws java.sql.SQLException
- Specified by:
setCharacterStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setClob
public void setClob(int parameterIndex, java.io.Reader reader) throws java.sql.SQLException
- Specified by:
setClob
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setClob
public void setClob(int parameterIndex, java.io.Reader reader, long length) throws java.sql.SQLException
- Specified by:
setClob
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setNCharacterStream
public void setNCharacterStream(int parameterIndex, java.io.Reader value) throws java.sql.SQLException
- Specified by:
setNCharacterStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setNCharacterStream
public void setNCharacterStream(int parameterIndex, java.io.Reader value, long length) throws java.sql.SQLException
- Specified by:
setNCharacterStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setNClob
public void setNClob(int parameterIndex, java.sql.NClob value) throws java.sql.SQLException
- Specified by:
setNClob
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setNClob
public void setNClob(int parameterIndex, java.io.Reader reader) throws java.sql.SQLException
- Specified by:
setNClob
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setNClob
public void setNClob(int parameterIndex, java.io.Reader reader, long length) throws java.sql.SQLException
- Specified by:
setNClob
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setNString
public void setNString(int parameterIndex, java.lang.String value) throws java.sql.SQLException
- Specified by:
setNString
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setRowId
public void setRowId(int parameterIndex, java.sql.RowId x) throws java.sql.SQLException
- Specified by:
setRowId
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setSQLXML
public void setSQLXML(int parameterIndex, java.sql.SQLXML xmlObject) throws java.sql.SQLException
- Specified by:
setSQLXML
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
-