about rs.last

Expand Post »

Java Syntax (Toggle Plain Text)
stm =con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
					rs=stm.executeQuery(qry);
rs.last();
String s=rs.getString(1);
stm =con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
					rs=stm.executeQuery(qry);
rs.last();
String s=rs.getString(1);

I have backend as sybase.
But above code is throwing an error as follows:

Java Syntax (Toggle Plain Text)
Error [Sybase][ODBC Driver][Adaptive Server Enterprise]HEADERFORMAT1 not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output)
Error [Sybase][ODBC Driver][Adaptive Server Enterprise]HEADERFORMAT1 not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output)

srs_grp

Reputation Points: 9

Solved Threads: 0

Light Poster

Offline

34 posts
since Sep 2008

Permalink

Jan 19th, 2009

Re: about rs.last

First we need what is in your "qry" variable.
Also if you want is use features like rs.last() etc, then I recommend you use a scroll insensitive resultset.

Last edited by stephen84s; Jan 19th, 2009 at 8:12 am.

stephen84s

Featured Poster

Reputation Points: 653

Solved Threads: 151

Nearly a Posting Virtuoso

Offline

1,316 posts
since Jul 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Java Forum Timeline: New Jave Student needs a little guidance

Next Thread in Java Forum Timeline: returing the current year

DaniWeb Message

Cancel Changes

User Name
Password