RE: does the 7.0.2 JDBC driver support absolute() - Mailing list pgsql-interfaces

From Peter Mount
Subject RE: does the 7.0.2 JDBC driver support absolute()
Date
Msg-id 1B3D5E532D18D311861A00600865478CF1B4BE@exchange1.nt.maidstone.gov.uk
Whole thread Raw
In response to does the 7.0.2 JDBC driver support absolute()  (matthew denner <matt@evtechnology.com>)
List pgsql-interfaces
Yes, it's been supported for some time, although there are some problems.

Just browsed the source and I can see a problem where:

index<0 then it moves the current row to the index row from the end.
index<numrows then it moves to that row.

However, the second rule also matches <0, so it takes precedence and we end
up moving to row index-1 regardless. Not the required result.

I'm fixing it in cvs now.

Anyhow, absolute should return true if the row exists, but false if it
doesn't (ie ==0 or > num rows in resultset).

Peter

-- 
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: petermount@maidstone.gov.uk
WWW: http://www.maidstone.gov.uk
All views expressed within this email are not the views of Maidstone Borough
Council


-----Original Message-----
From: matthew denner [mailto:matt@evtechnology.com]
Sent: Wednesday, November 01, 2000 4:46 PM
To: pgsql-interfaces@postgresql.org
Subject: [INTERFACES] does the 7.0.2 JDBC driver support absolute()


Dear all,

i have been trying to use the ResultSet.absolute() call with no success so
i'm mailing to find out if this is supported.  if it isn't then why is the
code present in absolute()?  why does absolute() return true for valid rows
and false for invalid rows? and why can i do beforeFirst() to move before
the
first line?

Cheers,
Matt

----------------------------------------------------------------------------
-
Sessami is a trademark of Escape Velocity Technology Mobile Services
Limited.
All information contained in this e-mail is confidential and for the use of
the addressee only.  If you receive this message in error please notify.


pgsql-interfaces by date:

Previous
From: matthew denner
Date:
Subject: does the 7.0.2 JDBC driver support absolute()
Next
From: Magnus Hagander
Date:
Subject: RE: RE: new maintainer for the ODBC driver?