Re: ResultSetMetaData.isNullable

From: Barry Lind <blind(at)xythos(dot)com>
To: snpe <snpe(at)snpe(dot)co(dot)yu>
Cc: "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: ResultSetMetaData.isNullable
Date: 2003-05-03 00:27:05
Message-ID: 3EB30CD9.9000403@xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Haris,

In 7.3 and earlier it really isn't possible to return more correct
information, since the jdbc driver doesn't know what the table and
column names are that make to an individual column result.

However in 7.4 with the changes in the FE/BE protocol this will be
possible. But it will be a lot of work to change over to use the new
protocol so it may take a while before all of this is changed.

thanks,
--Barry

snpe wrote:
> Hello,
> ResultSetMetaData.isNullable return always java.sql.ResultSetMetaData.columnNullableUnknown.
> Is it possible that this function return "null/not null" as "null/not null" in a table in the database.
> I have found this comment in source :
> *
> * TODO This needs a real implementation, taking into account columns
> * defined with NOT NULL or PRIMARY KEY, CHECK constraints, views,
> * functions etc.
> */
> It isn't important for PRIMARY KEY (must be not null), other constraints, triggers - this function is only for first impression.
> I need this function for access right in forms.
>
> Please help
>
> regards
> Haris Peco
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2003-05-03 00:39:10 Re: SELECT clause no relation found.
Previous Message snpe 2003-05-02 18:56:37 ResultSetMetaData.isNullable