Problem asking columns allowing NULL values - Mailing list pgsql-jdbc

From .
Subject Problem asking columns allowing NULL values
Date
Msg-id 20030408192300.6d1e73bb.alzina@inicia.es
Whole thread Raw
Responses Re: Problem asking columns allowing NULL values
List pgsql-jdbc
Hello,
I'm trying to ask a PostgreSQL server, using its JDBC driver, if the columns of
a table allow NULL values. To do so, I look at the value of the field
columnNullable (class ResultSetMetaData). Simply put, if I have a ResultSet
"rs" filled with rows from a query, I do the following:



ResultSetMetaData rsmeta = rs.getMetaData();

   if (rsmeta.columnNullable == 1)
    System.out.printl("null values allowed");
   else
    System.out.printl("null values NOT allowed");



The result says that *all* columns allow NULL values, although I've defined
several of them with the clause "NOT NULL" (I've checked that this columns does
really not allow NULL values, trying INSERT statements with psql).

I'm using the last stable release of the JDBC driver. Somebody else have
suffered the same problem? Or I'm doing something wrong? I'd be very grateful
if somebody could help me.


pgsql-jdbc by date:

Previous
From: Todd Cornett
Date:
Subject: Bug in getImportedExportedKeys(), DatabaseMetaData class
Next
From: Dave Cramer
Date:
Subject: Re: Problem asking columns allowing NULL values