aspose file tools*
The moose likes JDBC 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
Bookmark "JDBC and Sybase" Watch "JDBC and Sybase" New topic
Author

JDBC and Sybase

Chuck Cabrera
Greenhorn

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.
Thanks
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.


Bosun (SCJP, SCWCD)
So much trouble in the world -- Bob Marley
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: JDBC and Sybase