Re: NULL values and Java JDBC

From: Matthias Apitz <guru(at)unixarea(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: NULL values and Java JDBC
Date: 2022-09-30 16:25:16
Message-ID: YzcYbP3fnAqBTvPO@c720-r368166
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

El día viernes, septiembre 30, 2022 a las 09:56:07a. m. -0600, Rob Sargent escribió:

> On 9/30/22 09:46, Matthias Apitz wrote:
> > Hello,
> >
> > Columns may contain NULL values. The ecpg for pre-compiling ESQL/C code
> > has an option to let return NULL values in CHAR columns as empty strings ""
> > and INTEGER as INT_MIN (-0x7fffffff - 1) values. Is there a similar
> > option for Java JDBC?
> >

> Have you looked at java.sql.PreparedStatement.setNull() or .setObject() etc?

I was thinking more in a general setting of such feature (like ecpg does
it for ESQL/C) and not addressing such problem on any single statement
or object.

matthias

--
Matthias Apitz, ✉ guru(at)unixarea(dot)de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2022-09-30 16:39:38 Re: Postgresql database and application server compatibility
Previous Message Rob Sargent 2022-09-30 15:56:07 Re: NULL values and Java JDBC