executeMSBatch
protected SQLException executeMSBatch(int size,
int executeSize,
ArrayList counts)
throws SQLException
Execute the SQL batch on a MS server.
- executeMSBatch in interface JtdsPreparedStatement
size
- the total size of the batch.executeSize
- the maximum number of statements to send in one request.counts
- the returned update counts.
- Chained exceptions linked to a
SQLException
.
executeSybaseBatch
protected SQLException executeSybaseBatch(int size,
int executeSize,
ArrayList counts)
throws SQLException
Execute the SQL batch on a Sybase server.
For the rare case of CallableStatement batches each statement is executed individually. This ensures that
problems with the server reading into the middle of a statement are avoided. See bug report [1374518] for more
details.
- executeSybaseBatch in interface JtdsPreparedStatement
size
- the total size of the batchexecuteSize
- the maximum number of statements to send in one request (ignored for this version of the
method as only one statement will be sent at a time)counts
- the returned update counts
- chained exceptions linked to a
SQLException
findParameter
(package private) int findParameter(String name,
boolean set)
throws SQLException
Find a parameter by name.
name
- The name of the parameter to locate.set
- True if function is called from a set / register method.
- The parameter index as an
int
.
getArray
public Array getArray(String parameterName)
throws SQLException
getArray
public Array getArray(int parameterIndex)
throws SQLException
getBigDecimal
public BigDecimal getBigDecimal(String parameterName)
throws SQLException
getBigDecimal
public BigDecimal getBigDecimal(int parameterIndex)
throws SQLException
getBigDecimal
public BigDecimal getBigDecimal(int parameterIndex,
int scale)
throws SQLException
getBlob
public Blob getBlob(String parameterName)
throws SQLException
getBlob
public Blob getBlob(int parameterIndex)
throws SQLException
getBoolean
public boolean getBoolean(String parameterName)
throws SQLException
getBoolean
public boolean getBoolean(int parameterIndex)
throws SQLException
getByte
public byte getByte(String parameterName)
throws SQLException
getByte
public byte getByte(int parameterIndex)
throws SQLException
getBytes
public byte[] getBytes(String parameterName)
throws SQLException
getBytes
public byte[] getBytes(int parameterIndex)
throws SQLException
getClob
public Clob getClob(String parameterName)
throws SQLException
getClob
public Clob getClob(int parameterIndex)
throws SQLException
getDate
public Date getDate(String parameterName)
throws SQLException
getDate
public Date getDate(String parameterName,
Calendar cal)
throws SQLException
getDate
public Date getDate(int parameterIndex)
throws SQLException
getDate
public Date getDate(int parameterIndex,
Calendar cal)
throws SQLException
getDouble
public double getDouble(String parameterName)
throws SQLException
getDouble
public double getDouble(int parameterIndex)
throws SQLException
getFloat
public float getFloat(String parameterName)
throws SQLException
getFloat
public float getFloat(int parameterIndex)
throws SQLException
getInt
public int getInt(String parameterName)
throws SQLException
getInt
public int getInt(int parameterIndex)
throws SQLException
getLong
public long getLong(String parameterName)
throws SQLException
getLong
public long getLong(int parameterIndex)
throws SQLException
getObject
public Object getObject(String parameterName)
throws SQLException
getObject
public Object getObject(String parameterName,
Map map)
throws SQLException
getObject
public Object getObject(int parameterIndex)
throws SQLException
getObject
public Object getObject(int parameterIndex,
Map map)
throws SQLException
getOutputValue
protected Object getOutputValue(int parameterIndex)
throws SQLException
Retrieve the value of an output parameter.
parameterIndex
- the ordinal position of the parameter
- the parameter value as an
Object
getRef
public Ref getRef(String parameterName)
throws SQLException
getRef
public Ref getRef(int parameterIndex)
throws SQLException
getShort
public short getShort(String parameterName)
throws SQLException
getShort
public short getShort(int parameterIndex)
throws SQLException
getString
public String getString(String parameterName)
throws SQLException
getString
public String getString(int parameterIndex)
throws SQLException
getTime
public Time getTime(String parameterName)
throws SQLException
getTime
public Time getTime(String parameterName,
Calendar cal)
throws SQLException
getTime
public Time getTime(int parameterIndex)
throws SQLException
getTime
public Time getTime(int parameterIndex,
Calendar cal)
throws SQLException
getTimestamp
public Timestamp getTimestamp(String parameterName)
throws SQLException
getTimestamp
public Timestamp getTimestamp(String parameterName,
Calendar cal)
throws SQLException
getTimestamp
public Timestamp getTimestamp(int parameterIndex)
throws SQLException
getTimestamp
public Timestamp getTimestamp(int parameterIndex,
Calendar cal)
throws SQLException
getURL
public URL getURL(String parameterName)
throws SQLException
getURL
public URL getURL(int parameterIndex)
throws SQLException
registerOutParameter
public void registerOutParameter(String parameterName,
int sqlType)
throws SQLException
registerOutParameter
public void registerOutParameter(String parameterName,
int sqlType,
String typeName)
throws SQLException
registerOutParameter
public void registerOutParameter(String parameterName,
int sqlType,
int scale)
throws SQLException
registerOutParameter
public void registerOutParameter(int parameterIndex,
int sqlType)
throws SQLException
registerOutParameter
public void registerOutParameter(int parameterIndex,
int sqlType,
String typeName)
throws SQLException
registerOutParameter
public void registerOutParameter(int parameterIndex,
int sqlType,
int scale)
throws SQLException
setAsciiStream
public void setAsciiStream(String parameterName,
InputStream x,
int length)
throws SQLException
setBigDecimal
public void setBigDecimal(String parameterName,
BigDecimal x)
throws SQLException
setBinaryStream
public void setBinaryStream(String parameterName,
InputStream x,
int length)
throws SQLException
setBoolean
public void setBoolean(String parameterName,
boolean x)
throws SQLException
setByte
public void setByte(String parameterName,
byte x)
throws SQLException
setBytes
public void setBytes(String parameterName,
byte[] x)
throws SQLException
setCharacterStream
public void setCharacterStream(String parameterName,
Reader reader,
int length)
throws SQLException
setDate
public void setDate(String parameterName,
Date x)
throws SQLException
setDate
public void setDate(String parameterName,
Date x,
Calendar cal)
throws SQLException
setDouble
public void setDouble(String parameterName,
double x)
throws SQLException
setFloat
public void setFloat(String parameterName,
float x)
throws SQLException
setInt
public void setInt(String parameterName,
int x)
throws SQLException
setLong
public void setLong(String parameterName,
long x)
throws SQLException
setNull
public void setNull(String parameterName,
int sqlType)
throws SQLException
setNull
public void setNull(String parameterName,
int sqlType,
String typeName)
throws SQLException
setObject
public void setObject(String parameterName,
Object x)
throws SQLException
setObject
public void setObject(String parameterName,
Object x,
int targetSqlType)
throws SQLException
setObject
public void setObject(String parameterName,
Object x,
int targetSqlType,
int scale)
throws SQLException
setShort
public void setShort(String parameterName,
short x)
throws SQLException
setString
public void setString(String parameterName,
String x)
throws SQLException
setTime
public void setTime(String parameterName,
Time x)
throws SQLException
setTime
public void setTime(String parameterName,
Time x,
Calendar cal)
throws SQLException
setTimestamp
public void setTimestamp(String parameterName,
Timestamp x)
throws SQLException
setTimestamp
public void setTimestamp(String parameterName,
Timestamp x,
Calendar cal)
throws SQLException
setURL
public void setURL(String parameterName,
URL x)
throws SQLException
wasNull
public boolean wasNull()
throws SQLException