All Forums Aster
kkolman 1 post Joined 06/13
26 Jun 2013
Aster JDBC trouble - IS_NULLABLE/NULLABLE metadata

Hi,
 trying to use Aster JDBC driver to query database tables & columns.

ResultSet columns = null;
DatabaseMetaData metaData = connection.getMetaData();
ResultSet columns = metaData.getColumns(null, schema, tableName, "%");
while (columns.next()) {
    String columnName = columns.getString("COLUMN_NAME");
    boolean notNull = columns.getBoolean("IS_NULLABLE");
    int nullability = columns.getInt("NULLABLE");
    ...
}

The issue i am seeing is that:
 - IS_NULLABLE is always true
 - NULLABLE is always 0 (= DatabaseMetadata.columnNoNulls)
no matter whether the table's columns are marked NOT NULL or not.
 
This seems like a bug to me.
The jdbc driver version is "noarch-aster-jdbc-driver-5.0.3-r30596.jar" 

Tags:
You must sign in to leave a comment.