wood burning stoves 2.0
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
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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: JDBC and Sybase
It's not a secret anymore!