com.sas.storage.flattened.sasmdx
Class FlattenResultSetMetadata

com.sas.storage.flattened.sasmdx.FlattenResultSetMetadata
All Implemented Interfaces:
java.sql.ResultSetMetaData, java.sql.Wrapper

public class FlattenResultSetMetadata
implements java.sql.ResultSetMetaData

FlattenResultSetMetadata class surfaces the column information for the Flatten ResultSet. An instance of this class can be used to get information about the types and properties of the columns in a ResultSet object.


Method Summary
 void close()
           
 java.lang.String getCatalogName(int columnNumber)
          Get the Catalog name of the specified column
 java.lang.String getColumnClassName(int columnNumber)
          Returns the fully-qualified name of the Java class whose instances are manufactured if the method ResultSet.getObject is called to retrieve a value from the column.
 int getColumnCount()
          Returns the number of columns in this resultset
 int getColumnDisplaySize(int columnNumber)
          Get the maximum width in characters of the specified column
 int getColumnIndex(java.lang.String columnName)
           
 java.lang.String getColumnLabel(int columnNumber)
          Gets the designated column's suggested title for use.
 java.lang.String getColumnName(int columnNumber)
          Get the column name of the specified column
 int getColumnType(int columnNumber)
          Retrieves the designated column's SQL type.
 java.lang.String getColumnTypeName(int columnNumber)
          Retrieves the designated column's database-specific type name.
 int getPrecision(int columnNumber)
          Get the specified column's, number of decimal digits
 int getScale(int columnNumber)
          Gets the specified column's number of digits to right of the decimal point.
 java.lang.String getSchemaName(int p1)
           
 java.lang.String getTableName(int columnNumber)
          Get the table name for the specified columnNumber
 boolean isAutoIncrement(int columnNumber)
          Return if the specified column is automatically numbered, that is readOnly
 boolean isCaseSensitive(int columnNumber)
          Indicates whether the specified column's case matters
 boolean isCurrency(int columnNumber)
          Indicates whether the designated column is a cash value.
 boolean isDefinitelyWritable(int columnNumber)
          Specifies if a write on the specified column will definitely succeed
 int isNullable(int columnNumber)
          Indicates the nullability of values in the designated column.
 boolean isReadOnly(int columnNumber)
          Indicates wheteher this column is read only
 boolean isSearchable(int columnNumber)
          Indicates whether this column can be used in where clause
 boolean isSigned(int columnNumber)
          Indicates whether values in the designated column are signed numbers.
 boolean isWrapperFor(java.lang.Class<?> iface)
           
 boolean isWritable(int columnNumber)
          Return if it is possible to write to the specified column
<T> T
unwrap(java.lang.Class<T> iface)
           
 

Method Detail

close

public void close()

getSchemaName

public java.lang.String getSchemaName(int p1)
                               throws java.sql.SQLException
Specified by:
getSchemaName in interface java.sql.ResultSetMetaData
Throws:
java.sql.SQLException

isSearchable

public boolean isSearchable(int columnNumber)
                     throws java.sql.SQLException
Indicates whether this column can be used in where clause

Specified by:
isSearchable in interface java.sql.ResultSetMetaData
Parameters:
columnNumber -
Throws:
java.sql.SQLException

getPrecision

public int getPrecision(int columnNumber)
                 throws java.sql.SQLException
Get the specified column's, number of decimal digits

Specified by:
getPrecision in interface java.sql.ResultSetMetaData
Parameters:
columnNumber -
Throws:
java.sql.SQLException

isAutoIncrement

public boolean isAutoIncrement(int columnNumber)
                        throws java.sql.SQLException
Return if the specified column is automatically numbered, that is readOnly

Specified by:
isAutoIncrement in interface java.sql.ResultSetMetaData
Parameters:
columnNumber -
Throws:
java.sql.SQLException

isWritable

public boolean isWritable(int columnNumber)
                   throws java.sql.SQLException
Return if it is possible to write to the specified column

Specified by:
isWritable in interface java.sql.ResultSetMetaData
Parameters:
columnNumber -
Throws:
java.sql.SQLException

getCatalogName

public java.lang.String getCatalogName(int columnNumber)
                                throws java.sql.SQLException
Get the Catalog name of the specified column

Specified by:
getCatalogName in interface java.sql.ResultSetMetaData
Parameters:
columnNumber -
Throws:
java.sql.SQLException

getColumnDisplaySize

public int getColumnDisplaySize(int columnNumber)
                         throws java.sql.SQLException
Get the maximum width in characters of the specified column

Specified by:
getColumnDisplaySize in interface java.sql.ResultSetMetaData
Parameters:
columnNumber -
Throws:
java.sql.SQLException

