| From: | Raymond Chui <raymond(dot)chui(at)noaa(dot)gov> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | PostgreSQL JDBC drive does not fully support JDK1.3 |
| Date: | 2001-03-29 13:41:34 |
| Message-ID: | 3AC33B8E.816FB703@noaa.gov |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I am using PostgreSQL JDBC drive jdbc7.0-1.2.jar on Redhat Linux 6.5
with PostgreSQL 7.0.3-2
When I
ResultSet result = statement.executeQuery(sqlStatement);
int fromRow = 10;
int toRow = 20;
// my SQL statement returns few thousand rows to ResultSet
// I only want to display result.next() fromRow to toRow
result.absolute(fromRow)
int rowNumber = result.getRow();
out.println("Current row = " + rowNumber);
// Here is the problem, the result.absolute(int i) never go the row
number i
// It always stay in row 0 !!
while(result.next()) {
rowNumber = result.getRow();
if (rowNumber > toRow)
break;
// else display rows
// ......
}
--Raymond
| Attachment | Content-Type | Size |
|---|---|---|
| raymond.chui.vcf | text/x-vcard | 414 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pluto | 2001-03-29 13:54:52 | Data access permission? |
| Previous Message | Russell Hires | 2001-03-29 12:50:21 | Re: Determine Time in other Time Zone |