java.lang.Object

net.sourceforge.jtds.jdbc.JtdsStatement

net.sourceforge.jtds.jdbc.JtdsPreparedStatement

All Implemented Interfaces:: AutoCloseable, PreparedStatement, Statement, Wrapper

Direct Known Subclasses:: JtdsCallableStatement

public class JtdsPreparedStatement extends JtdsStatement implements 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 final NumberFormat

f

Used to format numeric values when scale is specified.

(package private) Collection

handles

Collection of handles used by this statement

private final 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 String

procName

The procedure name for CallableStatements.

private boolean

returnKeys

True to return generated keys.

protected final String

sql

The SQL statement being prepared.

protected 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

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

Constructors

Constructor

Description

JtdsPreparedStatement(JtdsConnection connection, String sql, int resultSetType, int concurrency, boolean returnKeys)

Construct a new preparedStatement object.
Method Summary

Modifier and Type

Method

Description

void

addBatch()

void

addBatch(String sql)

protected void

checkOpen()

Check that this statement is still open.

void

clearParameters()

void

close()

boolean

execute()

boolean

execute(String sql)

boolean

execute(String arg0, int arg1)

boolean

execute(String arg0, int[] arg1)

boolean

execute(String arg0, String[] arg1)

protected SQLException

executeMSBatch(int size, int executeSize, ArrayList counts)

Execute the SQL batch on a MS server.

ResultSet

executeQuery()

ResultSet

executeQuery(String sql)

protected SQLException

executeSybaseBatch(int size, int executeSize, ArrayList counts)

Execute the SQL batch on a Sybase server.

int

executeUpdate()

int

executeUpdate(String sql)

int

executeUpdate(String sql, int getKeys)

int

executeUpdate(String arg0, int[] arg1)

int

executeUpdate(String arg0, String[] arg1)

ResultSetMetaData

getMetaData()

protected ParamInfo

getParameter(int parameterIndex)

Check the supplied index and return the selected parameter.

ParameterMetaData

getParameterMetaData()

private static String

normalize(String sql, int level)

This method converts native call syntax into (hopefully) valid JDBC escape syntax.

protected static String

normalizeCall(String sql)

This method converts native call syntax into (hopefully) valid JDBC escape syntax.

protected void

notSupported(String method)

Report that user tried to call a method not supported on this type of statement.

private static boolean

openComment(String sql, int offset)

void

setArray(int arg0, Array arg1)

void

setAsciiStream(int parameterIndex, InputStream x)

void

setAsciiStream(int parameterIndex, InputStream inputStream, int length)

void

setAsciiStream(int parameterIndex, InputStream x, long length)

void

