org.apache.derby.catalog

Class GetProcedureColumns

java.lang.Object

org.apache.derby.vti.VTITemplate

org.apache.derby.catalog.GetProcedureColumns

All Implemented Interfaces:

java.lang.AutoCloseable, java.sql.ResultSet, java.sql.Wrapper, AwareVTI

public class GetProcedureColumns
extends VTITemplate

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)
  

Nested Class Summary

Nested classes/interfaces inherited from class org.apache.derby.vti.VTITemplate

VTITemplate.ColumnDescriptor

Field Summary

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

Constructors

Constructor and Description
GetProcedureColumns(AliasInfo aliasInfo, java.lang.String aliasType)

Method Summary

Modifier and Type	Method and Description
void	close()
int	getInt(int column)
java.sql.ResultSetMetaData	getMetaData()
short	getShort(int column)
java.lang.String	getString(int column)
boolean	next()

Methods inherited from class org.apache.derby.vti.VTITemplate

absolute, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, deleteRow, findColumn, first, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getConcurrency, getContext, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getFetchDirection, getFetchSize, getFloat, getFloat, getHoldability, getInt, getLong, getLong, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getObject, getRef, getRef, getReturnTableSignature, getRow, getRowId, getRowId, getShort, getSQLXML, getSQLXML, getStatement, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, insertRow, isAfterLast, isBeforeFirst, isClosed, isFirst, isLast, isWrapperFor, last, moveToCurrentRow, moveToInsertRow, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setContext, setFetchDirection, setFetchSize, unwrap, updateArray, updateArray, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateClob, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateRef, updateRef, updateRow, updateRowId, updateRowId, updateShort, updateShort, updateSQLXML, updateSQLXML, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp, wasNull

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface java.sql.ResultSet

updateObject, updateObject, updateObject, updateObject

Constructor Detail

GetProcedureColumns

public GetProcedureColumns(AliasInfo aliasInfo,
                           java.lang.String aliasType)
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

Method Detail

getMetaData

public java.sql.ResultSetMetaData getMetaData()

Specified by:

getMetaData in interface java.sql.ResultSet

Overrides:

getMetaData in class VTITemplate

next

public boolean next()
             throws java.sql.SQLException

Throws:

java.sql.SQLException

getString

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

Specified by:

getString in interface java.sql.ResultSet

Overrides:

getString in class VTITemplate

Throws:

java.sql.SQLException

getInt

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

Specified by:

getInt in interface java.sql.ResultSet

Overrides:

getInt in class VTITemplate

Throws:

java.sql.SQLException

getShort

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

Specified by:

getShort in interface java.sql.ResultSet

Overrides:

getShort in class VTITemplate

Throws:

java.sql.SQLException

close

public void close()