[GENERAL] PostgreSQL JDBC drive does not fully support JDK1.3

[Raymond Chui]

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


begin:vcard 
n:Chui;Raymond
tel;fax:(301)713-0963
tel;work:(301)713-0624 Ext. 168
x-mozilla-html:TRUE
url:http://members.xoom.com/rchui/
org:NWS, NOAA
version:2.1
email;internet:[EMAIL PROTECTED]
title:SA, DBA
note:ICQ #: 16722494
adr;quoted-printable:;;NOAA, NWS, Office of Hydrology, OH=0D=0A1325 East-West Highway, Room 8112;Silver Spring;MD;20910-3283;U.S.A.
x-mozilla-cpt:;-6384
fn:Raymond Chui
end:vcard


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly