APIdia Launch Partner
Top Fields Constructors Methods
net.ucanaccess.jdbc

public Class UcanaccessCallableStatement

extends UcanaccessPreparedStatement
implements CallableStatement
Class Inheritance
All Implemented Interfaces
java.sql.CallableStatement, java.sql.PreparedStatement, java.sql.Statement, java.lang.AutoCloseable, java.sql.Wrapper
Imports
net.ucanaccess.exception.UcanaccessSQLException, java.io.InputStream, .Reader, java.math.BigDecimal, java.net.URL, java.sql.*, java.util.Calendar, .Map

Field Summary

Modifier and TypeField and Description
private CallableStatement
hidden

Constructor Summary

AccessConstructor and Description
public
UcanaccessCallableStatement(NormalizedSQL nsql, CallableStatement hidden, UcanaccessConnection connection)

Method Summary

Modifier and TypeMethod and Description
public boolean
execute()

Overrides net.ucanaccess.jdbc.UcanaccessPreparedStatement.execute.

Implements java.sql.PreparedStatement.execute.

Executes the SQL statement in this PreparedStatement object, which may be any kind of SQL statement.

public int
executeUpdate()

Overrides net.ucanaccess.jdbc.UcanaccessPreparedStatement.executeUpdate.

Implements java.sql.PreparedStatement.executeUpdate.

Executes the SQL statement in this PreparedStatement object, which must be an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.

public Array
getArray(int parmIdx)

Implements java.sql.CallableStatement.getArray.

Retrieves the value of the designated JDBC ARRAY parameter as an java.sql.Array object in the Java programming language.

public Array
getArray(String parmName)

Implements java.sql.CallableStatement.getArray.

Retrieves the value of a JDBC ARRAY parameter as an java.sql.Array object in the Java programming language.

public BigDecimal
getBigDecimal(int parmIdx, int scale)

Implements java.sql.CallableStatement.getBigDecimal.

Retrieves the value of the designated JDBC NUMERIC parameter as a java.math.BigDecimal object with scale digits to the right of the decimal point.

public BigDecimal
getBigDecimal(int parmIdx)

Implements java.sql.CallableStatement.getBigDecimal.

Retrieves the value of the designated JDBC NUMERIC parameter as a java.math.BigDecimal object with as many digits to the right of the decimal point as the value contains.

public BigDecimal
getBigDecimal(String parmName)

Implements java.sql.CallableStatement.getBigDecimal.

Retrieves the value of a JDBC NUMERIC parameter as a java.math.BigDecimal object with as many digits to the right of the decimal point as the value contains.

public Blob
getBlob(int parmIdx)

Implements java.sql.CallableStatement.getBlob.

Retrieves the value of the designated JDBC BLOB parameter as a java.sql.Blob object in the Java programming language.

public Blob
getBlob(String parmName)

Implements java.sql.CallableStatement.getBlob.

Retrieves the value of a JDBC BLOB parameter as a java.sql.Blob object in the Java programming language.

public boolean
getBoolean(int parmIdx)

Implements java.sql.CallableStatement.getBoolean.

Retrieves the value of the designated JDBC BIT or BOOLEAN parameter as a boolean in the Java programming language.

public boolean
getBoolean(String parmName)

Implements java.sql.CallableStatement.getBoolean.

Retrieves the value of a JDBC BIT or BOOLEAN parameter as a boolean in the Java programming language.

public byte
getByte(int parmIdx)

Implements java.sql.CallableStatement.getByte.

Retrieves the value of the designated JDBC TINYINT parameter as a byte in the Java programming language.

public byte
getByte(String parmName)

Implements java.sql.CallableStatement.getByte.

Retrieves the value of a JDBC TINYINT parameter as a byte in the Java programming language.

public byte[]
getBytes(int parmIdx)

Implements java.sql.CallableStatement.getBytes.

Retrieves the value of the designated JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language.

public byte[]
getBytes(String parmName)

Implements java.sql.CallableStatement.getBytes.

Retrieves the value of a JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language.

public Reader
getCharacterStream(int parmIdx)

Implements java.sql.CallableStatement.getCharacterStream.

Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.

public Reader
getCharacterStream(String parmName)

Implements java.sql.CallableStatement.getCharacterStream.

Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.

public Clob
getClob(int parmIdx)

Implements java.sql.CallableStatement.getClob.

Retrieves the value of the designated JDBC CLOB parameter as a java.sql.Clob object in the Java programming language.

public Clob
getClob(String parmName)

Implements java.sql.CallableStatement.getClob.

