• Post Reply Bookmark Topic Watch Topic
  • New Topic

st.setFetchSize(10) -help (urgent)

 
ramkumar chandramohan
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
In JSP pages, I want retrieve 10 records per page from SQL server database thro JDBC, SO i used stmt.setFetchSize(10);
method . ofcourse my primarykey value is an integer, but while execute, throwing error saying that the method not found in SQL statement. what should i do.
Thanks
Ramkumar.c
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Personally I think this is a query more relevant to the JDBC forum (but I might be biased )...
there is a good conversation on paging resultsets here
If the problem is with the setFetchSize call, check your driver version. It needs to be Java 1.2 and JDBC2.0 complient.
Dave
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!