Re: Null integers in Oracle and Java

Hmm, I've never tried that, but that won't appear to work if the result set contained more than one field...will it?

cindy

Timo Biesenbach wrote:

> Hi,
>
> you can test if the data is null with the wasNull() Method of the
> ResultSet Object:
>
> while (rset.next()) {
> int i = rset.getInt(1);
> if rset.wasNull() {
> doTheErrorHandling
> }
> }
>
> -Timo
> --
> +---+---+-+-+-+-+
> | | |-+-+-+-+ Fraunhofer-Institut fuer Graphische Datenverarbeitung
> +---+---+-+-+-+-+ Fraunhofer-Institute for Computer Graphics
> | | |-+-+-+-+ Abteilung / Department : Document Imaging
> +---+---+-+-+-+-+
> | __ _ | Dipl.Ing. (BA) Timo Biesenbach
> | ! ! _ ! \ | Rundeturmstr. 6 phone ++49 6151 155 578
> | ! !__! !_/ | 64283 Darmstadt fax ++49 6151 155 299
> +---------------+ Germany email timo.biesenbach_at_igd.fhg.de
Received on Wed Feb 23 2000 - 02:37:57 CST