Retrieves the value of a JDBC CLOB parameter as a java.sql.Clob object in the Java programming language.

public Date
getDate(int parmIdx, Calendar cal)

Implements java.sql.CallableStatement.getDate.

Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object, using the given Calendar object to construct the date.

public Date
getDate(int parmIdx)

Implements java.sql.CallableStatement.getDate.

Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object.

public Date
getDate(String parmName, Calendar cal)

Implements java.sql.CallableStatement.getDate.

Retrieves the value of a JDBC DATE parameter as a java.sql.Date object, using the given Calendar object to construct the date.

public Date
getDate(String parmName)

Implements java.sql.CallableStatement.getDate.

Retrieves the value of a JDBC DATE parameter as a java.sql.Date object.

public double
getDouble(int parmIdx)

Implements java.sql.CallableStatement.getDouble.

Retrieves the value of the designated JDBC DOUBLE parameter as a double in the Java programming language.

public double
getDouble(String parmName)

Implements java.sql.CallableStatement.getDouble.

Retrieves the value of a JDBC DOUBLE parameter as a double in the Java programming language.

public float
getFloat(int parmIdx)

Implements java.sql.CallableStatement.getFloat.

Retrieves the value of the designated JDBC FLOAT parameter as a float in the Java programming language.

public float
getFloat(String parmName)

Implements java.sql.CallableStatement.getFloat.

Retrieves the value of a JDBC FLOAT parameter as a float in the Java programming language.

public ResultSet
getGeneratedKeys()

Overrides net.ucanaccess.jdbc.UcanaccessStatement.getGeneratedKeys.

Implements java.sql.Statement.getGeneratedKeys.

Retrieves any auto-generated keys created as a result of executing this Statement object.

public int
getInt(int parmIdx)

Implements java.sql.CallableStatement.getInt.

Retrieves the value of the designated JDBC INTEGER parameter as an int in the Java programming language.

public int
getInt(String parmName)

Implements java.sql.CallableStatement.getInt.

Retrieves the value of a JDBC INTEGER parameter as an int in the Java programming language.

public long
getLong(int parmIdx)

Implements java.sql.CallableStatement.getLong.

Retrieves the value of the designated JDBC BIGINT parameter as a long in the Java programming language.

public long
getLong(String parmName)

Implements java.sql.CallableStatement.getLong.

Retrieves the value of a JDBC BIGINT parameter as a long in the Java programming language.

public int
getMaxFieldSize()

Overrides net.ucanaccess.jdbc.UcanaccessStatement.getMaxFieldSize.

Implements java.sql.Statement.getMaxFieldSize.

Retrieves the maximum number of bytes that can be returned for character and binary column values in a ResultSet object produced by this Statement object.

public int
getMaxRows()

Overrides net.ucanaccess.jdbc.UcanaccessStatement.getMaxRows.

Implements java.sql.Statement.getMaxRows.

Retrieves the maximum number of rows that a ResultSet object produced by this Statement object can contain.

public ResultSetMetaData
getMetaData()

Overrides net.ucanaccess.jdbc.UcanaccessPreparedStatement.getMetaData.

Implements java.sql.PreparedStatement.getMetaData.

Retrieves a ResultSetMetaData object that contains information about the columns of the ResultSet object that will be returned when this PreparedStatement object is executed.

public boolean
getMoreResults()

Overrides net.ucanaccess.jdbc.UcanaccessStatement.getMoreResults.

Implements java.sql.Statement.getMoreResults.

Moves to this Statement object's next result, returns true if it is a ResultSet object, and implicitly closes any current ResultSet object(s) obtained with the method getResultSet.

public boolean
getMoreResults(int current)

Overrides net.ucanaccess.jdbc.UcanaccessStatement.getMoreResults.

Implements java.sql.Statement.getMoreResults.

Moves to this Statement object's next result, deals with any current ResultSet object(s) according to the instructions specified by the given flag, and returns true if the next result is a ResultSet object.

public Reader
getNCharacterStream(int parmIdx)

Implements java.sql.CallableStatement.getNCharacterStream.

Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.

public Reader
getNCharacterStream(String parmName)

Implements java.sql.CallableStatement.getNCharacterStream.

Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.

public NClob
getNClob(int parmIdx)

Implements java.sql.CallableStatement.getNClob.

Retrieves the value of the designated JDBC NCLOB parameter as a java.sql.NClob object in the Java programming language.

public NClob
getNClob(String parmName)

Implements java.sql.CallableStatement.getNClob.

Retrieves the value of a JDBC NCLOB parameter as a java.sql.NClob object in the Java programming language.

