Top Description Methods
org.apache.derby.iapi.jdbc

public Interface EngineCallableStatement

extends EngineStatement, CallableStatement
Known Direct Implementers
org.apache.derby.impl.jdbc.EmbedCallableStatement
Imports
java.sql.CallableStatement, .SQLException
Additional methods the engine exposes on its CallableStatement object implementations, whose signatures are not compatible with older platforms.

Method Summary

Modifier and TypeMethod and Description
public <T> T
getObject(int
the first parameter is 1, the second is 2, and so on
parameterIndex, Class<T>
Class representing the Java data type to convert the designated parameter to.
type)

Redeclares java.sql.CallableStatement.getObject.

Returns an object representing the value of OUT parameter parameterIndex and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.

public <T> T
getObject(String
the name of the parameter
parameterName, Class<T>
Class representing the Java data type to convert the designated parameter to.
type)

Redeclares java.sql.CallableStatement.getObject.

Returns an object representing the value of OUT parameter parameterName and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.

Inherited from java.sql.CallableStatement:
getArraygetArraygetBigDecimalgetBigDecimalgetBigDecimalgetBlobgetBlobgetBooleangetBooleangetBytegetBytegetBytesgetBytesgetCharacterStreamgetCharacterStreamgetClobgetClobgetDategetDategetDategetDategetDoublegetDoublegetFloatgetFloatgetIntgetIntgetLonggetLonggetNCharacterStreamgetNCharacterStreamgetNClobgetNClobgetNStringgetNStringgetObjectgetObjectgetObjectgetObjectgetRefgetRefgetRowIdgetRowIdgetShortgetShortgetSQLXMLgetSQLXMLgetStringgetStringgetTimegetTimegetTimegetTimegetTimestampgetTimestampgetTimestampgetTimestampgetURLgetURLregisterOutParameterregisterOutParameterregisterOutParameterregisterOutParameterregisterOutParameterregisterOutParameterregisterOutParameterregisterOutParameterregisterOutParameterregisterOutParameterregisterOutParameterregisterOutParametersetAsciiStreamsetAsciiStreamsetAsciiStreamsetBigDecimalsetBinaryStreamsetBinaryStreamsetBinaryStreamsetBlobsetBlobsetBlobsetBooleansetBytesetBytessetCharacterStreamsetCharacterStreamsetCharacterStreamsetClobsetClobsetClobsetDatesetDatesetDoublesetFloatsetIntsetLongsetNCharacterStreamsetNCharacterStreamsetNClobsetNClobsetNClobsetNStringsetNullsetNullsetObjectsetObjectsetObjectsetObjectsetObjectsetRowIdsetShortsetSQLXMLsetStringsetTimesetTimesetTimestampsetTimestampsetURLwasNull
Inherited from org.apache.derby.iapi.jdbc.EngineStatement:
closeOnCompletionexecuteLargeBatchexecuteLargeUpdateexecuteLargeUpdateexecuteLargeUpdateexecuteLargeUpdategetLargeMaxRowsgetLargeUpdateCountisCloseOnCompletionsetLargeMaxRows

Method Detail

getObjectback to summary
public <T> T getObject(int parameterIndex, Class<T> type) throws SQLException

Redeclares java.sql.CallableStatement.getObject.

Doc from java.sql.CallableStatement.getObject.

Returns an object representing the value of OUT parameter parameterIndex and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported. If the conversion is not supported or null is specified for the type, a SQLException is thrown.

At a minimum, an implementation must support the conversions defined in Appendix B, Table B-3 and conversion of appropriate user defined SQL types to a Java type which implements SQLData, or Struct. Additional conversions may be supported and are vendor defined.

Parameters
<T>
the type of the class modeled by this Class object
parameterIndex:int

the first parameter is 1, the second is 2, and so on

type:Class<T>

Class representing the Java data type to convert the designated parameter to.

Returns:T

an instance of type holding the OUT parameter value

Exceptions
SQLException:
if conversion is not supported, type is null or another error occurs. The getCause() method of the exception may provide a more detailed exception, for example, if a conversion error occurs
getObjectback to summary
public <T> T getObject(String parameterName, Class<T> type) throws SQLException

Redeclares java.sql.CallableStatement.getObject.

Doc from java.sql.CallableStatement.getObject.

Returns an object representing the value of OUT parameter parameterName and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported. If the conversion is not supported or null is specified for the type, a SQLException is thrown.

At a minimum, an implementation must support the conversions defined in Appendix B, Table B-3 and conversion of appropriate user defined SQL types to a Java type which implements SQLData, or Struct. Additional conversions may be supported and are vendor defined.

Parameters
<T>
the type of the class modeled by this Class object
parameterName:String

the name of the parameter

type:Class<T>

Class representing the Java data type to convert the designated parameter to.

Returns:T

an instance of type holding the OUT parameter value

Exceptions
SQLException:
if conversion is not supported, type is null or another error occurs. The getCause() method of the exception may provide a more detailed exception, for example, if a conversion error occurs