Java

about rs.last

Please support our Java advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: Sep 2008

Posts: 34

Reputation: srs_grp is an unknown quantity at this point

Solved Threads: 0

srs_grp

Offline

Light Poster

about rs.last

Jan 19th, 2009

 Help with Code Tags 
 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:

 Help with Code Tags 
 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)

•

Join Date: Jul 2007

Posts: 1,175

Reputation: stephen84s is a glorious beacon of light

Solved Threads: 125

stephen84s stephen84s is offline

Offline

Veteran Poster

Re: about rs.last

Jan 19th, 2009

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.

"Any fool can write code that a computer can understand. Good programmers write code that humans can understand."

"How to ask questions the smart way ?"