File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
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: 1506
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
Similar Threads
accesing a database
How to handle RAISEERROR in Sybase using JDBC
sybase related jdbc question
How to get desired no of rows from a select stmt
Java and Sybase