| From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
|---|---|
| To: | Nahum Castro <nahumcastro(at)gmail(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: next() error |
| Date: | 2005-02-03 23:05:12 |
| Message-ID: | 4202AE28.2080300@opencloud.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Nahum Castro wrote:
> javax.servlet.ServletException: ResultSet not positioned properly,
> perhaps you need to call next.
> Has changed something on the server or on the driver?
Newer drivers follow the JDBC specification more strictly.
> ResultSet RecordsetPubs1 = StatementRecordsetPubs1.executeQuery();
> boolean RecordsetPubs1_isEmpty = ! RecordsetPubs1.next();
> boolean RecordsetPubs1_hasData = ! RecordsetPubs1_isEmpty;
[...]
> <td align="left" width="50%"><%=(((RecordsetPubs1_data =
> RecordsetPubs1.getObject("au_id"))==null ||
> RecordsetPubs1.wasNull())?"":RecordsetPubs1_data)%></td>
You appear to be calling ResultSet.getObject() even if ResultSet.next()
returned false. You're not allowed to do this -- see the JDBC javadoc.
-O
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nahum Castro | 2005-02-04 00:35:35 | Re: next() error |
| Previous Message | Nahum Castro | 2005-02-03 22:51:14 | next() error |