| 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: | Whole Thread | Raw Message | 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
| 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 |