public String
getNString(int parmIdx)

Implements java.sql.CallableStatement.getNString.

Retrieves the value of the designated NCHAR, NVARCHAR or LONGNVARCHAR parameter as a String in the Java programming language.

public String
getNString(String parmName)

Implements java.sql.CallableStatement.getNString.

Retrieves the value of the designated NCHAR, NVARCHAR or LONGNVARCHAR parameter as a String in the Java programming language.

public Object
getObject(int parmIdx, Map<String, Class<?>> map)

Implements java.sql.CallableStatement.getObject.

Returns an object representing the value of OUT parameter parameterIndex and uses map for the custom mapping of the parameter value.

public Object
getObject(int parmIdx)

Implements java.sql.CallableStatement.getObject.

Retrieves the value of the designated parameter as an Object in the Java programming language.

public Object
getObject(String parmName, Map<String, Class<?>> map)

Implements java.sql.CallableStatement.getObject.

Returns an object representing the value of OUT parameter parameterName and uses map for the custom mapping of the parameter value.

public Object
getObject(String parmName)

Implements java.sql.CallableStatement.getObject.

Retrieves the value of a parameter as an Object in the Java programming language.

public <T> T
getObject(int parmIdx, Class<T> type)

Implements 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 parmName, Class<T> type)

Implements 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.

public Ref
getRef(int parmIdx)

Implements java.sql.CallableStatement.getRef.

Retrieves the value of the designated JDBC REF(<structured-type>) parameter as a java.sql.Ref object in the Java programming language.

public Ref
getRef(String parmName)

Implements java.sql.CallableStatement.getRef.

Retrieves the value of a JDBC REF(<structured-type>) parameter as a java.sql.Ref object in the Java programming language.

public ResultSet
getResultSet()

Overrides net.ucanaccess.jdbc.UcanaccessStatement.getResultSet.

Implements java.sql.Statement.getResultSet.

Retrieves the current result as a ResultSet object.

public RowId
getRowId(int parmIdx)

Implements java.sql.CallableStatement.getRowId.

Retrieves the value of the designated JDBC ROWID parameter as a java.sql.RowId object.

public RowId
getRowId(String parmName)

Implements java.sql.CallableStatement.getRowId.

Retrieves the value of the designated JDBC ROWID parameter as a java.sql.RowId object.

public short
getShort(int parmIdx)

Implements java.sql.CallableStatement.getShort.

Retrieves the value of the designated JDBC SMALLINT parameter as a short in the Java programming language.

public short
getShort(String parmName)

Implements java.sql.CallableStatement.getShort.

Retrieves the value of a JDBC SMALLINT parameter as a short in the Java programming language.

public SQLXML
getSQLXML(int parmIdx)

Implements java.sql.CallableStatement.getSQLXML.

Retrieves the value of the designated SQL XML parameter as a java.sql.SQLXML object in the Java programming language.

public SQLXML
getSQLXML(String parmName)

Implements java.sql.CallableStatement.getSQLXML.

Retrieves the value of the designated SQL XML parameter as a java.sql.SQLXML object in the Java programming language.

public String
getString(int parmIdx)

Implements java.sql.CallableStatement.getString.

Retrieves the value of the designated JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.

public String
getString(String parmName)

Implements java.sql.CallableStatement.getString.

Retrieves the value of a JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.

public Time
getTime(int parmIdx, Calendar cal)

Implements java.sql.CallableStatement.getTime.

Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time.

public Time
getTime(int parmIdx)

Implements java.sql.CallableStatement.getTime.

Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object.

public Time
getTime(String parmName, Calendar cal)

Implements java.sql.CallableStatement.getTime.

Retrieves the value of a JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time.

public Time
getTime(String parmName)

Implements java.sql.CallableStatement.getTime.

Retrieves the value of a JDBC TIME parameter as a java.sql.Time object.

public Timestamp
getTimestamp(int parmIdx, Calendar cal)

Implements java.sql.CallableStatement.getTimestamp.

Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object, using the given Calendar object to construct the Timestamp object.

public Timestamp
getTimestamp(int parmIdx)

Implements java.sql.CallableStatement.getTimestamp.

Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object.

public Timestamp
getTimestamp(String parmName, Calendar cal)

Implements java.sql.CallableStatement.getTimestamp.

Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object, using the given Calendar object to construct the Timestamp object.

public Timestamp
getTimestamp(String parmName)

Implements java.sql.CallableStatement.getTimestamp.

Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object.

public URL
getURL(int parmIdx)

Implements java.sql.CallableStatement.getURL.

