File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC and Sybase

 
Chuck Cabrera
Greenhorn
Posts: 9
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I want to use a Sybase set option, SET ROWCOUNT 50. I want to use this for only 1 query. How do I use JDBC to accomplish this? I tried using rs.setFetchSize(50) and it does not seem to work. I am using weblogic connected to Sybase.
Thanks
 
Bosun Bello
Ranch Hand
Posts: 1510
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Even thought that function exists for Sybase, the driver you are using to access the database may not support it.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic