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	isWritable(int columnNumber) Return if it is possible to write to the specified column

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