Developing Tools and Using Cloudscape with an IDE
Page 2 of 5

Working with Metadata for Java Data Types

Tools often use the JDBC ResultSetMetaData class to get information about data in a particular table. However, JDBC is limited to standard SQL-92 data types. As you know, Cloudscape can store Java data types.

ResultSetMetaData.getColumnType returns the name of the Java class for the data stored in that column. For example, if a column serializes JBMSTours.City, getColumnType returns "JBMSTours.City". (However, there is no explicit information is returned to indicate that this type is a Java data type.)

Result set metadata for columns that store Java data types and metadata items that describe the type of the column always return the following default values:

Method Name

Value

getColumnDisplaySize

15

getPrecision

0

getScale

0

isAutoIncrement

false

isCaseSensitive

false

isCurrency

false

isSigned

false

These attributes do not typically apply to Java data types.

To get more information about the Java class, use the Java reflection mechanism (java.lang.reflect.*).