Re: isNullable() - Mailing list pgsql-jdbc

From Rene Pijlman
Subject Re: isNullable()
Date
Msg-id 6am6qt4a4j5cq0dm9tm4cusheknf41e0jf@4ax.com
Whole thread Raw
In response to isNullable()  (Tomisław Kityński <cromax@id.pl>)
List pgsql-jdbc
On Fri, 14 Sep 2001 17:53:50 +0200, you wrote:
>could someone tell me, please, do I have any chance to get
>proper implementation of above method in JDBC (1.1+) soon?

This is a volunteer project. You don't "get", you "bring" :-)

>Current "return 1" works fine on most tables, however it seems
>to be a little bit incorrect with some of them ;)

ResultSetMetaData.isNullable() is currently unimplemented and
always returns ResultSetMetaData.columnNullable. This is
obviously incorrect when a column is defined with NOT NULL or
PRIMARY KEY. And we have to think of check constraints, views,
functions etc.

I propose to change it to return
ResultSetMetaData.columnNullableUnknown until someone comes up
with a real implementation.

Any objections?

Regards,
René Pijlman <rene@lab.applinet.nl>

pgsql-jdbc by date:

Previous
From: "Dave Thompson"
Date:
Subject: default fetch size
Next
From: Rene Pijlman
Date:
Subject: Re: isNullable()