IdmsCallableStatement

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

ca.idms.jdbc
Class IdmsCallableStatement

java.lang.Object
  ca.idms.io.TraceObject
      ca.idms.jdbc.IdmsJdbcObject
          ca.idms.jdbc.IdmsResultObject
              ca.idms.jdbc.IdmsStatement
                  ca.idms.jdbc.IdmsPreparedStatement
                      ca.idms.jdbc.IdmsCallableStatement

All Implemented Interfaces:: Trace, SQLState, java.sql.CallableStatement, java.sql.PreparedStatement, java.sql.Statement, java.sql.Wrapper

public class IdmsCallableStatement
extends IdmsPreparedStatement
implements java.sql.CallableStatement
extends IdmsPreparedStatement
implements java.sql.CallableStatement

This class is used to execute SQL CALL statements on IDMS procedures and table procedures. IDMS actually treats all parameters as INOUT and returns their values in a cursor. A table procedure can return 0 or more rows, a procedure can return 0 or 1 row. This class encapsulates this cursor and returns the first row as output parameters. Any other rows from a table procedure are not returned. To get these rows, execute the table procedure using a SELECT.

Enabling the CallSelect option will cause the driver to treat all CALL statements as SELECT, which will cause a ResultSet to be returned for all procedure invocations. For consistency when this option is enabled, the DatabaseMetaData getProcedures method will indicate that all procedures return a result, and the getProcedureColumns method will list each parameter twice, once as an IN parameter, and once as a result column.

See Also:: IdmsConnection.prepareCall(java.lang.String), IdmsConnectOptions

Field Summary

Fields inherited from class ca.idms.jdbc.IdmsJdbcObject
`FAKE_METHODS, FAKE_SUPPORT, fakeSupport, MESSAGES`