getColumnName

public java.lang.String getColumnName(int columnNumber)
                               throws java.sql.SQLException
Get the column name of the specified column

Specified by:
getColumnName in interface java.sql.ResultSetMetaData
Parameters:
columnNumber -
Throws:
java.sql.SQLException

getTableName

public java.lang.String getTableName(int columnNumber)
                              throws java.sql.SQLException
Get the table name for the specified columnNumber

Specified by:
getTableName in interface java.sql.ResultSetMetaData
Parameters:
columnNumber -
Throws:
java.sql.SQLException

isDefinitelyWritable

public boolean isDefinitelyWritable(int columnNumber)
                             throws java.sql.SQLException
Specifies if a write on the specified column will definitely succeed

Specified by:
isDefinitelyWritable in interface java.sql.ResultSetMetaData
Parameters:
columnNumber -
Throws:
java.sql.SQLException

getColumnTypeName

public java.lang.String getColumnTypeName(int columnNumber)
                                   throws java.sql.SQLException
Retrieves the designated column's database-specific type name.

Specified by:
getColumnTypeName in interface java.sql.ResultSetMetaData
Parameters:
columnNumber -
Throws:
java.sql.SQLException

isCaseSensitive

public boolean isCaseSensitive(int columnNumber)
                        throws java.sql.SQLException
Indicates whether the specified column's case matters

Specified by:
isCaseSensitive in interface java.sql.ResultSetMetaData
Parameters:
columnNumber -
Throws:
java.sql.SQLException

isReadOnly

public boolean isReadOnly(int columnNumber)
                   throws java.sql.SQLException
Indicates wheteher this column is read only

Specified by:
isReadOnly in interface java.sql.ResultSetMetaData
Parameters:
columnNumber -
Throws:
java.sql.SQLException

getScale

public int getScale(int columnNumber)
             throws java.sql.SQLException
Gets the specified column's number of digits to right of the decimal point.

Specified by:
getScale in interface java.sql.ResultSetMetaData
Parameters:
columnNumber -
Throws:
java.sql.SQLException

isSigned

public boolean isSigned(int columnNumber)
                 throws java.sql.SQLException
Indicates whether values in the designated column are signed numbers.

Specified by:
isSigned in interface java.sql.ResultSetMetaData
Parameters:
columnNumber -
Throws:
java.sql.SQLException

isNullable

public int isNullable(int columnNumber)
               throws java.sql.SQLException
Indicates the nullability of values in the designated column.

Specified by:
isNullable in interface java.sql.ResultSetMetaData
Throws:
java.sql.SQLException

isCurrency

public boolean isCurrency(int columnNumber)
                   throws java.sql.SQLException
Indicates whether the designated column is a cash value.

Specified by:
isCurrency in interface java.sql.ResultSetMetaData
Parameters:
columnNumber -
Throws:
java.sql.SQLException

getColumnCount

public int getColumnCount()
                   throws java.sql.SQLException
Returns the number of columns in this resultset

Specified by:
getColumnCount in interface java.sql.ResultSetMetaData
Throws:
SQLEXception
java.sql.SQLException

getColumnClassName

public java.lang.String getColumnClassName(int columnNumber)
                                    throws java.sql.SQLException
Returns the fully-qualified name of the Java class whose instances are manufactured if the method ResultSet.getObject is called to retrieve a value from the column.

Specified by:
getColumnClassName in interface java.sql.ResultSetMetaData
Parameters:
columnNumber -
Throws:
java.sql.SQLException

getColumnLabel

public java.lang.String getColumnLabel(int columnNumber)
                                throws java.sql.SQLException
Gets the designated column's suggested title for use.

Specified by:
getColumnLabel in interface java.sql.ResultSetMetaData
Throws:
java.sql.SQLException

getColumnType

public int getColumnType(int columnNumber)
                  throws java.sql.SQLException
Retrieves the designated column's SQL type.

Specified by:
getColumnType in interface java.sql.ResultSetMetaData
Throws:
java.sql.SQLException
See Also:
Types

getColumnIndex

public int getColumnIndex(java.lang.String columnName)
                   throws java.sql.SQLException
Throws:
java.sql.SQLException

unwrap

public <T> T unwrap(java.lang.Class<T> iface)
         throws java.sql.SQLException
Specified by:
unwrap in interface java.sql.Wrapper
Throws:
java.sql.SQLException

isWrapperFor

public boolean isWrapperFor(java.lang.Class<?> iface)
                     throws java.sql.SQLException
Specified by:
isWrapperFor in interface java.sql.Wrapper
Throws:
java.sql.SQLException



Copyright © 2009 SAS Institute Inc. All Rights Reserved.