|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.apache.derby.vti.VTITemplate
org.apache.derby.catalog.GetProcedureColumns
public class GetProcedureColumns
Use of VirtualTableInterface to provide support for DatabaseMetaData.getProcedureColumns().
This class is called from a Query constructed in java/org.apache.derby.impl.jdbc/metadata.properties:
The VTI will return columns 3-14, an extra column to the specification METHOD_ID is returned to distinguish between overloaded methods.
- PROCEDURE_CAT String => procedure catalog (may be null)
- PROCEDURE_SCHEM String => procedure schema (may be null)
- PROCEDURE_NAME String => procedure name
- COLUMN_NAME String => column/parameter name
- COLUMN_TYPE Short => kind of column/parameter:
- procedureColumnUnknown - nobody knows
- procedureColumnIn - IN parameter
- procedureColumnInOut - INOUT parameter
- procedureColumnOut - OUT parameter
- procedureColumnReturn - procedure return value
- procedureColumnResult - result column in ResultSet
- DATA_TYPE int => SQL type from java.sql.Types
- TYPE_NAME String => SQL type name, for a UDT type the type name is fully qualified
- PRECISION int => precision
- LENGTH int => length in bytes of data
- SCALE short => scale
- RADIX short => radix
- NULLABLE short => can it contain NULL?
- procedureNoNulls - does not allow NULL values
- procedureNullable - allows NULL values
- procedureNullableUnknown - nullability unknown
- REMARKS String => comment describing parameter/column
- METHOD_ID Short => Derby extra column (overloading)
- PARAMETER_ID Short => Derby extra column (output order)
Field Summary | |
---|---|
private static ResultColumnDescriptor[] |
columnInfo
|
private java.lang.String |
columnName
|
private short |
columnType
|
private boolean |
isFunction
|
private boolean |
isProcedure
|
private static java.sql.ResultSetMetaData |
metadata
|
private short |
method_count
|
private short |
nullable
|
private short |
param_number
|
private int |
paramCursor
|
private RoutineAliasInfo |
procedure
|
private int |
returnedTableColumnCount
|
private int |
rowCount
|
private TypeDescriptor |
sqlType
|
private TypeDescriptor |
tableFunctionReturnType
|
Fields inherited from interface java.sql.ResultSet |
---|
CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE |
Constructor Summary | |
---|---|
GetProcedureColumns(AliasInfo aliasInfo,
java.lang.String aliasType)
|
Method Summary | |
---|---|
void |
close()
|
int |
getInt(int column)
|
java.sql.ResultSetMetaData |
getMetaData()
|
short |
getShort(int column)
|
java.lang.String |
getString(int column)
|
boolean |
next()
|
private int |
translate(int val)
|
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Methods inherited from interface java.sql.ResultSet |
---|
getHoldability, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getRowId, getRowId, getSQLXML, getSQLXML, isClosed, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateRowId, updateRowId, updateSQLXML, updateSQLXML |
Methods inherited from interface java.sql.Wrapper |
---|
isWrapperFor, unwrap |
Field Detail |
---|
private boolean isProcedure
private boolean isFunction
private int rowCount
private int returnedTableColumnCount
private TypeDescriptor tableFunctionReturnType
private RoutineAliasInfo procedure
private int paramCursor
private short method_count
private short param_number
private TypeDescriptor sqlType
private java.lang.String columnName
private short columnType
private final short nullable
private static final ResultColumnDescriptor[] columnInfo
private static final java.sql.ResultSetMetaData metadata
Constructor Detail |
---|
public GetProcedureColumns(AliasInfo aliasInfo, java.lang.String aliasType) throws java.sql.SQLException
java.sql.SQLException
Method Detail |
---|
private int translate(int val)
public java.sql.ResultSetMetaData getMetaData()
public boolean next() throws java.sql.SQLException
java.sql.SQLException
public java.lang.String getString(int column) throws java.sql.SQLException
getString
in interface java.sql.ResultSet
getString
in class VTITemplate
java.sql.SQLException
- on unexpected JDBC errorResultSet
public int getInt(int column) throws java.sql.SQLException
getInt
in interface java.sql.ResultSet
getInt
in class VTITemplate
java.sql.SQLException
- on unexpected JDBC errorResultSet
public short getShort(int column) throws java.sql.SQLException
getShort
in interface java.sql.ResultSet
getShort
in class VTITemplate
java.sql.SQLException
- on unexpected JDBC errorResultSet
public void close()
|
Built on Thu 2010-12-23 20:49:13+0000, from revision ??? | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |