cancel
Showing results for 
Search instead for 
Did you mean: 

jconn driver return 500 records instead of a lot more sometimes

Former Member
0 Kudos
3,223

Hi all; I need some help and I am pretty out of ideas. I am using Jboss 5.1 with apache commons dbcp over sybase jconn driver to communicate with SQL Anywhere 12.0.1 I have some stored procs I execute that need to return about 10k records but for some reason return exactly 500 most of the time. sometimes on first use of a "clean" connection from the pool I get the proper result size. I cant really put my hands over this. does the number 500 ring a bell to anyone? is this some kind of a known cache size somewhere in the DB side or the driver side?

up until now I have tried com.sybase.jdbc3.jdbc.SybDataSource and com.sybase.jdbc4.jdbc.SybDataSource as my drivers and got the same result. I dont use any special connection params. I am sorry that I dont have any more info but I though this might ring a bell. I think the problems started with the upgrade from SQL Anywhere 10.0 to 12 but I am not sure.

any help would be greatly appreciated.

Accepted Solutions (0)

Answers (1)

Answers (1)

Breck_Carter
Participant