JDBC and Sybase

Greenhorn

Posts: 9

posted 21 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Posts: 1514

posted 21 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

brevity is the soul of wit - shakepeare. Tiny ad:

a bit of art, as a gift, the permaculture playing cards

https://gardener-gift.com