ca.idms.jdbc
Class IdmsParameterMetaData

java.lang.Object
  ca.idms.io.TraceObject
      ca.idms.jdbc.IdmsJdbcObject
          ca.idms.jdbc.IdmsMetaData
              ca.idms.jdbc.IdmsParameterMetaData

All Implemented Interfaces:

Trace, SQLState, java.sql.ParameterMetaData, java.sql.Wrapper

public class IdmsParameterMetaData
extends IdmsMetaData
implements java.sql.ParameterMetaData

A ParameterMetaData object can be used to find out about the types and properties of the parameters in a PreparedStatement.

Since:

1.4

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

parameterModeIn, parameterModeInOut, parameterModeOut, parameterModeUnknown, parameterNoNulls, parameterNullable, parameterNullableUnknown

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.lang.String	getParameterClassName(int p) Gets the Java class name corresponding to the type as it would be used by PreparedStatment.setObject.
int	getParameterCount() Gets the number of parameters.
int	getParameterMode(int p) Gets the parameter's IN/OUT mode.
int	getParameterType(int p) What type is it?
java.lang.String	getParameterTypeName(int p) Gets the data source specific type name?
int	isNullable(int p) Can you set it to NULL?

Methods inherited from class ca.idms.jdbc.IdmsMetaData

getPrecision, getScale, isSigned

Methods inherited from class ca.idms.jdbc.IdmsJdbcObject

clearWarnings, get, getWarnings, hasCursor, hasUpdate, isStarted, isSuspended, isWrapperFor, notifyStatementError, unwrap

Methods inherited from class ca.idms.io.TraceObject

finalize, 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.ParameterMetaData

getPrecision, getScale, isSigned

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Method Detail

getParameterCount

public int getParameterCount()
                      throws java.sql.SQLException

Gets the number of parameters.

Specified by:

getParameterCount in interface java.sql.ParameterMetaData

Returns:

the value of SQLDA.SQLD

Throws:

java.sql.SQLException - not really.

Since:

1.4

getParameterMode

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

Gets the parameter's IN/OUT mode. Parameters in SQL statements are considered INOUT only if:

• the SQL command is CALL
• the owner class is IdmsCallableStatement
• the CallSelect option is not enabled

In all other cases they are considered IN.

Specified by:

getParameterMode in interface java.sql.ParameterMetaData

Parameters:

p - parameter number starting with 1, ignored

Returns:

parameterModeIn or parameterModeInOut

Throws:

java.sql.SQLException - not really

Since:

1.4

See Also:

IdmsConnectOptions

isNullable

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

Can you set it to NULL?

Specified by:

isNullable in interface java.sql.ParameterMetaData

Parameters:

p - parameter number starting with 1

Returns:

paramaterNoNulls or paramaterNullable

Throws:

java.sql.SQLException - if parameter number is out of range.

Since:

1.4

getParameterType

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

What type is it?

Specified by:

getParameterType in interface java.sql.ParameterMetaData

Parameters:

p - parameter number starting with 1

Returns:

SQL type

Throws:

java.sql.SQLException - if parameter number is out of range.

Since:

1.4

getParameterTypeName

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

Gets the data source specific type name?

Specified by:

getParameterTypeName in interface java.sql.ParameterMetaData

Parameters:

p - parameter number starting with 1

Returns:

type name

Throws:

java.sql.SQLException - if parameter number is out of range.

Since:

1.4

getParameterClassName

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

Gets the Java class name corresponding to the type as it would be used by PreparedStatment.setObject.

Specified by:

getParameterClassName in interface java.sql.ParameterMetaData

Parameters:

p - parameter number starting with 1

Returns:

class name

Throws:

java.sql.SQLException - if parameter number is out of range.

Since:

1.4