isLast method for result set is not working

[Shahnawaz Shakil]

Hi,
I am trying to retrieve data (Sybase database) from my web application something as below:

 statement = conn.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE,java.sql.ResultSet.CONCUR_UPDATABLE);
  result = statement.executeQuery(query);
.....
....
.....

for(int i = 0; i < 5; i++)
{
if(result.next()){
.....
....

if(result.isLast()) { break; }
}
 

It seems that result.isLast() method is not working and throwing UnimplementedOperationException. Please suggest.

[Paul Sturrock]

You driver does not implement that method. To fix this you can hunt around for a suitable driver that does - I'm afraid I have no idea if one exists for Sybase - or you can change your logic to achieve what you want.

[Shahnawaz Shakil]

Hi Paul,
I think you are right that it does not exist for sybase. Could you please suggest some logic because i need to come out of the loop once i reach the last row? I don't know how will i come to know if i have reached to the last row without using isLast method. Please help.

[Vijitha Kumara]

Shahnawaz Shakil wrote:Could you please suggest some logic because i need to come out of the loop once i reach the last row?

for(int i = 0; i < 5; i++)
{
if(result.next()){
.....
....

if(result.isLast()) { break; }
}

Can you tell us what is the purpose of this loop? You need to get less than 5 records or what?

[Jan Cumps]

know if i have reached to the last row

When rs.next() == false

We usually travel a resultset using this logic

while(rs.next() {

// .. do something if we have a next record
}

[Shahnawaz Shakil]

Vijitha,
Yes i need to get latest five records or less. Reason for using this for loop.

Thanks Jan and Paul for your help. I have changed the logic and its working fine.

Thanks you all for your help and suggestions.