Thread: NULL values and Java JDBC

NULL values and Java JDBC

From
Matthias Apitz
Date:
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?

Thanks

    matthias

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



Re: NULL values and Java JDBC

From
Rob Sargent
Date:
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?

Thanks
	matthias

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

Re: NULL values and Java JDBC

From
Matthias Apitz
Date:
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@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub