public class EmbedCallableStatement extends EmbedPreparedStatement implements java.sql.CallableStatement
Modifier and Type | Field and Description |
---|---|
private boolean |
hasReturnOutputParameter |
protected boolean |
wasNull |
preparedStatement, rMetaData
applicationStatement, batchStatements, isPoolable, lcc, MaxFieldSize, maxRows, results, resultSetConcurrency, resultSetType, SQLText, timeoutMillis, updateCount
factory, localConn
Constructor and Description |
---|
EmbedCallableStatement(EmbedConnection conn,
java.lang.String sql,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability) |
Modifier and Type | Method and Description |
---|---|
void |
addBatch()
JDBC 2.0
Add a set of parameters to the batch.
|
protected void |
checkRequiresCallableStatement(Activation activation)
Check to see if a statement requires to be executed via a callable statement.
|
protected boolean |
executeStatement(Activation a,
boolean executeQuery,
boolean executeUpdate)
Execute the current statement.
|
java.math.BigDecimal |
getBigDecimal(int parameterIndex)
JDBC 2.0
Get the value of a NUMERIC parameter as a java.math.BigDecimal object.
|
java.math.BigDecimal |
getBigDecimal(int parameterIndex,
int scale)
Deprecated.
|
java.sql.Blob |
getBlob(int parameterIndex)
JDBC 2.0
Get a BLOB OUT parameter.
|
boolean |
getBoolean(int parameterIndex) |
byte |
getByte(int parameterIndex) |
byte[] |
getBytes(int parameterIndex) |
java.sql.Clob |
getClob(int parameterIndex)
JDBC 2.0
Get a CLOB OUT parameter.
|
java.sql.Date |
getDate(int parameterIndex)
Get the value of a SQL DATE parameter as a java.sql.Date object
|
java.sql.Date |
getDate(int parameterIndex,
java.util.Calendar cal) |
double |
getDouble(int parameterIndex) |
float |
getFloat(int parameterIndex) |
int |
getInt(int parameterIndex) |
long |
getLong(int parameterIndex) |
java.lang.Object |
getObject(int parameterIndex) |
short |
getShort(int parameterIndex) |
java.lang.String |
getString(int parameterIndex) |
java.sql.Time |
getTime(int parameterIndex)
Get the value of a SQL TIME parameter as a java.sql.Time object.
|
java.sql.Time |
getTime(int parameterIndex,
java.util.Calendar cal) |
java.sql.Timestamp |
getTimestamp(int parameterIndex)
Get the value of a SQL TIMESTAMP parameter as a java.sql.Timestamp
object.
|
java.sql.Timestamp |
getTimestamp(int parameterIndex,
java.util.Calendar cal) |
java.net.URL |
getURL(int parameterIndex)
JDBC 3.0
Retrieve the value of the designated JDBC DATALINK parameter as a java.net.URL object
|
java.net.URL |
getURL(java.lang.String parameterName)
JDBC 3.0
Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object
|
void |
registerOutParameter(int parameterIndex,
int sqlType) |
void |
registerOutParameter(int parameterIndex,
int sqlType,
int scale) |
void |
registerOutParameter(int parameterIndex,
int sqlType,
java.lang.String typeName)
JDBC 2.0
Derby ignores the typeName argument because UDTs don't need it.
|
void |
setURL(java.lang.String parameterName,
java.net.URL val)
JDBC 3.0
Sets the designated parameter to the given java.net.URL object.
|
boolean |
wasNull() |
addBatch, clearParameters, closeActions, dataTypeConversion, execute, execute, execute, execute, execute, executeBatchElement, executeLargeUpdate, executeQuery, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, executeUpdate, finalize, getMetaData, getParameterJDBCType, getParameterSQLType, getParms, getTypes, getVersionCounter, newEmbedResultSetMetaData, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setBrokeredConnectionControl, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL, toString, transferParameters
addWarning, cancel, checkExecStatus, checkIfInMiddleOfBatch, checkStatus, clearBatch, clearResultSets, clearWarnings, close, closeMeOnCompletion, closeOnCompletion, executeBatch, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getParameterValueSet, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getSQLText, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, processDynamicResult, resultSetClosing, setApplicationStatement, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, transferBatch
commitIfAutoCommit, commitIfNeeded, getCal, getConnectionSynchronization, getEmbedConnection, handleException, needCommit, newSQLException, newSQLException, newSQLException, restoreContextStack, restoreIntrFlagIfSeen, setupContextStack
clone, equals, getClass, hashCode, notify, notifyAll, wait, wait, wait
getArray, getArray, getBigDecimal, getBlob, getBoolean, getByte, getBytes, getCharacterStream, getCharacterStream, getClob, getDate, getDate, getDouble, getFloat, getInt, getLong, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getRef, getRef, getRowId, getRowId, getShort, getSQLXML, getSQLXML, getString, getTime, getTime, getTimestamp, getTimestamp, registerOutParameter, registerOutParameter, registerOutParameter, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp
clearParameters, execute, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL
addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
closeOnCompletion, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getLargeMaxRows, getLargeUpdateCount, getMoreResults, getResultSetHoldability, isClosed, isCloseOnCompletion, setLargeMaxRows
private boolean hasReturnOutputParameter
protected boolean wasNull
public EmbedCallableStatement(EmbedConnection conn, java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws java.sql.SQLException
java.sql.SQLException
- thrown on failureprotected void checkRequiresCallableStatement(Activation activation)
EmbedStatement
checkRequiresCallableStatement
in class EmbedStatement
protected final boolean executeStatement(Activation a, boolean executeQuery, boolean executeUpdate) throws java.sql.SQLException
EmbedStatement
executeStatement
in class EmbedPreparedStatement
java.sql.SQLException
- thrown on failure.public final void registerOutParameter(int parameterIndex, int sqlType) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.registerOutParameter(int, int)
public final void registerOutParameter(int parameterIndex, int sqlType, int scale) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.registerOutParameter(int, int)
public void registerOutParameter(int parameterIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
- if a database-access error occurs.public boolean wasNull() throws java.sql.SQLException
wasNull
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.wasNull()
public java.lang.String getString(int parameterIndex) throws java.sql.SQLException
getString
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.getString(int)
public boolean getBoolean(int parameterIndex) throws java.sql.SQLException
getBoolean
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.getBoolean(int)
public byte getByte(int parameterIndex) throws java.sql.SQLException
getByte
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.getByte(int)
public short getShort(int parameterIndex) throws java.sql.SQLException
getShort
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.getShort(int)
public int getInt(int parameterIndex) throws java.sql.SQLException
getInt
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.getInt(int)
public long getLong(int parameterIndex) throws java.sql.SQLException
getLong
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.getLong(int)
public final java.math.BigDecimal getBigDecimal(int parameterIndex) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
parameterIndex
- the first parameter is 1, the second is 2, ...java.sql.SQLException
- if a database-access error occurs.public final java.math.BigDecimal getBigDecimal(int parameterIndex, int scale) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.getBigDecimal(int, int)
public float getFloat(int parameterIndex) throws java.sql.SQLException
getFloat
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.getFloat(int)
public double getDouble(int parameterIndex) throws java.sql.SQLException
getDouble
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.getDouble(int)
public byte[] getBytes(int parameterIndex) throws java.sql.SQLException
getBytes
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.getBytes(int)
public java.sql.Date getDate(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.getDate(int)
public java.sql.Time getTime(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.getTime(int)
public java.sql.Timestamp getTimestamp(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.getTimestamp(int)
public java.sql.Date getDate(int parameterIndex) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
parameterIndex
- the first parameter is 1, the second is 2, ...java.sql.SQLException
- if a database-access error occurs.public java.sql.Time getTime(int parameterIndex) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
parameterIndex
- the first parameter is 1, the second is 2, ...java.sql.SQLException
- if a database-access error occurs.public java.sql.Timestamp getTimestamp(int parameterIndex) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
parameterIndex
- the first parameter is 1, the second is 2, ...java.sql.SQLException
- if a database-access error occurs.public final java.lang.Object getObject(int parameterIndex) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.getObject(int)
public java.net.URL getURL(int parameterIndex) throws java.sql.SQLException
getURL
in interface java.sql.CallableStatement
parameterIndex
- - the first parameter is 1, the second is 2java.sql.SQLException
- Feature not implemented for now.public void setURL(java.lang.String parameterName, java.net.URL val) throws java.sql.SQLException
setURL
in interface java.sql.CallableStatement
parameterName
- - the name of the parameterval
- - the parameter valuejava.sql.SQLException
- Feature not implemented for now.public java.net.URL getURL(java.lang.String parameterName) throws java.sql.SQLException
getURL
in interface java.sql.CallableStatement
parameterName
- - the name of the parameterjava.sql.SQLException
- Feature not implemented for now.public java.sql.Blob getBlob(int parameterIndex) throws java.sql.SQLException
getBlob
in interface java.sql.CallableStatement
parameterIndex
- the first parameter is 1, the second is 2, ...java.sql.SQLException
- if a database-access error occurs.public java.sql.Clob getClob(int parameterIndex) throws java.sql.SQLException
getClob
in interface java.sql.CallableStatement
parameterIndex
- the first parameter is 1, the second is 2, ...java.sql.SQLException
- if a database-access error occurs.public void addBatch() throws java.sql.SQLException
EmbedPreparedStatement
addBatch
in interface java.sql.PreparedStatement
addBatch
in class EmbedPreparedStatement
java.sql.SQLException
- if a database-access error occurs.Apache Derby V10.10 Internals - Copyright © 2004,2013 The Apache Software Foundation. All Rights Reserved.