Fields inherited from class ca.idms.io.TraceObject
`exclude, EXCLUDE, FALSE, include, INCLUDE, logWriter, PREFIX, PROPERTIES_FILE, PROPERTIES_KEY, snap, SNAP, SNAP_BYTES, SNAP_NATIVE, SNAP_OBJECT, SNAP_SQL, snapBytes, snapNative, snapObject, snapSql, stub, trace, TRACE, TRACE_FILE, TRACE_LIFE, TRACE_NATIVE, TRACE_PRODUCT, traceLife, traceNative, traceStream, TRUE`

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`

Fields inherited from interface ca.idms.qcli.SQLState
`SQL_00000, SQL_01000, SQL_01004, SQL_07001, SQL_07009, SQL_08001, SQL_08002, SQL_08003, SQL_08004, SQL_08006, SQL_08007, SQL_0A000, SQL_21000, SQL_22000, SQL_22001, SQL_22003, SQL_22005, SQL_22007, SQL_24000, SQL_25000, SQL_3C000, SQL_40000, SQL_42000, SQL_HY000, SQL_HY004, SQL_HY009, SQL_HY010, SQL_HY024, SQL_HY106, SQL_HYC00`

Method Summary
`java.sql.Array`	`getArray(int p)` IDMS does not support the ARRAY type.
`java.sql.Array`	`getArray(java.lang.String p)` IDMS does not support named parameters as defined by JDBC (and does not support the ARRAY type anyway).
`java.math.BigDecimal`	`getBigDecimal(int p)` Gets the value of a NUMERIC parameter as a java.math.BigDecimal object.
`java.math.BigDecimal`	`getBigDecimal(int p, int s)` Gets the value of a NUMERIC parameter as a BigDecimal object.
`java.math.BigDecimal`	`getBigDecimal(java.lang.String p)` Gets the value of a NUMERIC parameter as a java.math.BigDecimal object.
`java.sql.Blob`	`getBlob(int p)` IDMS does not support the BLOB type.
`java.sql.Blob`	`getBlob(java.lang.String p)` IDMS does not support BLOBs.
`boolean`	`getBoolean(int p)` Gets the value of a BIT parameter as a boolean.
`boolean`	`getBoolean(java.lang.String p)` Gets the value of a BIT parameter as a boolean.
`byte`	`getByte(int p)` Gets the value of a TINYINT parameter as a byte.
`byte`	`getByte(java.lang.String p)` Gets the value of a TINYINT parameter as a byte.
`byte[]`	`getBytes(int p)` Gets the value of a BINARY parameter as a byte[]
`byte[]`	`getBytes(java.lang.String p)` Gets the value of a BINARY parameter as a byte[]
`java.io.Reader`	`getCharacterStream(int p)` Returns the value of the parameter as a java.io.Reader.
`java.io.Reader`	`getCharacterStream(java.lang.String p)` Returns the value of the parameter as a java.io.Reader.
`java.sql.Clob`	`getClob(int p)` IDMS does not support the CLOB type.
`java.sql.Clob`	`getClob(java.lang.String p)` IDMS does not support the CLOB type.
`java.sql.Date`	`getDate(int p)` Gets the value of a DATE parameter as a java.sql.Date object
`java.sql.Date`	`getDate(int p, java.util.Calendar c)` Gets the value of a SQL DATE parameter for the specified time zone.
`java.sql.Date`	`getDate(java.lang.String p)` Gets the value of a parameter as a java.sql.Date object.
`java.sql.Date`	`getDate(java.lang.String p, java.util.Calendar c)` Gets the value of a parameter as a java.sql.Date object.
`double`	`getDouble(int p)` Gets the value of a DOUBLE parameter as a double.
`double`	`getDouble(java.lang.String p)` Get the value of a parameter as a Java double.
`float`	`getFloat(int p)` Gets the value of a FLOAT parameter as a float.
`float`	`getFloat(java.lang.String p)` Get the value of a parameter as a Java float.
`int`	`getInt(int p)` Gets the value of an INTEGER parameter as a int.
`int`	`getInt(java.lang.String p)` Get the value of a parameter as a Java int.
`long`	`getLong(int p)` Gets the value of a BIGINT parameter as a long.
`long`	`getLong(java.lang.String p)` Get the value of a parameter as a Java long.
`java.io.Reader`	`getNCharacterStream(int p)` CA IDMS does not support National Character Sets
`java.io.Reader`	`getNCharacterStream(java.lang.String p)` CA IDMS does not support National Character Sets
`java.sql.NClob`	`getNClob(int p)` CA IDMS does not support National Character Sets or Clobs
`java.sql.NClob`	`getNClob(java.lang.String p)` CA IDMS does not support National Character Sets or Clobs
`java.lang.String`	`getNString(int p)` CA IDMS does not support National Character Sets
`java.lang.String`	`getNString(java.lang.String p)` CA IDMS does not support National Character Sets
`java.lang.Object`	`getObject(int p)` Gets the value of a parameter as a Java object.
`java.lang.Object`	`getObject(int p, java.util.Map<java.lang.String,java.lang.Class<?>> m)` Gets the value of a parameter as a Java object.
`java.lang.Object`	`getObject(java.lang.String p)` Get the value of a parameter as a Java object.
`java.lang.Object`	`getObject(java.lang.String p, java.util.Map<java.lang.String,java.lang.Class<?>> m)` Gets the parameter value as an object of appropriate type.
`java.sql.Ref`	`getRef(int p)` IDMS does not support the REFERENCE type.
`java.sql.Ref`	`getRef(java.lang.String p)` IDMS does not support named parameters as defined by JDBC (and does not support the REFERENCE type anyway).
`java.sql.RowId`	`getRowId(int p)` ROWID is not applicable for procedures in CA IDMS
`java.sql.RowId`	`getRowId(java.lang.String p)` ROWID is not applicable for procedures in CA IDMS
`short`	`getShort(int p)` Gets the value of a SMALLINT parameter as a short.
`short`	`getShort(java.lang.String p)` Get the value of a parameter as a Java short.
`java.sql.SQLXML`	`getSQLXML(int p)` CA IDMS does not support XML data type
`java.sql.SQLXML`	`getSQLXML(java.lang.String p)` CA IDMS does not support XML data type
`java.lang.String`	`getString(int p)` Gets the value of a CHAR or VARCHAR parameter as a String.
`java.lang.String`	`getString(java.lang.String p)` Get the value of a parameter as a Java String.
`java.sql.Time`	`getTime(int p)` Gets the value of a TIME parameter as a java.sql.Time object.
`java.sql.Time`	`getTime(int p, java.util.Calendar c)` Gets the value of a SQL TIME parameter for the specified time zone.
`java.sql.Time`	`getTime(java.lang.String p)` Get the value of a parameter as a java.sql.Time object.
`java.sql.Time`	`getTime(java.lang.String p, java.util.Calendar c)` Gets the value of a parameter as a java.sql.Time object.
`java.sql.Timestamp`	`getTimestamp(int p)` Gets the value of a TIMESTAMP parameter as a java.sql.Timestamp object.
`java.sql.Timestamp`	`getTimestamp(int p, java.util.Calendar c)` Gets the value of a SQL TIMESTAMP parameter for the specified time zone.
`java.sql.Timestamp`	`getTimestamp(java.lang.String p)` Get the value of a parameter as a java.sql.Timestamp object.
`java.sql.Timestamp`	`getTimestamp(java.lang.String p, java.util.Calendar c)` Gets the value of a parameter as a java.sql.Time object.
`java.net.URL`	`getURL(int p)` IDMS does not support named parameters as defined by JDBC (and does not support the URL type anyway).
`java.net.URL`	`getURL(java.lang.String p)` IDMS does not support named parameters as defined by JDBC (and does not support the URL type anyway).
`void`	`registerOutParameter(int p, int t)` Registers an output parameter.
`void`	`registerOutParameter(int p, int t, int s)` Registers an output parameter.
`void`	`registerOutParameter(int p, int t, java.lang.String n)` IDMS does not support user defined types.
`void`	`registerOutParameter(java.lang.String p, int t)` Registers an output parameter.
`void`	`registerOutParameter(java.lang.String p, int t, int s)` Registers an output parameter.
`void`	`registerOutParameter(java.lang.String p, int t, java.lang.String n)` IDMS does not support user defined types.
`void`	`setAsciiStream(int p, java.io.InputStream in)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setAsciiStream(int p, java.io.InputStream in, int len)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setAsciiStream(int p, java.io.InputStream in, long len)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setAsciiStream(java.lang.String p, java.io.InputStream in)` Sets a parameter to an ASCII stream value.
`void`	`setAsciiStream(java.lang.String p, java.io.InputStream in, int len)` Sets a parameter to an ASCII stream value.
`void`	`setAsciiStream(java.lang.String p, java.io.InputStream in, long len)` Sets a parameter to an ASCII stream value.
`void`	`setBigDecimal(int p, java.math.BigDecimal v)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setBigDecimal(java.lang.String p, java.math.BigDecimal v)` Sets a parameter to a BigDecimal value.
`void`	`setBinaryStream(int p, java.io.InputStream in)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setBinaryStream(int p, java.io.InputStream in, int len)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setBinaryStream(int p, java.io.InputStream in, long len)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setBinaryStream(java.lang.String p, java.io.InputStream in)` Sets a parameter to a Binary Stream value.
`void`	`setBinaryStream(java.lang.String p, java.io.InputStream in, int len)` Sets a parameter to a binary stream value.
`void`	`setBinaryStream(java.lang.String p, java.io.InputStream in, long len)` Sets a parameter to a Binary stream value.
`void`	`setBlob(java.lang.String p, java.sql.Blob v)` CA IDMS doesn't support Blob data type
`void`	`setBlob(java.lang.String p, java.io.InputStream v)` CA IDMS doesn't support Blob data type
`void`	`setBlob(java.lang.String p, java.io.InputStream arg1, long arg2)` CA IDMS doesn't support Blob data type
`void`	`setBoolean(java.lang.String p, boolean v)` Sets a named parameter to a Java boolean value.
`void`	`setByte(int p, byte v)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setByte(java.lang.String p, byte v)` Sets a named parameter to a Java byte value.
`void`	`setBytes(int p, byte[] v)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setBytes(java.lang.String p, byte[] v)` Sets a parameter to a Java array of bytes.
`void`	`setCharacterStream(int p, java.io.Reader in)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setCharacterStream(int p, java.io.Reader in, int len)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setCharacterStream(int p, java.io.Reader in, long len)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setCharacterStream(java.lang.String p, java.io.Reader in)` Sets a parameter to a Character Stream value.
`void`	`setCharacterStream(java.lang.String p, java.io.Reader in, int len)` Sets a parameter value from an input Reader.
`void`	`setCharacterStream(java.lang.String p, java.io.Reader in, long len)` Sets a parameter to a Character stream value.
`void`	`setClob(java.lang.String p, java.sql.Clob arg1)` CA IDMS doesn't support Clob type
`void`	`setClob(java.lang.String p, java.io.Reader arg1)` CA IDMS doesn't support Clob type
`void`	`setClob(java.lang.String p, java.io.Reader arg1, long arg2)` CA IDMS doesn't support Clob type
`void`	`setDate(int p, java.sql.Date v)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setDate(int p, java.sql.Date v, java.util.Calendar c)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setDate(java.lang.String p, java.sql.Date v)` Sets a named parameter to a java.sql.Date value.
`void`	`setDate(java.lang.String p, java.sql.Date v, java.util.Calendar c)` Sets a parameter to a java.sql.Date value.
`void`	`setDouble(int p, double v)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setDouble(java.lang.String p, double v)` Sets a named parameter to a Java double value.
`void`	`setFloat(int p, float v)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setFloat(java.lang.String p, float v)` Sets a named parameter to a Java float value.
`void`	`setInt(int p, int v)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setInt(java.lang.String p, int v)` Sets a named parameter to a Java int value.
`void`	`setLong(int p, long v)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setLong(java.lang.String p, long v)` Sets a named parameter to a Java long value.
`void`	`setNCharacterStream(java.lang.String p, java.io.Reader arg1)` CA IDMS doesn't support National Character Sets
`void`	`setNCharacterStream(java.lang.String p, java.io.Reader arg1, long arg2)` CA IDMS doesn't support National Character Sets
`void`	`setNClob(java.lang.String p, java.sql.NClob arg1)` CA IDMS doesn't support National Character Sets or Clobs
`void`	`setNClob(java.lang.String p, java.io.Reader arg1)` CA IDMS doesn't support National Character Sets or Clobs
`void`	`setNClob(java.lang.String p, java.io.Reader arg1, long arg2)` CA IDMS doesn't support National Character Sets or Clobs
`void`	`setNString(java.lang.String p, java.lang.String arg1)` CA IDMS doesn't support National Character Sets
`void`	`setNull(int p, int sqlType)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setNull(int p, int t, java.lang.String n)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setNull(java.lang.String p, int sqlType)` Sets a parameter to SQL NULL.
`void`	`setNull(java.lang.String p, int t, java.lang.String n)` Sets an input parameter to NULL.
`void`	`setObject(int p, java.lang.Object o)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setObject(int p, java.lang.Object o, int type)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setObject(int p, java.lang.Object o, int type, int scale)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setObject(java.lang.String p, java.lang.Object o)` Sets a parameter to an object with implicit type and scale 0.
`void`	`setObject(java.lang.String p, java.lang.Object o, int type)` Sets a parameter to an object value with a scale of zero.
`void`	`setObject(java.lang.String p, java.lang.Object o, int type, int scale)` Sets a parameter to an object value converted to the specified type.
`void`	`setRowId(int p, java.sql.RowId arg1)` ROWID is not applicable for procedures in CA IDMS
`void`	`setRowId(java.lang.String p, java.sql.RowId arg1)` ROWID is not applicable for procedures in CA IDMS
`void`	`setShort(int p, short v)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setShort(java.lang.String p, short v)` Sets a named parameter to a Java short value.
`void`	`setSQLXML(java.lang.String p, java.sql.SQLXML arg1)` CA IDMS doesn't support XML data type
`void`	`setString(int p, java.lang.String v)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setString(java.lang.String p, java.lang.String v)` Sets a named parameter to a Java String value.
`void`	`setTime(int p, java.sql.Time v)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setTime(int p, java.sql.Time v, java.util.Calendar c)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setTime(java.lang.String p, java.sql.Time v)` Sets a named parameter to a java.sql.Time value.
`void`	`setTime(java.lang.String p, java.sql.Time v, java.util.Calendar c)` Sets a parameter to a java.sql.Time value.
`void`	`setTimestamp(int p, java.sql.Timestamp v)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setTimestamp(int p, java.sql.Timestamp v, java.util.Calendar c)` This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding.
`void`	`setTimestamp(java.lang.String p, java.sql.Timestamp v)` Sets a named parameter to a java.sql.Timestamp value.
`void`	`setTimestamp(java.lang.String p, java.sql.Timestamp v, java.util.Calendar c)` Sets a parameter to a java.sql.Time value.
`void`	`setURL(java.lang.String p, java.net.URL v)` CA IDMS does not support the URL data type.
`boolean`	`wasNull()` Determines if the last parameter accessed was an SQL NULL value Since IDMS treats all parameters as INOUT, this is not limited to OUT parameters as described in the JDBC javadoc for this interface (it was probably just another typo in the spec anyway).

Methods inherited from class ca.idms.jdbc.IdmsPreparedStatement
`addBatch, clearParameters, close, execute, execute, executeBatch, executeQuery, executeQuery, executeUpdate, executeUpdate, get, getMetaData, getNullType, getParameterMetaData, setArray, setBlob, setBlob, setBlob, setBoolean, setClob, setClob, setClob, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setRef, setSQLXML, setUnicodeStream, setURL`

Methods inherited from class ca.idms.jdbc.IdmsStatement
`addBatch, cancel, clearBatch, execute, execute, execute, executeUpdate, executeUpdate, executeUpdate, finalize, getConnection, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, isPoolable, setCursorName, setEscapeProcessing, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout`

Methods inherited from class ca.idms.jdbc.IdmsStatement

addBatch, cancel, clearBatch, execute, execute, execute, executeUpdate, executeUpdate, executeUpdate, finalize, getConnection, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, isPoolable, setCursorName, setEscapeProcessing, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout

Methods inherited from class ca.idms.jdbc.IdmsResultObject
`getFetchDirection, getFetchSize, isClosed, setFetchDirection, setFetchSize`

Methods inherited from class ca.idms.jdbc.IdmsJdbcObject
`clearWarnings, getWarnings, hasCursor, hasUpdate, isStarted, isSuspended, isWrapperFor, notifyStatementError, unwrap`

Methods inherited from class ca.idms.io.TraceObject
`getBoolean, getClasses, getInteger, getProperty, listProperties, message, parseList, print, print, print, println, println, snap, snap, snap, snap, snap, snap, snap, toHex, toHex, toHex, toHex, toHex, toString, trace, trace, trace, trace, trace, trace, traceEntry, unloadProperties`

Methods inherited from class java.lang.Object
`clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait`

Methods inherited from interface java.sql.PreparedStatement
`addBatch, clearParameters, execute, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setBlob, setBlob, setBlob, setBoolean, setClob, setClob, setClob, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setRef, setSQLXML, setUnicodeStream, setURL`

Methods inherited from interface java.sql.Statement
addBatch, cancel, clearBatch, clearWarnings, close, 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, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout

Methods inherited from interface java.sql.Statement

addBatch, cancel, clearBatch, clearWarnings, close, 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, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout

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

Method Detail

getString

public java.lang.String getString(int p)
                           throws java.sql.SQLException

Gets the value of a CHAR or VARCHAR parameter as a String.

Specified by:: getString in interface java.sql.CallableStatement

Parameters:: p - parameter number
Returns:: the parameter value or null if none exists
Throws:: java.sql.SQLException - if a database error occurs

getBoolean

public boolean getBoolean(int p)
                   throws java.sql.SQLException

Gets the value of a BIT parameter as a boolean.

Specified by:: getBoolean in interface java.sql.CallableStatement

Parameters:: p - parameter number
Returns:: the parameter value or 0 if none exists
Throws:: java.sql.SQLException - if a database error occurs

getByte

public byte getByte(int p)
             throws java.sql.SQLException

Gets the value of a TINYINT parameter as a byte.

Specified by:: getByte in interface java.sql.CallableStatement

Parameters:: p - parameter number
Returns:: the parameter value or 0 if none exists
Throws:: java.sql.SQLException - if a database error occurs

getShort

public short getShort(int p)
               throws java.sql.SQLException

Gets the value of a SMALLINT parameter as a short.

Specified by:: getShort in interface java.sql.CallableStatement

Parameters:: p - parameter number
Returns:: the parameter value or 0 if none exists
Throws:: java.sql.SQLException - if a database error occurs

getInt

public int getInt(int p)
           throws java.sql.SQLException

Gets the value of an INTEGER parameter as a int.

Specified by:: getInt in interface java.sql.CallableStatement

Parameters:: p - parameter number
Returns:: the parameter value or 0 if none exists
Throws:: java.sql.SQLException - if a database error occurs

getLong

public long getLong(int p)
             throws java.sql.SQLException

Gets the value of a BIGINT parameter as a long.

Specified by:: getLong in interface java.sql.CallableStatement

Parameters:: p - parameter number
Returns:: the parameter value or 0 if none exists
Throws:: java.sql.SQLException - if a database error occurs

getFloat

public float getFloat(int p)
               throws java.sql.SQLException

Gets the value of a FLOAT parameter as a float.

Specified by:: getFloat in interface java.sql.CallableStatement

Parameters:: p - parameter number
Returns:: the parameter value or 0 if none exists
Throws:: java.sql.SQLException - if a database error occurs

getDouble

public double getDouble(int p)
                 throws java.sql.SQLException

Gets the value of a DOUBLE parameter as a double.

Specified by:: getDouble in interface java.sql.CallableStatement

Parameters:: p - parameter number
Returns:: the parameter value or 0 if none exists
Throws:: java.sql.SQLException - if a database error occurs

getBigDecimal

public java.math.BigDecimal getBigDecimal(int p,
                                          int s)
                                   throws java.sql.SQLException

Gets the value of a NUMERIC parameter as a BigDecimal object.

Specified by:: getBigDecimal in interface java.sql.CallableStatement

Parameters:: p - parameter number; s - scale
Returns:: the parameter value or null if none exists
Throws:: java.sql.SQLException - if a database error occurs

getBytes

public byte[] getBytes(int p)
                throws java.sql.SQLException

Gets the value of a BINARY parameter as a byte[]

Specified by:: getBytes in interface java.sql.CallableStatement

Parameters:: p - parameter number
Returns:: the parameter value or null if none exists
Throws:: java.sql.SQLException - if a database error occurs

getDate

public java.sql.Date getDate(int p)
                      throws java.sql.SQLException

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

Specified by:: getDate in interface java.sql.CallableStatement

Parameters:: p - parameter number
Returns:: the parameter value or null if none exists
Throws:: java.sql.SQLException - if a database error occurs

getTime

public java.sql.Time getTime(int p)
                      throws java.sql.SQLException

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

Specified by:: getTime in interface java.sql.CallableStatement

Parameters:: p - parameter number
Returns:: the parameter value or null if none exists
Throws:: java.sql.SQLException - if a database error occurs

getTimestamp

public java.sql.Timestamp getTimestamp(int p)
                                throws java.sql.SQLException

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

Specified by:: getTimestamp in interface java.sql.CallableStatement

Parameters:: p - parameter number
Returns:: the parameter value or null if none exists
Throws:: java.sql.SQLException - if a database error occurs

getObject

public java.lang.Object getObject(int p)
                           throws java.sql.SQLException

Gets the value of a parameter as a Java object.

This method returns a Java object whose type coresponds to the SQL type that was registered for this parameter using registerOutParameter.

Note that this method may be used to read datatabase-specific, abstract data types. This is done by specifying a targetSqlType of java.sql.types.OTHER, which allows the driver to return a database-specific Java type.

Specified by:: getObject in interface java.sql.CallableStatement

Parameters:: p - parameter number
Returns:: the parameter value or null if none exists
Throws:: java.sql.SQLException - if a database error occurs

registerOutParameter

public void registerOutParameter(int p,
                                 int t)
                          throws java.sql.SQLException

Registers an output parameter. Since IDMS treats all procedure parameters as INOUT, this just sets the parameter to NULL unless it has already been set as an input parameter. Since IDMS uses completely separate buffers and descriptors for the IN and OUT parameters, it does not really matter to the driver if the type specified is the same, so this method does not enforce that JDBC restriction.

It is up to the procedure to ignore the input value.

Specified by:: registerOutParameter in interface java.sql.CallableStatement

Parameters:: p - parameter index.; t - SQL type.
Throws:: java.sql.SQLException - if an error occurs.
See Also:: IdmsPreparedStatement.setNull(int, int)

registerOutParameter

public void registerOutParameter(int p,
                                 int t,
                                 int s)
                          throws java.sql.SQLException

Registers an output parameter. Since IDMS treats all procedure parameters as INOUT, this just sets the parameter to NULL.

Specified by:: registerOutParameter in interface java.sql.CallableStatement

Parameters:: p - parameter index.; t - SQL type.; s - scale.
Throws:: java.sql.SQLException - if an error occurs.
See Also:: IdmsPreparedStatement.setNull(int, int)

wasNull

public boolean wasNull()
                throws java.sql.SQLException

Determines if the last parameter accessed was an SQL NULL value Since IDMS treats all parameters as INOUT, this is not limited to OUT parameters as described in the JDBC javadoc for this interface (it was probably just another typo in the spec anyway). If the IDMS procedure returned no data this method also returns true.

Specified by:: wasNull in interface java.sql.CallableStatement

Returns:: true if it was NULL or did not exist at all
Throws:: java.sql.SQLException - not really.

getBigDecimal

public java.math.BigDecimal getBigDecimal(int p)
                                   throws java.sql.SQLException

Gets the value of a NUMERIC parameter as a java.math.BigDecimal object.

Specified by:: getBigDecimal in interface java.sql.CallableStatement

Parameters:: p - parameter number
Returns:: the parameter value as a BigDecimal
Throws:: java.sql.SQLException - if an error occurs
Since:: 1.2

getDate

public java.sql.Date getDate(int p,
                             java.util.Calendar c)
                      throws java.sql.SQLException

Gets the value of a SQL DATE parameter for the specified time zone.

Specified by:: getDate in interface java.sql.CallableStatement

Parameters:: p - parameter number; c - Calendar object specifying time zone information
Returns:: the adjusted Date
Throws:: java.sql.SQLException - if an error occurs
Since:: 1.2

getTime

public java.sql.Time getTime(int p,
                             java.util.Calendar c)
                      throws java.sql.SQLException

Gets the value of a SQL TIME parameter for the specified time zone.

Specified by:: getTime in interface java.sql.CallableStatement

Parameters:: p - parameter number; c - Calendar object specifying time zone information
Returns:: the adjusted Time
Throws:: java.sql.SQLException - if an error occurs
Since:: 1.2

getTimestamp

public java.sql.Timestamp getTimestamp(int p,
                                       java.util.Calendar c)
                                throws java.sql.SQLException

Gets the value of a SQL TIMESTAMP parameter for the specified time zone.

Specified by:: getTimestamp in interface java.sql.CallableStatement

Parameters:: p - parameter number; c - Calendar object specifying time zone information
Returns:: the adjusted Timestamp
Throws:: java.sql.SQLException - if an error occurs
Since:: 1.2

getObject

public java.lang.Object getObject(int p,
                                  java.util.Map<java.lang.String,java.lang.Class<?>> m)
                           throws java.sql.SQLException

Gets the value of a parameter as a Java object.

Specified by:: getObject in interface java.sql.CallableStatement

Parameters:: p - parameter number; m - Map object, ignored
Returns:: nothing
Throws:: java.sql.SQLException - always
Since:: 1.2

getArray

public java.sql.Array getArray(int p)
                        throws java.sql.SQLException

IDMS does not support the ARRAY type.

Specified by:: getArray in interface java.sql.CallableStatement

Parameters:: p - parameter number, ignored
Returns:: null
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

getBlob

public java.sql.Blob getBlob(int p)
                      throws java.sql.SQLException

IDMS does not support the BLOB type.

Specified by:: getBlob in interface java.sql.CallableStatement

Parameters:: p - parameter number, ignored
Returns:: null
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

getClob

public java.sql.Clob getClob(int p)
                      throws java.sql.SQLException

IDMS does not support the CLOB type.

Specified by:: getClob in interface java.sql.CallableStatement

Parameters:: p - parameter number, ignored
Returns:: null
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

getRef

public java.sql.Ref getRef(int p)
                    throws java.sql.SQLException

IDMS does not support the REFERENCE type.

Specified by:: getRef in interface java.sql.CallableStatement

Parameters:: p - parameter number, ignored
Returns:: null
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

registerOutParameter

public void registerOutParameter(int p,
                                 int t,
                                 java.lang.String n)
                          throws java.sql.SQLException

IDMS does not support user defined types. This method does nothing except satisfy the interface, IDMS does not support user defined types anyway.

Specified by:: registerOutParameter in interface java.sql.CallableStatement

Parameters:: p - parameter index, ignored.; t - SQL type, ignored.; n - user defined type name, ignored.
Throws:: java.sql.SQLException - not really.

getArray

public java.sql.Array getArray(java.lang.String p)
                        throws java.sql.SQLException

IDMS does not support named parameters as defined by JDBC (and does not support the ARRAY type anyway).

Specified by:: getArray in interface java.sql.CallableStatement

Parameters:: p - parameter name, ignored
Returns:: null
Throws:: java.sql.SQLException - always
Since:: 1.4

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String p)
                                   throws java.sql.SQLException

Gets the value of a NUMERIC parameter as a java.math.BigDecimal object.

Specified by:: getBigDecimal in interface java.sql.CallableStatement

Parameters:: p - parameter name
Returns:: the parameter value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database error occurs
Since:: 1.4

getBlob

public java.sql.Blob getBlob(java.lang.String p)
                      throws java.sql.SQLException

IDMS does not support BLOBs.

Specified by:: getBlob in interface java.sql.CallableStatement

Parameters:: p - parameter name, ignored
Returns:: null
Throws:: java.sql.SQLException - always
Since:: 1.4

getBoolean

public boolean getBoolean(java.lang.String p)
                   throws java.sql.SQLException

Gets the value of a BIT parameter as a boolean.

Specified by:: getBoolean in interface java.sql.CallableStatement

Parameters:: p - parameter name
Returns:: the parameter value or 0 if none exists
Throws:: java.sql.SQLException - if a database error occurs
Since:: 1.4

getByte

public byte getByte(java.lang.String p)
             throws java.sql.SQLException

Gets the value of a TINYINT parameter as a byte.

Specified by:: getByte in interface java.sql.CallableStatement

Parameters:: p - parameter name
Returns:: the parameter value or 0 if none exists
Throws:: java.sql.SQLException - if a database error occurs
Since:: 1.4

getBytes

public byte[] getBytes(java.lang.String p)
                throws java.sql.SQLException

Gets the value of a BINARY parameter as a byte[]

Specified by:: getBytes in interface java.sql.CallableStatement

Parameters:: p - parameter name
Returns:: the parameter value or null if none exists
Throws:: java.sql.SQLException - if a database error occurs
Since:: 1.4

getClob

public java.sql.Clob getClob(java.lang.String p)
                      throws java.sql.SQLException

IDMS does not support the CLOB type.

Specified by:: getClob in interface java.sql.CallableStatement

Parameters:: p - parameter name, ignored
Returns:: null
Throws:: java.sql.SQLException - always
Since:: 1.4

getDate

public java.sql.Date getDate(java.lang.String p)
                      throws java.sql.SQLException

Gets the value of a parameter as a java.sql.Date object. No adjustments are made for time zones.

Specified by:: getDate in interface java.sql.CallableStatement

Parameters:: p - parameter name
Returns:: the parameter value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database error occurs.
Since:: 1.4

getDate

public java.sql.Date getDate(java.lang.String p,
                             java.util.Calendar c)
                      throws java.sql.SQLException

Gets the value of a parameter as a java.sql.Date object. The converted value is adjusted for the specified time zone, if supplied.

Specified by:: getDate in interface java.sql.CallableStatement

Parameters:: p - parameter name; c - Calendar object specifying time zone information
Returns:: the adjusted Date; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if an error occurs
Since:: 1.4

getDouble

public double getDouble(java.lang.String p)
                 throws java.sql.SQLException

Get the value of a parameter as a Java double.

Specified by:: getDouble in interface java.sql.CallableStatement

Parameters:: p - the parameter name
Returns:: the parameter value; if the value is SQL NULL, the result is 0
Throws:: java.sql.SQLException - if a database error occurs.
Since:: 1.4

getFloat

public float getFloat(java.lang.String p)
               throws java.sql.SQLException

Get the value of a parameter as a Java float.

Specified by:: getFloat in interface java.sql.CallableStatement

Parameters:: p - the parameter name
Returns:: the parameter value; if the value is SQL NULL, the result is 0
Throws:: java.sql.SQLException - if a database error occurs.
Since:: 1.4

getInt

public int getInt(java.lang.String p)
           throws java.sql.SQLException

Get the value of a parameter as a Java int.

Specified by:: getInt in interface java.sql.CallableStatement

Parameters:: p - the parameter name
Returns:: the parameter value; if the value is SQL NULL, the result is 0
Throws:: java.sql.SQLException - if a database error occurs.
Since:: 1.4

getLong

public long getLong(java.lang.String p)
             throws java.sql.SQLException

Get the value of a parameter as a Java long.

Specified by:: getLong in interface java.sql.CallableStatement

Parameters:: p - the parameter name
Returns:: the parameter value; if the value is SQL NULL, the result is 0
Throws:: java.sql.SQLException - if a database error occurs.
Since:: 1.4

getObject

public java.lang.Object getObject(java.lang.String p)
                           throws java.sql.SQLException

Get the value of a parameter as a Java object.

This method will return the value of the given column as a Java object. The type of the Java object will be the default Java Object type corresponding to the column's SQL type, following the mapping specified in the JDBC spec.

This method may also be used to read database-specific abstract data types.

Specified by:: getObject in interface java.sql.CallableStatement

Parameters:: p - the name of the parameter
Returns:: a java.lang.Object holding the parameter value.
Throws:: java.sql.SQLException - if a database error occurs.

getObject

public java.lang.Object getObject(java.lang.String p,
                                  java.util.Map<java.lang.String,java.lang.Class<?>> m)
                           throws java.sql.SQLException

Gets the parameter value as an object of appropriate type. CA IDMS does not support UDTs, so it does not support mapping of UDTs. This method is equivalent to getObject(int).

Specified by:: getObject in interface java.sql.CallableStatement

Parameters:: p - parameter name; m - the Map, ignored
Returns:: the object
Throws:: java.sql.SQLException - if an error occurs
Since:: 1.4

getRef

public java.sql.Ref getRef(java.lang.String p)
                    throws java.sql.SQLException

IDMS does not support named parameters as defined by JDBC (and does not support the REFERENCE type anyway).

Specified by:: getRef in interface java.sql.CallableStatement

Parameters:: p - parameter name, ignored
Returns:: null
Throws:: java.sql.SQLException - always
Since:: 1.4

getShort

public short getShort(java.lang.String p)
               throws java.sql.SQLException

Get the value of a parameter as a Java short.

Specified by:: getShort in interface java.sql.CallableStatement

Parameters:: p - the parameter name
Returns:: the parameter value; if the value is SQL NULL, the result is 0
Throws:: java.sql.SQLException - if a database error occurs.
Since:: 1.4

getString

public java.lang.String getString(java.lang.String p)
                           throws java.sql.SQLException

Get the value of a parameter as a Java String.

Specified by:: getString in interface java.sql.CallableStatement

Parameters:: p - the parameter name
Returns:: the column value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database error occurs.
Since:: 1.4

getTime

public java.sql.Time getTime(java.lang.String p)
                      throws java.sql.SQLException

Get the value of a parameter as a java.sql.Time object. No adjustments are made for time zones.

Specified by:: getTime in interface java.sql.CallableStatement

Parameters:: p - the parameter name
Returns:: the parameter value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database error occurs.
Since:: 1.4

getTime

public java.sql.Time getTime(java.lang.String p,
                             java.util.Calendar c)
                      throws java.sql.SQLException

Gets the value of a parameter as a java.sql.Time object. The converted value is adjusted for the specified time zone, if supplied.

Specified by:: getTime in interface java.sql.CallableStatement

Parameters:: p - parameter name; c - Calendar object specifying time zone information.
Returns:: the adjusted Time
Throws:: java.sql.SQLException - if an error occurs
Since:: 1.4

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String p)
                                throws java.sql.SQLException

Get the value of a parameter as a java.sql.Timestamp object. No adjustments are made for time zones.

Specified by:: getTimestamp in interface java.sql.CallableStatement

Parameters:: p - the parameter name
Returns:: the parameter value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database error occurs.
Since:: 1.4

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String p,
                                       java.util.Calendar c)
                                throws java.sql.SQLException

Gets the value of a parameter as a java.sql.Time object. The converted value is adjusted for the specified time zone, if supplied.

Specified by:: getTimestamp in interface java.sql.CallableStatement

Parameters:: p - parameter name; c - Calendar object specifying time zone information.
Returns:: the adjusted Timestamp
Throws:: java.sql.SQLException - if an error occurs
Since:: 1.4

getURL

public java.net.URL getURL(int p)
                    throws java.sql.SQLException

IDMS does not support named parameters as defined by JDBC (and does not support the URL type anyway).

Specified by:: getURL in interface java.sql.CallableStatement

Parameters:: p - parameter name
Returns:: null
Throws:: java.sql.SQLException - always
Since:: 1.4

getURL

public java.net.URL getURL(java.lang.String p)
                    throws java.sql.SQLException

IDMS does not support named parameters as defined by JDBC (and does not support the URL type anyway).

Specified by:: getURL in interface java.sql.CallableStatement

Parameters:: p - parameter name
Returns:: null
Throws:: java.sql.SQLException - always
Since:: 1.4

registerOutParameter

public void registerOutParameter(java.lang.String p,
                                 int t)
                          throws java.sql.SQLException

It is up to the procedure to ignore the input value.

Specified by:: registerOutParameter in interface java.sql.CallableStatement

Parameters:: p - parameter name.; t - SQL type.
Throws:: java.sql.SQLException - if an error occurs.
Since:: 1.4

registerOutParameter

public void registerOutParameter(java.lang.String p,
                                 int t,
                                 int s)
                          throws java.sql.SQLException

Registers an output parameter. Since IDMS treats all procedure parameters as INOUT, this just sets the parameter to NULL.

Specified by:: registerOutParameter in interface java.sql.CallableStatement

Parameters:: p - parameter name.; t - SQL type.; s - scale.
Throws:: java.sql.SQLException - if an error occurs.
Since:: 1.4

registerOutParameter

public void registerOutParameter(java.lang.String p,
                                 int t,
                                 java.lang.String n)
                          throws java.sql.SQLException

IDMS does not support user defined types. This method does nothing except satisfy the interface, IDMS does not support user defined types anyway.

Specified by:: registerOutParameter in interface java.sql.CallableStatement

Parameters:: p - parameter name, ignored.; t - SQL type, ignored.; n - user defined type name, ignored.
Throws:: java.sql.SQLException - not really.
Since:: 1.4

setAsciiStream

public void setAsciiStream(java.lang.String p,
                           java.io.InputStream in,
                           int len)
                    throws java.sql.SQLException

Sets a parameter to an ASCII stream value.

This method determines the ordinal which corresponds to the parameter name, then calls setAsciiStream(int, InputStream, int)

Specified by:: setAsciiStream in interface java.sql.CallableStatement

Parameters:: p - parameter name; in - the java input stream which contains the ASCII parameter value; len - the number of bytes in the stream
Throws:: java.sql.SQLException - if a database-access error occurs.
Since:: 1.4

setBigDecimal

public void setBigDecimal(java.lang.String p,
                          java.math.BigDecimal v)
                   throws java.sql.SQLException

Sets a parameter to a BigDecimal value.

This method determines the ordinal which corresponds to the parameter name, then calls setBigDecimal(int, BigDecimal)

Specified by:: setBigDecimal in interface java.sql.CallableStatement

Parameters:: p - parameter name; v - the parameter value
Throws:: java.sql.SQLException - if value would be truncated.
Since:: 1.4

setBinaryStream

public void setBinaryStream(java.lang.String p,
                            java.io.InputStream in,
                            int len)
                     throws java.sql.SQLException

Sets a parameter to a binary stream value.

This method determines the ordinal which corresponds to the parameter name, then calls setBinaryStream(int, InputStream, int)

Specified by:: setBinaryStream in interface java.sql.CallableStatement

Parameters:: p - parameter name; in - the java input stream which contains the binary parameter value; len - the number of bytes in the stream
Throws:: java.sql.SQLException - if a database-access error occurs.
Since:: 1.4

setBoolean

public void setBoolean(java.lang.String p,
                       boolean v)
                throws java.sql.SQLException

Sets a named parameter to a Java boolean value. The driver converts this to an IDMS SQL SMALLINT value, with true = 1 and false = 0, when it sends it to the database. There is no IDMS BIT type.

Specified by:: setBoolean in interface java.sql.CallableStatement

Parameters:: p - parameter name; v - the parameter value
Throws:: java.sql.SQLException - (not really).
Since:: 1.4

setByte

public void setByte(java.lang.String p,
                    byte v)
             throws java.sql.SQLException

Sets a named parameter to a Java byte value. The driver converts this to an IDMS SQL SMALLINT value when it sends it to the database. There is no IDMS TINYINT type.

Specified by:: setByte in interface java.sql.CallableStatement

Parameters:: p - parameter name; v - byte value
Throws:: java.sql.SQLException
Since:: 1.4

setBytes

public void setBytes(java.lang.String p,
                     byte[] v)
              throws java.sql.SQLException

Sets a parameter to a Java array of bytes.

This method determines the ordinal which corresponds to the parameter name, then calls setBytes(int, byte[])

Specified by:: setBytes in interface java.sql.CallableStatement

Parameters:: p - parameter name; v - the parameter value
Throws:: java.sql.SQLException - (not really)
Since:: 1.4

setCharacterStream

public void setCharacterStream(java.lang.String p,
                               java.io.Reader in,
                               int len)
                        throws java.sql.SQLException

Sets a parameter value from an input Reader.

This method determines the ordinal which corresponds to the parameter name, then calls setCharacterStream(int, Reader, int)

Specified by:: setCharacterStream in interface java.sql.CallableStatement

Parameters:: p - parameter name; in - the input java.io.Reader; len - number of characters
Throws:: java.sql.SQLException - if an error occurs
Since:: 1.4

setDate

public void setDate(java.lang.String p,
                    java.sql.Date v)
             throws java.sql.SQLException

Sets a named parameter to a java.sql.Date value. The driver converts this to an IDMS SQL DATE value using the current default TimeZone when it sends it to the database.

Specified by:: setDate in interface java.sql.CallableStatement

Parameters:: p - parameter name; v - Date value
Throws:: java.sql.SQLException
Since:: 1.4

setDate

public void setDate(java.lang.String p,
                    java.sql.Date v,
                    java.util.Calendar c)
             throws java.sql.SQLException

Sets a parameter to a java.sql.Date value.

This method determines the ordinal which corresponds to the parameter name, then calls setDate(int, Date, Calendar)

Specified by:: setDate in interface java.sql.CallableStatement

Parameters:: p - parameter name; v - Date value; c - Calendar object specifying time zone information
Throws:: java.sql.SQLException - if an error occurs
Since:: 1.4

setDouble

public void setDouble(java.lang.String p,
                      double v)
               throws java.sql.SQLException

Sets a named parameter to a Java double value. The driver converts this to an IDMS SQL DOUBLE value when it sends it to the database.

Specified by:: setDouble in interface java.sql.CallableStatement

Parameters:: p - parameter name; v - double value
Throws:: java.sql.SQLException
Since:: 1.4

setFloat

public void setFloat(java.lang.String p,
                     float v)
              throws java.sql.SQLException

Sets a named parameter to a Java float value. The driver converts this to an IDMS SQL REAL value when it sends it to the database.

Specified by:: setFloat in interface java.sql.CallableStatement

Parameters:: p - parameter name; v - float value
Throws:: java.sql.SQLException
Since:: 1.4

setInt

public void setInt(java.lang.String p,
                   int v)
            throws java.sql.SQLException

Sets a named parameter to a Java int value. The driver converts this to an IDMS SQL INTEGER value when it sends it to the database.

Specified by:: setInt in interface java.sql.CallableStatement

Parameters:: p - parameter name; v - int value
Throws:: java.sql.SQLException
Since:: 1.4

setLong

public void setLong(java.lang.String p,
                    long v)
             throws java.sql.SQLException

Sets a named parameter to a Java long value. The driver converts this to an IDMS SQL LONGINT value when it sends it to the database.

Specified by:: setLong in interface java.sql.CallableStatement

Parameters:: p - parameter name; v - long value
Throws:: java.sql.SQLException
Since:: 1.4

setNull

public void setNull(java.lang.String p,
                    int sqlType)
             throws java.sql.SQLException

Sets a parameter to SQL NULL. If the type specified is different than the type previously specified it is ignored and the previous descriptor is used. The value is NULL either way.

Specified by:: setNull in interface java.sql.CallableStatement

Parameters:: p - parameter name; sqlType - SQL type code defined by java.sql.Types
Throws:: java.sql.SQLException - if a database-access error occurs.
Since:: 1.4

setNull

public void setNull(java.lang.String p,
                    int t,
                    java.lang.String n)
             throws java.sql.SQLException

Sets an input parameter to NULL. CA IDMS does not support the "advanced data types", so this method is equivalent to setNull(String, int).

Specified by:: setNull in interface java.sql.CallableStatement

Parameters:: p - parameter name; t - SQL type from java.sql.Types; n - user defined type name, ignored
Throws:: java.sql.SQLException - if an error occurs
Since:: 1.4

setObject

public void setObject(java.lang.String p,
                      java.lang.Object o)
               throws java.sql.SQLException

Sets a parameter to an object with implicit type and scale 0.

The JDBC specification specifies a standard mapping from Java Object types to SQL types. The given argument java object will be converted to the corresponding IDMS SQL type before being sent to the database.

Specified by:: setObject in interface java.sql.CallableStatement

Parameters:: p - parameter name; o - object containing the input parameter value
Throws:: java.sql.SQLException - if a database-access error occurs.
Since:: 1.4
See Also:: setObject(String, Object, int, int)

setObject

public void setObject(java.lang.String p,
                      java.lang.Object o,
                      int type)
               throws java.sql.SQLException

Sets a parameter to an object value with a scale of zero.

Specified by:: setObject in interface java.sql.CallableStatement

Parameters:: p - parameter name; o - object containing the input parameter value; type - JDBC SQL type.
Throws:: java.sql.SQLException - if a database-access error occurs.
Since:: 1.4
See Also:: setObject(String, Object, int, int)

setObject

public void setObject(java.lang.String p,
                      java.lang.Object o,
                      int type,
                      int scale)
               throws java.sql.SQLException

Sets a parameter to an object value converted to the specified type.

The given Java object will be converted to the IDMS type that corresponds the specified JDBC type before being sent to the database.

Use the java.lang equivalent objects for integral values.

Note that since there are no IDMS specific abstract data types specifying type = OTHER will cause an SQLException to be thrown.

Specified by:: setObject in interface java.sql.CallableStatement

Parameters:: p - parameter name; o - object containing the input parameter value; type - SQL type (as defined in java.sql.Types) to be sent to the database. The scale argument may further qualify this type.; scale - number of digits after the decimal for DECIMAL NUMERIC types, ignored for all other types.
Throws:: java.sql.SQLException - if a database-access error occurs.
Since:: 1.4

setShort

public void setShort(java.lang.String p,
                     short v)
              throws java.sql.SQLException

Sets a named parameter to a Java short value. The driver converts this to an IDMS SQL SMALLINT value when it sends it to the database.

Specified by:: setShort in interface java.sql.CallableStatement

Parameters:: p - parameter name; v - short value
Throws:: java.sql.SQLException
Since:: 1.4

setString

public void setString(java.lang.String p,
                      java.lang.String v)
               throws java.sql.SQLException

Sets a named parameter to a Java String value.

This method determines the ordinal which corresponds to the parameter name, then calls setAsciiStream(int, InputStream, int)

Specified by:: setString in interface java.sql.CallableStatement

Parameters:: p - parameter name; v - String value
Throws:: java.sql.SQLException - if mixing ordinals with named parameters
Since:: 1.4

setTime

public void setTime(java.lang.String p,
                    java.sql.Time v)
             throws java.sql.SQLException

Sets a named parameter to a java.sql.Time value. The driver converts this to an IDMS SQL TIME value using the current default TimeZone when it sends it to the database.

Specified by:: setTime in interface java.sql.CallableStatement

Parameters:: p - parameter name; v - Time value
Throws:: java.sql.SQLException - always
Since:: 1.4

setTime

public void setTime(java.lang.String p,
                    java.sql.Time v,
                    java.util.Calendar c)
             throws java.sql.SQLException

Sets a parameter to a java.sql.Time value.

This method determines the ordinal which corresponds to the parameter name, then calls setTime(int, Time, Calendar)

Specified by:: setTime in interface java.sql.CallableStatement

Parameters:: p - parameter name; v - Time value; c - Calendar object specifying time zone information
Throws:: java.sql.SQLException - if an error occurs
Since:: 1.4
See Also:: setTime(int,java.sql.Time)

setTimestamp

public void setTimestamp(java.lang.String p,
                         java.sql.Timestamp v)
                  throws java.sql.SQLException

Sets a named parameter to a java.sql.Timestamp value. The driver converts this to an IDMS SQL TIMESTAMP value using the current default TimeZone when it sends it to the database.

Specified by:: setTimestamp in interface java.sql.CallableStatement

Parameters:: p - parameter name; v - Timestamp value
Throws:: java.sql.SQLException
Since:: 1.4

setTimestamp

public void setTimestamp(java.lang.String p,
                         java.sql.Timestamp v,
                         java.util.Calendar c)
                  throws java.sql.SQLException

Sets a parameter to a java.sql.Time value.

This method determines the ordinal which corresponds to the parameter name, then calls setTimestamp(int, Timestamp, Calendar)

Specified by:: setTimestamp in interface java.sql.CallableStatement

Parameters:: p - parameter name; v - Timestamp value; c - Calendar object specifying time zone information
Throws:: java.sql.SQLException - if an error occurs
Since:: 1.4
See Also:: setTimestamp(int,java.sql.Timestamp)

setURL

public void setURL(java.lang.String p,
                   java.net.URL v)
            throws java.sql.SQLException

CA IDMS does not support the URL data type.

Specified by:: setURL in interface java.sql.CallableStatement

Parameters:: p - parameter name, ignored; v - parameter value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.4

getCharacterStream

public java.io.Reader getCharacterStream(int p)
                                  throws java.sql.SQLException

Returns the value of the parameter as a java.io.Reader.

Specified by:: getCharacterStream in interface java.sql.CallableStatement

Parameters:: p - parameter number
Returns:: the Reader, null if the value is SQL NULL
Throws:: java.sql.SQLException - if an error occurs
Since:: 1.6

getCharacterStream

public java.io.Reader getCharacterStream(java.lang.String p)
                                  throws java.sql.SQLException

Returns the value of the parameter as a java.io.Reader.

Specified by:: getCharacterStream in interface java.sql.CallableStatement

Parameters:: p - parameter name
Returns:: the Reader, null if the value is SQL NULL
Throws:: java.sql.SQLException - if an error occurs
Since:: 1.6

getNCharacterStream

public java.io.Reader getNCharacterStream(int p)
                                   throws java.sql.SQLException

CA IDMS does not support National Character Sets

Specified by:: getNCharacterStream in interface java.sql.CallableStatement

Parameters:: p - parameter number, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6

getNCharacterStream

public java.io.Reader getNCharacterStream(java.lang.String p)
                                   throws java.sql.SQLException

CA IDMS does not support National Character Sets

Specified by:: getNCharacterStream in interface java.sql.CallableStatement

Parameters:: p - parameter name, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6

getNClob

public java.sql.NClob getNClob(int p)
                        throws java.sql.SQLException

CA IDMS does not support National Character Sets or Clobs

Specified by:: getNClob in interface java.sql.CallableStatement

Parameters:: p - parameter number, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6

getNClob

public java.sql.NClob getNClob(java.lang.String p)
                        throws java.sql.SQLException

CA IDMS does not support National Character Sets or Clobs

Specified by:: getNClob in interface java.sql.CallableStatement

Parameters:: p - parameter name, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6

getNString

public java.lang.String getNString(int p)
                            throws java.sql.SQLException

CA IDMS does not support National Character Sets

Specified by:: getNString in interface java.sql.CallableStatement

Parameters:: p - parameter number, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6

getNString

public java.lang.String getNString(java.lang.String p)
                            throws java.sql.SQLException

CA IDMS does not support National Character Sets

Specified by:: getNString in interface java.sql.CallableStatement

Parameters:: p - parameter name, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6

getRowId

public java.sql.RowId getRowId(int p)
                        throws java.sql.SQLException

ROWID is not applicable for procedures in CA IDMS

Specified by:: getRowId in interface java.sql.CallableStatement

Parameters:: p - parameter number, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6

getRowId

public java.sql.RowId getRowId(java.lang.String p)
                        throws java.sql.SQLException

ROWID is not applicable for procedures in CA IDMS

Specified by:: getRowId in interface java.sql.CallableStatement

Parameters:: p - parameter name, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6

getSQLXML

public java.sql.SQLXML getSQLXML(int p)
                          throws java.sql.SQLException

CA IDMS does not support XML data type

Specified by:: getSQLXML in interface java.sql.CallableStatement

Parameters:: p - parameter number, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6

getSQLXML

public java.sql.SQLXML getSQLXML(java.lang.String p)
                          throws java.sql.SQLException

CA IDMS does not support XML data type

Specified by:: getSQLXML in interface java.sql.CallableStatement

Parameters:: p - parameter name, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6

setAsciiStream

public void setAsciiStream(java.lang.String p,
                           java.io.InputStream in)
                    throws java.sql.SQLException

Sets a parameter to an ASCII stream value. This method accepts no length parameter. It calls setAsciiStream(String, InputStream, int) passing a length which is the maximum size of a CHAR column in IDMS (32,760 bytes).

Specified by:: setAsciiStream in interface java.sql.CallableStatement

Parameters:: p - parameter name; in - the java input stream which contains the ASCII parameter value
Throws:: java.sql.SQLException - if a database-access error occurs.
Since:: 1.6

setAsciiStream

public void setAsciiStream(java.lang.String p,
                           java.io.InputStream in,
                           long len)
                    throws java.sql.SQLException

Sets a parameter to an ASCII stream value. This method accepts a long as a length parameter. It calls setAsciiStream(String, InputStream, int) passing either the specified length, or the maximum size of a CHAR column in IDMS (32,760 bytes), whichever is less.

Specified by:: setAsciiStream in interface java.sql.CallableStatement

Parameters:: p - parameter name; in - the java input stream which contains the ASCII parameter value; len - the number of bytes in the stream
Throws:: java.sql.SQLException - if a database-access error occurs.
Since:: 1.6

setBinaryStream

public void setBinaryStream(java.lang.String p,
                            java.io.InputStream in)
                     throws java.sql.SQLException

Sets a parameter to a Binary Stream value. This method accepts no length parameter. It calls setBinaryStream(String, InputStream, int) passing a length which is the maximum size of a BINARY column in IDMS (32,760 bytes).

Specified by:: setBinaryStream in interface java.sql.CallableStatement

Parameters:: p - parameter name; in - the java input stream which contains the binary parameter value
Throws:: java.sql.SQLException - if a database-access error occurs.
Since:: 1.6

setBinaryStream

public void setBinaryStream(java.lang.String p,
                            java.io.InputStream in,
                            long len)
                     throws java.sql.SQLException

Sets a parameter to a Binary stream value. This method accepts a long as a length parameter. It calls setBinaryStream(String, InputStream, int) passing either the specified length, or the maximum size of a BINARY value in IDMS (32,760 bytes), whichever is less.

Specified by:: setBinaryStream in interface java.sql.CallableStatement

Parameters:: p - parameter name; in - the java input stream which contains the binary parameter value; len - the number of bytes in the stream
Throws:: java.sql.SQLException - if a database-access error occurs.
Since:: 1.6

setBlob

public void setBlob(java.lang.String p,
                    java.sql.Blob v)
             throws java.sql.SQLException

CA IDMS doesn't support Blob data type

Specified by:: setBlob in interface java.sql.CallableStatement

Parameters:: v - parameter value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6

setBlob

public void setBlob(java.lang.String p,
                    java.io.InputStream v)
             throws java.sql.SQLException

CA IDMS doesn't support Blob data type

Specified by:: setBlob in interface java.sql.CallableStatement

Parameters:: v - parameter value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6

setBlob

public void setBlob(java.lang.String p,
                    java.io.InputStream arg1,
                    long arg2)
             throws java.sql.SQLException

CA IDMS doesn't support Blob data type

Specified by:: setBlob in interface java.sql.CallableStatement

Parameters:: p - parameter name, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6

setCharacterStream

public void setCharacterStream(java.lang.String p,
                               java.io.Reader in)
                        throws java.sql.SQLException

Sets a parameter to a Character Stream value. This method accepts no length parameter. It calls setCharacterStream(String, Reader, int) passing a length which is the maximum size of a CHAR column in IDMS (32,760 bytes).

Specified by:: setCharacterStream in interface java.sql.CallableStatement

Parameters:: p - parameter name; in - the java input stream which contains the character parameter value
Throws:: java.sql.SQLException - if a database-access error occurs.
Since:: 1.6

setCharacterStream

public void setCharacterStream(java.lang.String p,
                               java.io.Reader in,
                               long len)
                        throws java.sql.SQLException

Sets a parameter to a Character stream value. This method accepts a long as a length parameter. It calls setCharacterStream(String, Reader, int) passing either the specified length, or the maximum size of a CHAR column in IDMS (32,760 bytes), whichever is less.

Specified by:: setCharacterStream in interface java.sql.CallableStatement

Parameters:: p - parameter name; in - the java input stream which contains the character parameter value; len - the number of bytes in the stream
Throws:: java.sql.SQLException - if a database-access error occurs.
Since:: 1.6

setClob

public void setClob(java.lang.String p,
                    java.sql.Clob arg1)
             throws java.sql.SQLException

CA IDMS doesn't support Clob type

Specified by:: setClob in interface java.sql.CallableStatement

Parameters:: p - parameter name, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6

setClob

public void setClob(java.lang.String p,
                    java.io.Reader arg1)
             throws java.sql.SQLException

CA IDMS doesn't support Clob type

Specified by:: setClob in interface java.sql.CallableStatement

Parameters:: p - parameter name, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6

setClob

public void setClob(java.lang.String p,
                    java.io.Reader arg1,
                    long arg2)
             throws java.sql.SQLException

CA IDMS doesn't support Clob type

Specified by:: setClob in interface java.sql.CallableStatement

Parameters:: p - parameter name, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6

setNCharacterStream

public void setNCharacterStream(java.lang.String p,
                                java.io.Reader arg1)
                         throws java.sql.SQLException

CA IDMS doesn't support National Character Sets

Specified by:: setNCharacterStream in interface java.sql.CallableStatement

Parameters:: p - parameter name, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6

setNCharacterStream

public void setNCharacterStream(java.lang.String p,
                                java.io.Reader arg1,
                                long arg2)
                         throws java.sql.SQLException

CA IDMS doesn't support National Character Sets

Specified by:: setNCharacterStream in interface java.sql.CallableStatement

Parameters:: p - parameter name, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6

setNClob

public void setNClob(java.lang.String p,
                     java.sql.NClob arg1)
              throws java.sql.SQLException

CA IDMS doesn't support National Character Sets or Clobs

Specified by:: setNClob in interface java.sql.CallableStatement

Parameters:: p - parameter name, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6

setNClob

public void setNClob(java.lang.String p,
                     java.io.Reader arg1)
              throws java.sql.SQLException

CA IDMS doesn't support National Character Sets or Clobs

Specified by:: setNClob in interface java.sql.CallableStatement

Parameters:: p - parameter name, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6

setNClob

public void setNClob(java.lang.String p,
                     java.io.Reader arg1,
                     long arg2)
              throws java.sql.SQLException

CA IDMS doesn't support National Character Sets or Clobs

Specified by:: setNClob in interface java.sql.CallableStatement

Parameters:: p - parameter name, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6

setNString

public void setNString(java.lang.String p,
                       java.lang.String arg1)
                throws java.sql.SQLException

CA IDMS doesn't support National Character Sets

Specified by:: setNString in interface java.sql.CallableStatement

Parameters:: p - parameter name, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6

setRowId

public void setRowId(java.lang.String p,
                     java.sql.RowId arg1)
              throws java.sql.SQLException

ROWID is not applicable for procedures in CA IDMS

Specified by:: setRowId in interface java.sql.CallableStatement

Parameters:: p - parameter name, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6

setSQLXML

public void setSQLXML(java.lang.String p,
                      java.sql.SQLXML arg1)
               throws java.sql.SQLException

CA IDMS doesn't support XML data type

Specified by:: setSQLXML in interface java.sql.CallableStatement

Parameters:: p - parameter name, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6

setAsciiStream

public void setAsciiStream(int p,
                           java.io.InputStream in,
                           int len)
                    throws java.sql.SQLException

This method is a subclass of the identically-named IdmsPreparedStatement method which allows checking for possible mixing of ordinal and named parameter binding. See the description of the IdmsPreparedStatement method for details.

Specified by:: setAsciiStream in interface java.sql.PreparedStatement
Overrides:: setAsciiStream in class IdmsPreparedStatement

Parameters:: p - parameter index starting at 1; in - the java input stream which contains the ASCII parameter value; len - the maximum number of bytes in the stream
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.

setAsciiStream

public void setAsciiStream(int p,
                           java.io.InputStream in)
                    throws java.sql.SQLException

Specified by:: setAsciiStream in interface java.sql.PreparedStatement
Overrides:: setAsciiStream in class IdmsPreparedStatement

Parameters:: p - parameter number; in - the java input stream which contains the ASCII parameter value
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.

setAsciiStream

public void setAsciiStream(int p,
                           java.io.InputStream in,
                           long len)
                    throws java.sql.SQLException

Specified by:: setAsciiStream in interface java.sql.PreparedStatement
Overrides:: setAsciiStream in class IdmsPreparedStatement

Parameters:: p - parameter number; in - the java input stream which contains the ASCII parameter value; len - the number of bytes in the stream
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.

setBigDecimal

public void setBigDecimal(int p,
                          java.math.BigDecimal v)
                   throws java.sql.SQLException

Specified by:: setBigDecimal in interface java.sql.PreparedStatement
Overrides:: setBigDecimal in class IdmsPreparedStatement

Parameters:: p - parameter index starting at 1; v - the parameter value
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds value would be truncated, or a database error occurs.

setBinaryStream

public void setBinaryStream(int p,
                            java.io.InputStream in,
                            int len)
                     throws java.sql.SQLException

Specified by:: setBinaryStream in interface java.sql.PreparedStatement
Overrides:: setBinaryStream in class IdmsPreparedStatement

Parameters:: p - parameter index starting at 1; in - the java input stream which contains the binary parameter value; len - the number of bytes in the stream
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.

setBinaryStream

public void setBinaryStream(int p,
                            java.io.InputStream in)
                     throws java.sql.SQLException

Specified by:: setBinaryStream in interface java.sql.PreparedStatement
Overrides:: setBinaryStream in class IdmsPreparedStatement

Parameters:: p - parameter number; in - the java input stream which contains the binary parameter value
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.

setBinaryStream

public void setBinaryStream(int p,
                            java.io.InputStream in,
                            long len)
                     throws java.sql.SQLException

Specified by:: setBinaryStream in interface java.sql.PreparedStatement
Overrides:: setBinaryStream in class IdmsPreparedStatement

Parameters:: p - parameter name; in - the java input stream which contains the binary parameter value; len - the number of bytes in the stream
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.

setByte

public void setByte(int p,
                    byte v)
             throws java.sql.SQLException

Specified by:: setByte in interface java.sql.PreparedStatement
Overrides:: setByte in class IdmsPreparedStatement

Parameters:: p - parameter index starting at 1; v - the parameter value
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.

setBytes

public void setBytes(int p,
                     byte[] v)
              throws java.sql.SQLException

Specified by:: setBytes in interface java.sql.PreparedStatement
Overrides:: setBytes in class IdmsPreparedStatement

Parameters:: p - parameter index starting at 1; v - the parameter value
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.

setCharacterStream

public void setCharacterStream(int p,
                               java.io.Reader in,
                               int len)
                        throws java.sql.SQLException

Specified by:: setCharacterStream in interface java.sql.PreparedStatement
Overrides:: setCharacterStream in class IdmsPreparedStatement

Parameters:: p - parameter number; in - the input java.io.Reader; len - number of characters
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.

setCharacterStream

public void setCharacterStream(int p,
                               java.io.Reader in)
                        throws java.sql.SQLException

Specified by:: setCharacterStream in interface java.sql.PreparedStatement
Overrides:: setCharacterStream in class IdmsPreparedStatement

Parameters:: p - parameter number; in - the java input stream which contains the character parameter value
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.

setCharacterStream

public void setCharacterStream(int p,
                               java.io.Reader in,
                               long len)
                        throws java.sql.SQLException

Specified by:: setCharacterStream in interface java.sql.PreparedStatement
Overrides:: setCharacterStream in class IdmsPreparedStatement

Parameters:: p - parameter number; in - the java input stream which contains the character parameter value; len - the number of bytes in the stream
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.

setDate

public void setDate(int p,
                    java.sql.Date v)
             throws java.sql.SQLException

Specified by:: setDate in interface java.sql.PreparedStatement
Overrides:: setDate in class IdmsPreparedStatement

Parameters:: p - parameter index starting at 1; v - the parameter value
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.
See Also:: IdmsPreparedStatement.setDate(int,java.sql.Date,Calendar)

setDate

public void setDate(int p,
                    java.sql.Date v,
                    java.util.Calendar c)
             throws java.sql.SQLException

Specified by:: setDate in interface java.sql.PreparedStatement
Overrides:: setDate in class IdmsPreparedStatement

Parameters:: p - parameter number; v - Date value; c - Calendar object specifying time zone information
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.
See Also:: IdmsPreparedStatement.setDate(int,java.sql.Date)

setDouble

public void setDouble(int p,
                      double v)
               throws java.sql.SQLException

Specified by:: setDouble in interface java.sql.PreparedStatement
Overrides:: setDouble in class IdmsPreparedStatement

Parameters:: p - parameter index starting at 1; v - the parameter value
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.

setFloat

public void setFloat(int p,
                     float v)
              throws java.sql.SQLException

Specified by:: setFloat in interface java.sql.PreparedStatement
Overrides:: setFloat in class IdmsPreparedStatement

Parameters:: p - parameter index starting at 1; v - the parameter value
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.

setInt

public void setInt(int p,
                   int v)
            throws java.sql.SQLException

Specified by:: setInt in interface java.sql.PreparedStatement
Overrides:: setInt in class IdmsPreparedStatement

Parameters:: p - parameter index starting at 1; v - the parameter value
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.

setLong

public void setLong(int p,
                    long v)
             throws java.sql.SQLException

Specified by:: setLong in interface java.sql.PreparedStatement
Overrides:: setLong in class IdmsPreparedStatement

Parameters:: p - parameter index starting at 1; v - the parameter value
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.

setNull

public void setNull(int p,
                    int sqlType)
             throws java.sql.SQLException

Specified by:: setNull in interface java.sql.PreparedStatement
Overrides:: setNull in class IdmsPreparedStatement

Parameters:: p - parameter index starting at 1; sqlType - SQL type code defined by java.sql.Types
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.

setNull

public void setNull(int p,
                    int t,
                    java.lang.String n)
             throws java.sql.SQLException

Specified by:: setNull in interface java.sql.PreparedStatement
Overrides:: setNull in class IdmsPreparedStatement

Parameters:: p - parameter number; t - SQL type from java.sql.Types; n - user defined type name, ignored
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.

setObject

public void setObject(int p,
                      java.lang.Object o)
               throws java.sql.SQLException

Specified by:: setObject in interface java.sql.PreparedStatement
Overrides:: setObject in class IdmsPreparedStatement

Parameters:: p - parameter index starting at 1; o - object containing the input parameter value
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.
See Also:: IdmsPreparedStatement.setObject(int, Object, int, int)

setObject

public void setObject(int p,
                      java.lang.Object o,
                      int type)
               throws java.sql.SQLException

Specified by:: setObject in interface java.sql.PreparedStatement
Overrides:: setObject in class IdmsPreparedStatement

Parameters:: p - parameter index starting at 1; o - object containing the input parameter value; type - JDBC SQL type.
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.
See Also:: IdmsPreparedStatement.setObject(int, Object, int, int)

setObject

public void setObject(int p,
                      java.lang.Object o,
                      int type,
                      int scale)
               throws java.sql.SQLException

Specified by:: setObject in interface java.sql.PreparedStatement
Overrides:: setObject in class IdmsPreparedStatement

Parameters:: p - parameter index starting at 1; o - object containing the input parameter value; type - SQL type (as defined in java.sql.Types) to be sent to the database. The scale argument may further qualify this type.; scale - number of digits after the decimal for DECIMAL NUMERIC types, ignored for all other types.
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.

setRowId

public void setRowId(int p,
                     java.sql.RowId arg1)
              throws java.sql.SQLException

ROWID is not applicable for procedures in CA IDMS

Specified by:: setRowId in interface java.sql.PreparedStatement
Overrides:: setRowId in class IdmsPreparedStatement

Parameters:: p - parameter number, ignored; arg1 - the parameter value
Throws:: java.sql.SQLException - always
Since:: 1.6

setShort

public void setShort(int p,
                     short v)
              throws java.sql.SQLException

Specified by:: setShort in interface java.sql.PreparedStatement
Overrides:: setShort in class IdmsPreparedStatement

Parameters:: p - parameter index starting at 1; v - the parameter value
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.

setString

public void setString(int p,
                      java.lang.String v)
               throws java.sql.SQLException

Specified by:: setString in interface java.sql.PreparedStatement
Overrides:: setString in class IdmsPreparedStatement

Parameters:: p - parameter number starting at 1; v - the parameter value
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.

setTime

public void setTime(int p,
                    java.sql.Time v)
             throws java.sql.SQLException

Specified by:: setTime in interface java.sql.PreparedStatement
Overrides:: setTime in class IdmsPreparedStatement

Parameters:: p - parameter index starting at 1; v - the parameter value
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.
See Also:: IdmsPreparedStatement.setTime(int,java.sql.Time,Calendar)

setTime

public void setTime(int p,
                    java.sql.Time v,
                    java.util.Calendar c)
             throws java.sql.SQLException

Specified by:: setTime in interface java.sql.PreparedStatement
Overrides:: setTime in class IdmsPreparedStatement

Parameters:: p - parameter number; v - Time value; c - Calendar object specifying time zone information
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.
See Also:: IdmsPreparedStatement.setTime(int,java.sql.Time)

setTimestamp

public void setTimestamp(int p,
                         java.sql.Timestamp v)
                  throws java.sql.SQLException

Specified by:: setTimestamp in interface java.sql.PreparedStatement
Overrides:: setTimestamp in class IdmsPreparedStatement

Parameters:: p - parameter index starting at 1; v - the parameter value
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.
See Also:: IdmsPreparedStatement.setTimestamp(int,java.sql.Timestamp,Calendar)

setTimestamp

public void setTimestamp(int p,
                         java.sql.Timestamp v,
                         java.util.Calendar c)
                  throws java.sql.SQLException

Specified by:: setTimestamp in interface java.sql.PreparedStatement
Overrides:: setTimestamp in class IdmsPreparedStatement

Parameters:: p - parameter number; v - Timestamp value; c - Calendar object specifying time zone information
Throws:: java.sql.SQLException - if statement has been closed, p is out of bounds or a database error occurs.
See Also:: IdmsPreparedStatement.setTimestamp(int,java.sql.Timestamp)

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

ca.idms.jdbc Class IdmsCallableStatement

getString

getBoolean

getByte

getShort

getInt

getLong

getFloat

getDouble

getBigDecimal

getBytes

getDate

getTime

getTimestamp

getObject

registerOutParameter

registerOutParameter

wasNull

getBigDecimal

getDate

getTime

getTimestamp

getObject

getArray

getBlob

getClob

getRef

registerOutParameter

getArray

getBigDecimal

getBlob

getBoolean

getByte

getBytes

getClob

getDate

getDate

getDouble

getFloat

getInt

getLong

getObject

getObject

getRef

getShort

getString

getTime

getTime

getTimestamp

getTimestamp

getURL

getURL

registerOutParameter

registerOutParameter

registerOutParameter

setAsciiStream

setBigDecimal

setBinaryStream

setBoolean

setByte

setBytes

setCharacterStream

setDate

setDate

setDouble

setFloat

setInt

setLong

setNull

setNull

setObject

setObject

setObject

setShort

setString

setTime

setTime

setTimestamp

setTimestamp

setURL

ca.idms.jdbc
Class IdmsCallableStatement