PostgreSQL JDBC drive does not fully support JDK1.3

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

Browse pgsql-general by date

  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