File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes JDBC and Sybase Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC and Sybase" Watch "JDBC and Sybase" New topic

JDBC and Sybase

Chuck Cabrera

Joined: Jan 20, 2002
Posts: 9
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.
Bosun Bello
Ranch Hand

Joined: Nov 06, 2000
Posts: 1510
Even thought that function exists for Sybase, the driver you are using to access the database may not support it.

So much trouble in the world -- Bob Marley
I agree. Here's the link:
subject: JDBC and Sybase
It's not a secret anymore!