File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
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
 
wood burning stoves
 
subject: JDBC and Sybase