Re: [GENERAL] jdbc driver, error trapping.

I can't reproduce this error on either current sources or on 7.0.3.  It
appears you are running 7.0 (at least the RPMs you mention xxx-7.0-3 are
for 7.0, not 7.0.3.  The 7.0.3 RPMs are named xxx-7.0.3-2).  I would
recommend upgrading to 7.0.3.

thanks,
--Barry

Matthew Taylor wrote:
>
> I might have missed the obvious, but currently having the following
> behaviour.
>
> If I run the following java code,
>
> try{
> ResultSet rs = stmt.executeQuery("select blah from blah");
> while(rs.next())
> {
> System.out.println("result = "+rs.getString("blah") );
> }
> rs.close();
> }catch (Exception ex)
> {
> System.out.println("error="+ex.toString() );
> }
>
> on a table that has NO records in it, I get an error thrown 'No results were
> returned by the query'. I would like to keep the try catch blocks since
>
> 1. I am converting from Oracle backend which works fine otherwise.
> 2. some of my sql is dynamically generated, hence the try catch normally
> only picks up bad sql.
>
> any suggestions?? It's late and I'm prol not thinking straight...
>
> (ps: using postgresql-7.0.-3, jdk1.1.8, postgresql-jdbc-7.0-3 installed via
> rpm's.)
> Mat.
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.