Retrieves the value of the designated JDBC DATALINK parameter as a java.net.URL object.

public URL
getURL(String parmName)

Implements java.sql.CallableStatement.getURL.

Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object.

public void
registerOutParameter(int parmIdx, int sqlType, int scale)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the parameter in ordinal position parameterIndex to be of JDBC type sqlType.

public void
registerOutParameter(int parmIdx, int sqlType, String typeName)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the designated output parameter.

public void
registerOutParameter(int parmIdx, int sqlType)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType.

public void
registerOutParameter(String parmName, int sqlType, int scale)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the parameter named parameterName to be of JDBC type sqlType.

public void
registerOutParameter(String parmName, int sqlType, String typeName)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the designated output parameter.

public void
registerOutParameter(String parmName, int sqlType)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the OUT parameter named parameterName to the JDBC type sqlType.

public void
setAsciiStream(String parmName, InputStream x, int length)

Implements java.sql.CallableStatement.setAsciiStream.

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

public void
setAsciiStream(String parmName, InputStream x, long length)

Implements java.sql.CallableStatement.setAsciiStream.

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

public void
setAsciiStream(String parmName, InputStream x)

Implements java.sql.CallableStatement.setAsciiStream.

Sets the designated parameter to the given input stream.

public void
setBigDecimal(String parmName, BigDecimal x)

Implements java.sql.CallableStatement.setBigDecimal.

Sets the designated parameter to the given java.math.BigDecimal value.

public void
setBinaryStream(String parmName, InputStream x, int length)

Implements java.sql.CallableStatement.setBinaryStream.

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

public void
setBinaryStream(String parmName, InputStream x, long length)

Implements java.sql.CallableStatement.setBinaryStream.

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

public void
setBinaryStream(String parmName, InputStream x)

Implements java.sql.CallableStatement.setBinaryStream.

Sets the designated parameter to the given input stream.

public void
setBlob(String parmName, Blob x)

Implements java.sql.CallableStatement.setBlob.

Sets the designated parameter to the given java.sql.Blob object.

public void
setBlob(String parmName, InputStream inputStream, long length)

Implements java.sql.CallableStatement.setBlob.

Sets the designated parameter to an InputStream object.

public void
setBlob(String parmName, InputStream inputStream)

Implements java.sql.CallableStatement.setBlob.

Sets the designated parameter to an InputStream object.

public void
setBoolean(String parmName, boolean x)

Implements java.sql.CallableStatement.setBoolean.

Sets the designated parameter to the given Java boolean value.

public void
setByte(String parmName, byte x)

Implements java.sql.CallableStatement.setByte.

Sets the designated parameter to the given Java byte value.

public void
setBytes(String parmName, byte[] x)

Implements java.sql.CallableStatement.setBytes.

Sets the designated parameter to the given Java array of bytes.

public void
setCharacterStream(String parmName, Reader reader, int length)

Implements java.sql.CallableStatement.setCharacterStream.

Sets the designated parameter to the given Reader object, which is the given number of characters long.

public void
setCharacterStream(String parmName, Reader reader, long length)

Implements java.sql.CallableStatement.setCharacterStream.

Sets the designated parameter to the given Reader object, which is the given number of characters long.

public void
setCharacterStream(String parmName, Reader reader)

Implements java.sql.CallableStatement.setCharacterStream.

Sets the designated parameter to the given Reader object.

public void
setClob(String parmName, Clob x)

Implements java.sql.CallableStatement.setClob.

Sets the designated parameter to the given java.sql.Clob object.

public void
setClob(String parmName, Reader reader, long length)

Implements java.sql.CallableStatement.setClob.

Sets the designated parameter to a Reader object.

public void
setClob(String parmName, Reader reader)

Implements java.sql.CallableStatement.setClob.

Sets the designated parameter to a Reader object.

public void
setDate(String parmName, Date x, Calendar cal)

Implements java.sql.CallableStatement.setDate.

Sets the designated parameter to the given java.sql.Date value, using the given Calendar object.

public void
setDate(String parmName, Date x)

Implements java.sql.CallableStatement.setDate.

Sets the designated parameter to the given java.sql.Date value using the default time zone of the virtual machine that is running the application.

public void
setDouble(String parmName, double x)

Implements java.sql.CallableStatement.setDouble.

Sets the designated parameter to the given Java double value.

public void
setFloat(String parmName, float x)

Implements java.sql.CallableStatement.setFloat.

Sets the designated parameter to the given Java float value.

public void
setInt(int parmIdx, int arg1)

Overrides net.ucanaccess.jdbc.UcanaccessPreparedStatement.setInt.

