ResultSet Problem

I have procedure which return 2 ResultSet .I want that second ResultSet be

scrollable.I use the execute method but on scrolling it throwsResult set type is TYPE_FORWARD_ONLY.My Statement is

Statement st=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,

ResultSet.CONCUR_READ_ONLY);

When i use ExecuteQuery to return one resultset no error occur.Please Help me it is very urgent

Thanks Vijay

[433 byte] By [vijaysofta] at [2007-10-2 10:43:55]

# 1

Could you provide me the code which you are using to perform this task? I can suggest you solution.

sudheer_d123a at 2007-7-13 2:54:06 >

# 2

Actually class is very lengthy .Following code throws the error

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con = DriverManager.getConnection("jdbc:odbc:fvigil","sa","password");

Statement st=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);

String Query="EXEC SPVendorWiseBillingReport '"+Client_Id+"','"+Vendor_Id+

"','"+From_Date+"','"+To_Date+"'";

st.execute(Query);

ResultSet rs=st.getResultSet();

rs.last();

rs.getRow();

rs.beforeFirst();

vijaysofta at 2007-7-13 2:54:06 >

Enterprise & Remote Computing New Topic