problem in randomly fetching data from mssql databse using scrollable resultset

From: Praveen homkar via JavaKB.com (forum_at_JavaKB.com)
Date: 03/14/05 

Date: Mon, 14 Mar 2005 14:39:16 GMT

Hi all
i have a gui based application which conects a MSSQL-server 2000.

I have buttons such as first-previous-next-last buttons to navigate
throught the database. I am using scrollable resultset
  st=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);

i want to fetch a particualr row based on the primary key passed.

i am incrementing a number whenever user presses next button.

I am using rs.absolute();

but its giving invalid cursor state error.

Please help me with some code that allows fast and random navigation

i am using type 1 driver(jdbc-odbc) bridge) 

-- 
Message posted via http://www.javakb.com