Implements java.sql.PreparedStatement.setInt.

Sets the designated parameter to the given Java int value.

public void
setInt(String parmName, int x)

Implements java.sql.CallableStatement.setInt.

Sets the designated parameter to the given Java int value.

public void
setLong(String parmName, long x)

Implements java.sql.CallableStatement.setLong.

Sets the designated parameter to the given Java long value.

public void
setNCharacterStream(String parmName, Reader value, long length)

Implements java.sql.CallableStatement.setNCharacterStream.

Sets the designated parameter to a Reader object.

public void
setNCharacterStream(String parmName, Reader value)

Implements java.sql.CallableStatement.setNCharacterStream.

Sets the designated parameter to a Reader object.

public void
setNClob(String parmName, NClob value)

Implements java.sql.CallableStatement.setNClob.

Sets the designated parameter to a java.sql.NClob object.

public void
setNClob(String parmName, Reader reader, long length)

Implements java.sql.CallableStatement.setNClob.

Sets the designated parameter to a Reader object.

public void
setNClob(String parmName, Reader reader)

Implements java.sql.CallableStatement.setNClob.

Sets the designated parameter to a Reader object.

public void
setNString(String parmName, String value)

Implements java.sql.CallableStatement.setNString.

Sets the designated parameter to the given String object.

public void
setNull(String parmName, int sqlType, String typeName)

Implements java.sql.CallableStatement.setNull.

Sets the designated parameter to SQL NULL.

public void
setNull(String parmName, int sqlType)

Implements java.sql.CallableStatement.setNull.

Sets the designated parameter to SQL NULL.

public void
setObject(String parmName, Object x, int targetSqlType, int scale)

Implements java.sql.CallableStatement.setObject.

Sets the value of the designated parameter with the given object.

public void
setObject(String parmName, Object x, int targetSqlType)

Implements java.sql.CallableStatement.setObject.

Sets the value of the designated parameter with the given object.

public void
setObject(String parmName, Object x)

Implements java.sql.CallableStatement.setObject.

Sets the value of the designated parameter with the given object.

public void
setRowId(String parmName, RowId x)

Implements java.sql.CallableStatement.setRowId.

Sets the designated parameter to the given java.sql.RowId object.

public void
setShort(String parmName, short x)

Implements java.sql.CallableStatement.setShort.

Sets the designated parameter to the given Java short value.

public void
setSQLXML(String parmName, SQLXML xmlObject)

Implements java.sql.CallableStatement.setSQLXML.

Sets the designated parameter to the given java.sql.SQLXML object.

public void
setString(String parmName, String x)

Implements java.sql.CallableStatement.setString.

Sets the designated parameter to the given Java String value.

public void
setTime(String parmName, Time x, Calendar cal)

Implements java.sql.CallableStatement.setTime.

Sets the designated parameter to the given java.sql.Time value, using the given Calendar object.

public void
setTime(String parmName, Time x)

Implements java.sql.CallableStatement.setTime.

Sets the designated parameter to the given java.sql.Time value.

public void
setTimestamp(String parmName, Timestamp x, Calendar cal)

Implements java.sql.CallableStatement.setTimestamp.

Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object.

public void
setTimestamp(String parmName, Timestamp x)

Implements java.sql.CallableStatement.setTimestamp.

Sets the designated parameter to the given java.sql.Timestamp value.

public void
setURL(String parmName, URL val)

Implements java.sql.CallableStatement.setURL.

Sets the designated parameter to the given java.net.URL object.

public boolean
wasNull()

Implements java.sql.CallableStatement.wasNull.

Retrieves whether the last OUT parameter read had the value of SQL NULL.

Inherited from net.ucanaccess.jdbc.UcanaccessPreparedStatement:
addBatchclearParametersexecuteQuerygetParameterMetaDataresetsetArraysetAsciiStreamsetAsciiStreamsetAsciiStreamsetBigDecimalsetBinaryStreamsetBinaryStreamsetBinaryStreamsetBlobsetBlobsetBlobsetBooleansetBytesetBytessetCharacterStreamsetCharacterStreamsetCharacterStreamsetClobsetClobsetClobsetCursorNamesetDatesetDatesetDoublesetFloatsetLongsetNCharacterStreamsetNCharacterStreamsetNClobsetNClobsetNClobsetNStringsetNullsetNullsetObjectsetObjectsetObjectsetRefsetRowIdsetShortsetSQLXMLsetStringsetTimesetTimesetTimestampsetTimestampsetUnicodeStreamsetURLunwrap