This week's book giveaway is in the JavaFX forum.
We're giving away four copies of Introducing JavaFX 8 Programming and have Herbert Schildt on-line!
See this thread for details.
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 Introducing JavaFX 8 Programming this week in the JavaFX 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!