exception while upgrading driver

From: Sathyajith G <sathyajith(at)inbox(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: exception while upgrading driver
Date: 2005-06-07 18:41:11
Message-ID: 9648E4D3482.000004D1sathyajith@inbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi
i have the following code running without any errors with postgres 7.4.2.
driver.

String qry="select MAX(num) from (select
to_number((substr(acr_id,4)),'9999') as num from aircraft where acr_id like
'ACR%' group by acr_id) as num "; // order by num desc";

try{
ResultSet rs=Data.getResultSet(qry);
while(rs.next())
{
try{
acrmax=Integer.parseInt(rs.getString(1))+1;
}catch(NumberFormatException ne){acrmax=0;}
}
}
catch(SQLException ex) { System.err.println("for rs1 err
"+ex.getMessage());
}

I changed the driver to postgres 8.0.1. Strangely now, the above code gives
the exception "The resultset is closed". Please help.

regards,

Sathya

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2005-06-07 19:15:59 Re: exception while upgrading driver
Previous Message Sunil.Vishnubhotla 2005-06-07 18:37:05 8.x driver with EJB CMP