Aster JDBC trouble - IS_NULLABLE/NULLABLE metadata


Aster JDBC trouble - IS_NULLABLE/NULLABLE metadata


 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 ( {
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 (1)