All Packages  Class Hierarchy  This Package  Previous  Next  Index

Class interbase.interclient.ResultSetMetaData 

java.lang.Object
   |
   +----interbase.interclient.ResultSetMetaData
public final class ResultSetMetaData
extends Object
implements ResultSetMetaData
A ResultSetMetaData object can be used to find out about the types and properties of the columns in a ResultSet.

Variable Index

o columnNoNulls
Does not allow NULL values.
o columnNullable
Allows NULL values.
o columnNullableUnknown
Nullability unknown.

Method Index

o getCatalogName(int)
Get the column's table's catalog name.
o getColumnCount()
Get the number of columns in the ResultSet.
o getColumnDisplaySize(int)
What's the column's normal max width in chars?
o getColumnLabel(int)
Get the suggested column title for use in printouts and displays.
o getColumnName(int)
Get the column's name.
o getColumnType(int)
Get the column's SQL type.
o getColumnTypeName(int)
Get the column's data source specific type name.
o getPrecision(int)
Get the column's number of decimal digits.
o getScale(int)
Get the column's number of digits to right of the decimal point.
o getSchemaName(int)
Get the column's table's schema name.
o getTableName(int)
Get the column's table name.
o isAutoIncrement(int)
Is the column automatically numbered, thus read-only?
o isCaseSensitive(int)
Does a column's case matters?
o isCurrency(int)
Can the column can be used to represent a cash value?
o isDefinitelyWritable(int)
Will a write on the column definitely succeed?
o isNullable(int)
Can you can put a NULL in this column?
o isReadOnly(int)
Is a column definitely not writable?
o isSearchable(int)
Can a column be used in a where clause?
o isSigned(int)
Can the column can contain signed numbers?
o isWritable(int)
Is it possible for a write on the column to succeed?

Variables

o columnNoNulls 
  public final static int columnNoNulls
Does not allow NULL values.

o columnNullable 
  public final static int columnNullable
Allows NULL values.

o columnNullableUnknown 
  public final static int columnNullableUnknown
Nullability unknown.

Methods

o getColumnCount 
  public int getColumnCount() throws SQLException
Get the number of columns in the ResultSet.

o isAutoIncrement 
  public boolean isAutoIncrement(int column) throws SQLException
Is the column automatically numbered, thus read-only?

Note: It is not known how to detect a generator field using InterBase system tables.

Parameters:
column - the first column is 1, the second is 2, ...
Returns:
always false for InterClient.
o isCaseSensitive 
  public boolean isCaseSensitive(int column) throws SQLException
Does a column's case matters?

Text fields in InterBase are always case sensitive, even text BLObs when using the 'containing' operator.

Parameters:
column - the first column is 1, the second is 2, ...
Returns:
always true for InterBase.
o isSearchable 
  public boolean isSearchable(int column) throws SQLException
Can a column be used in a where clause?

In InterBase, even a BLOb field can be used in a where clause, eg. WHERE blob-field CONTAINING foobar

Parameters:
column - the first column is 1, the second is 2, ...
Returns:
always true for InterBase.
o isCurrency 
  public boolean isCurrency(int column) throws SQLException
Can the column can be used to represent a cash value? InterBase does not support a money type.

Parameters:
column - the first column is 1, the second is 2, ...
Returns:
always false for InterBase.
o isNullable 
  public int isNullable(int column) throws SQLException
Can you can put a NULL in this column?

Note: Unlike other RDBMS vendors, InterBase will always know column nullability and never return columnNullableUnknown.

Parameters:
column - the first column is 1, the second is 2, ...
Returns:
columnNoNulls, columnNullable or columnNullableUnknown
o isSigned 
  public boolean isSigned(int column) throws SQLException
Can the column can contain signed numbers?

Parameters:
column - the first column is 1, the second is 2, ...
o getColumnDisplaySize 
  public int getColumnDisplaySize(int column) throws SQLException
What's the column's normal max width in chars?

Parameters:
column - the first column is 1, the second is 2, ...
o getColumnLabel 
  public String getColumnLabel(int column) throws SQLException
Get the suggested column title for use in printouts and displays.

Parameters:
column - the first column is 1, the second is 2, ...
o getColumnName 
  public String getColumnName(int column) throws SQLException
Get the column's name.

Parameters:
column - the first column is 1, the second is 2, ...
o getSchemaName 
  public String getSchemaName(int column) throws SQLException
Get the column's table's schema name.

Parameters:
column - the first column is 1, the second is 2, ...
Returns:
schema name or "" if not applicable
Throws: SQLException
InterBase does not support schemas.
o getPrecision 
  public int getPrecision(int column) throws SQLException
Get the column's number of decimal digits.

Parameters:
column - the first column is 1, the second is 2, ...
o getScale 
  public int getScale(int column) throws SQLException
Get the column's number of digits to right of the decimal point.

Parameters:
column - the first column is 1, the second is 2, ...
o getTableName 
  public synchronized String getTableName(int column) throws SQLException
Get the column's table name.

Returns:
table name or "" if not applicable
o getCatalogName 
  public String getCatalogName(int column) throws SQLException
Get the column's table's catalog name.

Parameters:
column - the first column is 1, the second is 2, ...
Returns:
catalog name or "" if not applicable
Throws: SQLException
InterBase does not support Catalogs.
o getColumnType 
  public int getColumnType(int column) throws SQLException
Get the column's SQL type.

Map the stored InterBase Type to the SQL Type.

Parameters:
column - the first column is 1, the second is 2, ...
Returns:
SQL type
See Also:
Types
o getColumnTypeName 
  public String getColumnTypeName(int column) throws SQLException
Get the column's data source specific type name.

Parameters:
column - the first column is 1, the second is 2, ...
Returns:
InterBase type name for the column.
o isReadOnly 
  public boolean isReadOnly(int column) throws SQLException
Is a column definitely not writable?

Parameters:
column - the first column is 1, the second is 2, ...
o isWritable 
  public synchronized boolean isWritable(int column) throws SQLException
Is it possible for a write on the column to succeed?

Parameters:
column - the first column is 1, the second is 2, ...
o isDefinitelyWritable 
  public boolean isDefinitelyWritable(int column) throws SQLException
Will a write on the column definitely succeed?

Note: InterBase can never guarantee this.

Parameters:
column - the first column is 1, the second is 2, ...
Returns:
false for InterBase. 
All Packages  Class Hierarchy  This Package  Previous  Next  Index