• Post Reply Bookmark Topic Watch Topic
  • New Topic

st.setFetchSize(10) -help (urgent)  RSS feed

 
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
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!