Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
Date: Wed, 22 Feb 2006 21:20:00 +0100
From: "Bernt M. Johnsen" <Bernt.Johnsen@Sun.COM>
Subject: Re: ResultSet.getInt()
In-reply-to: <43FCC067.6010103@network-inventory.de>
To: Derby Discussion <derby-user@db.apache.org>,
        thomas.vatter@network-inventory.de
Message-id: <20060222202000.GA15031@localhost.localdomain>
Organization: Sun Microsystems
MIME-version: 1.0
Content-type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature"; boundary=1yeeQ81UyVL57Vl7
Content-disposition: inline
User-Agent: Mutt/1.5.9i
References: <43FCC067.6010103@network-inventory.de>


--1yeeQ81UyVL57Vl7
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

I think your answer lies in the description of wasNull()

  boolean wasNull()
                throws SQLException

    Reports whether the last column read had a value of SQL NULL. Note
    that you must first call one of the getter methods on a column to
    try to read its value and then call the method wasNull to see if
    the value read was SQL NULL.

You have not called RS.getXXX() and thus the excpetion is correct.


>>>>>>>>>>>> Thomas Vatter wrote (2006-02-22 20:49:59):
>=20
> I have a problem using ResultSet.getInt() method, each call returns an=20
> exception:
> org.apache.derby.client.am.SqlException: Invalid operation:
> wasNull() called with no data retrieved
>        at org.apache.derby.client.am.ResultSet.wasNull(Unknown Source)
>=20
> The code is
>        ResultSetMetaData RSMD =3D RS.getMetaData();
>        int INTcols =3D RSMD.getColumnCount();
>        String STRtemp =3D null;
>        while(RS.next())
>        {
>            String STRvalue =3D new String();          =20
>            for(int INTcol =3D 1; INTcol <=3D INTcols; INTcol++)
>            {
>                int INTdummy =3D RSMD.getColumnType(INTcol);             =
=20
>                switch((int)RSMD.getColumnType(INTcol))
>                {
>                        if(!RS.wasNull()) // raises exception
>                       =20
> {                                                                        =
  =20
>=20
>                            STRvalue =3D "" +=20
> RSaktuelles.getInt(INTcol);                                             =
=20
>                        }=20
>        ...
>        }
>         }
>    }
>=20
> what can I do to avoid this exception
>=20
> tom
>=20

--=20
Bernt Marius Johnsen, Database Technology Group,=20
Staff Engineer, Technical Lead Derby/Java DB
Sun Microsystems, Trondheim, Norway

--1yeeQ81UyVL57Vl7
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFD/MdwlFBD9TXBAPARArY5AKDDgEIpCXcgd1Y1OJJiL/IwacZj0QCgoPN/
1t38x7N9g0FCyoGbW29sT2s=
=8BS7
-----END PGP SIGNATURE-----

--1yeeQ81UyVL57Vl7--