setBigDecimal(int parameterIndex, 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

setBlob(int parameterIndex, InputStream inputStream)

void

setBlob(int parameterIndex, InputStream inputStream, long length)

void

setBlob(int parameterIndex, Blob x)

void

setBoolean(int parameterIndex, boolean x)

void

setByte(int parameterIndex, byte x)

void

setBytes(int parameterIndex, 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

setClob(int parameterIndex, Reader reader)

void

setClob(int parameterIndex, Reader reader, long length)

void

setClob(int parameterIndex, Clob x)

(package private) void

setColMetaData(ColInfo[] value)

Update the cached column meta data information.

void

setDate(int parameterIndex, Date x)

void

setDate(int parameterIndex, Date x, 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, Reader value)

void

setNCharacterStream(int parameterIndex, Reader value, long length)

void

setNClob(int parameterIndex, Reader reader)

void

setNClob(int parameterIndex, Reader reader, long length)

void

setNClob(int parameterIndex, NClob value)

void

setNString(int parameterIndex, String value)

void

setNull(int parameterIndex, int sqlType)

void

setNull(int parameterIndex, 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

setObjectBase(int parameterIndex, Object x, int targetSqlType, int scale)

Generic setObject method.

protected void

setParameter(int parameterIndex, 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, Ref x)

void

setRowId(int parameterIndex, RowId x)

void

setShort(int parameterIndex, short x)

void

setSQLXML(int parameterIndex, SQLXML xmlObject)

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 inputStream, int length)

void

setURL(int parameterIndex, URL url)

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

Methods inherited from interface java.sql.Wrapper
isWrapperFor, unwrap

Field Details
- sql
  
  protected final String sql
  
  The SQL statement being prepared.
- originalSql
  
  private final String originalSql
  
  The original SQL statement provided at construction time.
- sqlWord
  
  protected String sqlWord
  
  The first SQL keyword in the SQL string.
- procName
  
  protected 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 NumberFormat f
  
  Used to format numeric values when scale is specified.
- handles
  
  Collection handles
  
  Collection of handles used by this statement
Constructor Details
- JtdsPreparedStatement
  
  JtdsPreparedStatement(JtdsConnection connection, String sql, int resultSetType, int concurrency, boolean returnKeys) throws 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:
  
  SQLException
Method Details
- toString
  
  public String toString()
  
  Returns the SQL command provided at construction time.
  
  Overrides:
  
  toString in class Object
- normalizeCall
  
  protected static String normalizeCall(String sql) throws 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:
  
  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 String normalize(String sql, int level) throws 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:
  
  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(String sql, int offset) throws SQLException
  
  Throws:
  
  SQLException
- checkOpen
  
  protected void checkOpen() throws SQLException
  
  Check that this statement is still open.
  
  Overrides:
  
  checkOpen in class JtdsStatement
  
  Throws:
  
  SQLException - if statement closed.
- notSupported
  
  protected void notSupported(String method) throws 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:
  
  SQLException
- executeMSBatch
  
  protected SQLException executeMSBatch(int size, int executeSize, ArrayList counts) throws SQLException
  
  Execute the SQL batch on a MS server.
  When running with prepareSQL=1 or 3, 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 class JtdsStatement
  
  Parameters:
  
  size - the total size of the batch
  
  executeSize - the maximum number of statements to send in one request
  
  counts - the returned update counts
  
  Returns:
  
  chained exceptions linked to a SQLException
  
  Throws:
  
  SQLException - if a serious error occurs during execution
- executeSybaseBatch
  
  protected SQLException executeSybaseBatch(int size, int executeSize, ArrayList counts) throws 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 for CallableStatements.
  
  Overrides:
  
  executeSybaseBatch in class JtdsStatement
  
  Parameters:
  
  size - the total size of the batch
  
  executeSize - the maximum number of statements to send in one request
  
  counts - the returned update counts
  
  Returns:
  
  chained exceptions linked to a SQLException
  
  Throws:
  
  SQLException - if a serious error occurs during execution
- getParameter
  
  protected ParamInfo getParameter(int parameterIndex) throws 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:
  
  SQLException - if the statement is closed; if parameterIndex is less than 0; if parameterIndex is greater than the number of parameters; if checkIfSet was true and the parameter was not set
- setObjectBase
  
  public void setObjectBase(int parameterIndex, Object x, int targetSqlType, int scale) throws 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:
  
  SQLException
- setParameter
  
  protected void setParameter(int parameterIndex, Object x, int targetSqlType, int scale, int length) throws 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:
  
  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 SQLException
  
  Specified by:
  
  close in interface AutoCloseable
  
  Specified by:
  
  close in interface Statement
  
  Overrides:
  
  close in class JtdsStatement
  
  Throws:
  
  SQLException
- executeUpdate
  
  public int executeUpdate() throws SQLException
  
  Specified by:
  
  executeUpdate in interface PreparedStatement
  
  Throws:
  
  SQLException
- addBatch
  
  public void addBatch() throws SQLException
  
  Specified by:
  
  addBatch in interface PreparedStatement
  
  Throws:
  
  SQLException
- clearParameters
  
  public void clearParameters() throws SQLException
  
  Specified by:
  
  clearParameters in interface PreparedStatement
  
  Throws:
  
  SQLException
- execute
  
  public boolean execute() throws SQLException
  
  Specified by:
  
  execute in interface PreparedStatement
  
  Throws:
  
  SQLException
- setByte
  
  public void setByte(int parameterIndex, byte x) throws SQLException
  
  Specified by:
  
  setByte in interface PreparedStatement
  
  Throws:
  
  SQLException
- setDouble
  
  public void setDouble(int parameterIndex, double x) throws SQLException
  
  Specified by:
  
  setDouble in interface PreparedStatement
  
  Throws:
  
  SQLException
- setFloat
  
  public void setFloat(int parameterIndex, float x) throws SQLException
  
  Specified by:
  
  setFloat in interface PreparedStatement
  
  Throws:
  
  SQLException
- setInt
  
  public void setInt(int parameterIndex, int x) throws SQLException
  
  Specified by:
  
  setInt in interface PreparedStatement
  
  Throws:
  
  SQLException
- setNull
  
  public void setNull(int parameterIndex, int sqlType) throws SQLException
  
  Specified by:
  
  setNull in interface PreparedStatement
  
  Throws:
  
  SQLException
- setLong
  
  public void setLong(int parameterIndex, long x) throws SQLException
  
  Specified by:
  
  setLong in interface PreparedStatement
  
  Throws:
  
  SQLException
- setShort
  
  public void setShort(int parameterIndex, short x) throws SQLException
  
  Specified by:
  
  setShort in interface PreparedStatement
  
  Throws:
  
  SQLException
- setBoolean
  
  public void setBoolean(int parameterIndex, boolean x) throws SQLException
  
  Specified by:
  
  setBoolean in interface PreparedStatement
  
  Throws:
  
  SQLException
- setBytes
  
  public void setBytes(int parameterIndex, byte[] x) throws SQLException
  
  Specified by:
  
  setBytes in interface PreparedStatement
  
  Throws:
  
  SQLException
- setAsciiStream
  
  public void setAsciiStream(int parameterIndex, InputStream inputStream, int length) throws SQLException
  
  Specified by:
  
  setAsciiStream in interface PreparedStatement
  
  Throws:
  
  SQLException
- setBinaryStream
  
  public void setBinaryStream(int parameterIndex, InputStream x, int length) throws SQLException
  
  Specified by:
  
  setBinaryStream in interface PreparedStatement
  
  Throws:
  
  SQLException
- setUnicodeStream
  
  public void setUnicodeStream(int parameterIndex, InputStream inputStream, int length) throws SQLException
  
  Specified by:
  
  setUnicodeStream in interface PreparedStatement
  
  Throws:
  
  SQLException
- setCharacterStream
  
  public void setCharacterStream(int parameterIndex, Reader reader, int length) throws SQLException
  
  Specified by:
  
  setCharacterStream in interface PreparedStatement
  
  Throws:
  
  SQLException
- setObject
  
  public void setObject(int parameterIndex, Object x) throws SQLException
  
  Specified by:
  
  setObject in interface PreparedStatement
  
  Throws:
  
  SQLException
- setObject
  
  public void setObject(int parameterIndex, Object x, int targetSqlType) throws SQLException
  
  Specified by:
  
  setObject in interface PreparedStatement
  
  Throws:
  
  SQLException
- setObject
  
  public void setObject(int parameterIndex, Object x, int targetSqlType, int scale) throws SQLException
  
  Specified by:
  
  setObject in interface PreparedStatement
  
  Throws:
  
  SQLException
- setNull
  
  public void setNull(int parameterIndex, int sqlType, String typeName) throws SQLException
  
  Specified by:
  
  setNull in interface PreparedStatement
  
  Throws:
  
  SQLException
- setString
  
  public void setString(int parameterIndex, String x) throws SQLException
  
  Specified by:
  
  setString in interface PreparedStatement
  
  Throws:
  
  SQLException
- setBigDecimal
  
  public void setBigDecimal(int parameterIndex, BigDecimal x) throws SQLException
  
  Specified by:
  
  setBigDecimal in interface PreparedStatement
  
  Throws:
  
  SQLException
- setURL
  
  public void setURL(int parameterIndex, URL url) throws SQLException
  
  Specified by:
  
  setURL in interface PreparedStatement
  
  Throws:
  
  SQLException
- setArray
  
  public void setArray(int arg0, Array arg1) throws SQLException
  
  Specified by:
  
  setArray in interface PreparedStatement
  
  Throws:
  
  SQLException
- setBlob
  
  public void setBlob(int parameterIndex, Blob x) throws SQLException
  
  Specified by:
  
  setBlob in interface PreparedStatement
  
  Throws:
  
  SQLException
- setClob
  
  public void setClob(int parameterIndex, Clob x) throws SQLException
  
  Specified by:
  
  setClob in interface PreparedStatement
  
  Throws:
  
  SQLException
- setDate
  
  public void setDate(int parameterIndex, Date x) throws SQLException
  
  Specified by:
  
  setDate in interface PreparedStatement
  
  Throws:
  
  SQLException
- getParameterMetaData
  
  public ParameterMetaData getParameterMetaData() throws SQLException
  
  Specified by:
  
  getParameterMetaData in interface PreparedStatement
  
  Throws:
  
  SQLException
- setRef
  
  public void setRef(int parameterIndex, Ref x) throws SQLException
  
  Specified by:
  
  setRef in interface PreparedStatement
  
  Throws:
  
  SQLException
- executeQuery
  
  public ResultSet executeQuery() throws SQLException
  
  Specified by:
  
  executeQuery in interface PreparedStatement
  
  Throws:
  
  SQLException
- getMetaData
  
  public ResultSetMetaData getMetaData() throws SQLException
  
  Specified by:
  
  getMetaData in interface PreparedStatement
  
  Throws:
  
  SQLException
- setTime
  
  public void setTime(int parameterIndex, Time x) throws SQLException
  
  Specified by:
  
  setTime in interface PreparedStatement
  
  Throws:
  
  SQLException
- setTimestamp
  
  public void setTimestamp(int parameterIndex, Timestamp x) throws SQLException
  
  Specified by:
  
  setTimestamp in interface PreparedStatement
  
  Throws:
  
  SQLException
- setDate
  
  public void setDate(int parameterIndex, Date x, Calendar cal) throws SQLException
  
  Specified by:
  
  setDate in interface PreparedStatement
  
  Throws:
  
  SQLException
- setTime
  
  public void setTime(int parameterIndex, Time x, Calendar cal) throws SQLException
  
  Specified by:
  
  setTime in interface PreparedStatement
  
  Throws:
  
  SQLException
- setTimestamp
  
  public void setTimestamp(int parameterIndex, Timestamp x, Calendar cal) throws SQLException
  
  Specified by:
  
  setTimestamp in interface PreparedStatement
  
  Throws:
  
  SQLException
- executeUpdate
  
  public int executeUpdate(String sql) throws SQLException
  
  Specified by:
  
  executeUpdate in interface Statement
  
  Overrides:
  
  executeUpdate in class JtdsStatement
  
  Throws:
  
  SQLException
- addBatch
  
  public void addBatch(String sql) throws SQLException
  
  Specified by:
  
  addBatch in interface Statement
  
  Overrides:
  
  addBatch in class JtdsStatement
  
  Throws:
  
  SQLException
- execute
  
  public boolean execute(String sql) throws SQLException
  
  Specified by:
  
  execute in interface Statement
  
  Overrides:
  
  execute in class JtdsStatement
  
  Throws:
  
  SQLException
- executeUpdate
  
  public int executeUpdate(String sql, int getKeys) throws SQLException
  
  Specified by:
  
  executeUpdate in interface Statement
  
  Overrides:
  
  executeUpdate in class JtdsStatement
  
  Throws:
  
  SQLException
- execute
  
  public boolean execute(String arg0, int arg1) throws SQLException
  
  Specified by:
  
  execute in interface Statement
  
  Overrides:
  
  execute in class JtdsStatement
  
  Throws:
  
  SQLException
- executeUpdate
  
  public int executeUpdate(String arg0, int[] arg1) throws SQLException
  
  Specified by:
  
  executeUpdate in interface Statement
  
  Overrides:
  
  executeUpdate in class JtdsStatement
  
  Throws:
  
  SQLException
- execute
  
  public boolean execute(String arg0, int[] arg1) throws SQLException
  
  Specified by:
  
  execute in interface Statement
  
  Overrides:
  
  execute in class JtdsStatement
  
  Throws:
  
  SQLException
- executeUpdate
  
  public int executeUpdate(String arg0, String[] arg1) throws SQLException
  
  Specified by:
  
  executeUpdate in interface Statement
  
  Overrides:
  
  executeUpdate in class JtdsStatement
  
  Throws:
  
  SQLException
- execute
  
  public boolean execute(String arg0, String[] arg1) throws SQLException
  
  Specified by:
  
  execute in interface Statement
  
  Overrides:
  
  execute in class JtdsStatement
  
  Throws:
  
  SQLException
- executeQuery
  
  public ResultSet executeQuery(String sql) throws SQLException
  
  Specified by:
  
  executeQuery in interface Statement
  
  Overrides:
  
  executeQuery in class JtdsStatement
  
  Throws:
  
  SQLException
- setAsciiStream
  
  public void setAsciiStream(int parameterIndex, InputStream x) throws SQLException
  
  Specified by:
  
  setAsciiStream in interface PreparedStatement
  
  Throws:
  
  SQLException
- setAsciiStream
  
  public void setAsciiStream(int parameterIndex, InputStream x, long length) throws SQLException
  
  Specified by:
  
  setAsciiStream in interface PreparedStatement
  
  Throws:
  
  SQLException
- setBinaryStream
  
  public void setBinaryStream(int parameterIndex, InputStream x) throws SQLException
  
  Specified by:
  
  setBinaryStream in interface PreparedStatement
  
  Throws:
  
  SQLException
- setBinaryStream
  
  public void setBinaryStream(int parameterIndex, InputStream x, long length) throws SQLException
  
  Specified by:
  
  setBinaryStream in interface PreparedStatement
  
  Throws:
  
  SQLException
- setBlob
  
  public void setBlob(int parameterIndex, InputStream inputStream) throws SQLException
  
  Specified by:
  
  setBlob in interface PreparedStatement
  
  Throws:
  
  SQLException
- setBlob
  
  public void setBlob(int parameterIndex, InputStream inputStream, long length) throws SQLException
  
  Specified by:
  
  setBlob in interface PreparedStatement
  
  Throws:
  
  SQLException
- setCharacterStream
  
  public void setCharacterStream(int parameterIndex, Reader reader) throws SQLException
  
  Specified by:
  
  setCharacterStream in interface PreparedStatement
  
  Throws:
  
  SQLException
- setCharacterStream
  
  public void setCharacterStream(int parameterIndex, Reader reader, long length) throws SQLException
  
  Specified by:
  
  setCharacterStream in interface PreparedStatement
  
  Throws:
  
  SQLException
- setClob
  
  public void setClob(int parameterIndex, Reader reader) throws SQLException
  
  Specified by:
  
  setClob in interface PreparedStatement
  
  Throws:
  
  SQLException
- setClob
  
  public void setClob(int parameterIndex, Reader reader, long length) throws SQLException
  
  Specified by:
  
  setClob in interface PreparedStatement
  
  Throws:
  
  SQLException
- setNCharacterStream
  
  public void setNCharacterStream(int parameterIndex, Reader value) throws SQLException
  
  Specified by:
  
  setNCharacterStream in interface PreparedStatement
  
  Throws:
  
  SQLException
- setNCharacterStream
  
  public void setNCharacterStream(int parameterIndex, Reader value, long length) throws SQLException
  
  Specified by:
  
  setNCharacterStream in interface PreparedStatement
  
  Throws:
  
  SQLException
- setNClob
  
  public void setNClob(int parameterIndex, NClob value) throws SQLException
  
  Specified by:
  
  setNClob in interface PreparedStatement
  
  Throws:
  
  SQLException
- setNClob
  
  public void setNClob(int parameterIndex, Reader reader) throws SQLException
  
  Specified by:
  
  setNClob in interface PreparedStatement
  
  Throws:
  
  SQLException
- setNClob
  
  public void setNClob(int parameterIndex, Reader reader, long length) throws SQLException
  
  Specified by:
  
  setNClob in interface PreparedStatement
  
  Throws:
  
  SQLException
- setNString
  
  public void setNString(int parameterIndex, String value) throws SQLException
  
  Specified by:
  
  setNString in interface PreparedStatement
  
  Throws:
  
  SQLException
- setRowId
  
  public void setRowId(int parameterIndex, RowId x) throws SQLException
  
  Specified by:
  
  setRowId in interface PreparedStatement
  
  Throws:
  
  SQLException
- setSQLXML
  
  public void setSQLXML(int parameterIndex, SQLXML xmlObject) throws SQLException
  
  Specified by:
  
  setSQLXML in interface PreparedStatement
  
  Throws:
  
  SQLException

Class JtdsPreparedStatement

Field Summary

Fields inherited from class net.sourceforge.jtds.jdbc.JtdsStatement

Fields inherited from interface java.sql.Statement

Constructor Summary

Method Summary

Methods inherited from class net.sourceforge.jtds.jdbc.JtdsStatement

Methods inherited from class java.lang.Object

Methods inherited from interface java.sql.PreparedStatement

Methods inherited from interface java.sql.Statement

Methods inherited from interface java.sql.Wrapper

Field Details

sql

originalSql

sqlWord

procName

parameters

returnKeys

paramMetaData

f

handles

Constructor Details

JtdsPreparedStatement

Method Details

toString

normalizeCall

normalize

openComment

checkOpen

notSupported

executeMSBatch

executeSybaseBatch

getParameter

setObjectBase

setParameter

setColMetaData

setParamMetaData

close

executeUpdate

addBatch

clearParameters

execute

setByte

setDouble

setFloat

setInt

setNull

setLong

setShort

setBoolean

setBytes

setAsciiStream

setBinaryStream

setUnicodeStream

setCharacterStream

setObject

setObject

setObject

setNull

setString

setBigDecimal

setURL

setArray

setBlob

setClob

setDate

getParameterMetaData

setRef

executeQuery

getMetaData

setTime

setTimestamp

setDate

setTime

setTimestamp

executeUpdate

addBatch

execute

executeUpdate

execute