| From: | Stoffel van Aswegen <Stoffelva(at)gmsi(dot)co(dot)za> |
|---|---|
| To: | "PostgreSQL Mailing List (E-mail)" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | JDBC ResultSet |
| Date: | 2001-10-09 09:30:55 |
| Message-ID: | 9D8BB61A24FCD0118E83080036CE960301491D91@ntserver01.gmsi.co.za |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
I have the following Java code:
---snip---
ResultSet rst = pgConnection.openResultSet("SELECT foo, bar from
table1");
while (rst.next))
System.out.println(rst.getString("foo"),
rst.getString("bar"));
---snip---
[I'm writing from memory - not sure if openResultSet is the correct method
name.]
This always only prints _one_ record, which is also the last record. The
docs say that the cursor opens before the first record, so I must be doing
something wrong.
I am using PostgreSQL 6.5 database (yes, I know it's old, but I'm only
playing/learning/prototyping/...) Surely, this is not a pg6.5 problem? Or is
it?
I'd appreciate any pointers.
TIA
Stoffel van Aswegen
import signature.*;
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Travis Hoyt | 2001-10-09 13:24:26 | Rules and Views |
| Previous Message | Stephan Szabo | 2001-10-09 07:44:16 | Re: Corrupted table . . . |