Dear Oliver & Roland,
You guys are rite. I got rid fo the dependency on getFetchSize() and my program works fine now. Thanks for the timely help.
sarvesh
Oliver Jowett wrote:
Roland Walter wrote:
As far as I know, getFetchSize() will return 0 in all cases.
It is not possible to use this for getting the count of
selected rows. Remove the if (num>0) below.
Yes, this'll be the cause: older driver versions incorrectly returned
the resultset size from getFetchSize(), but newer drivers follow the
spec and return whatever you set via setFetchSize(), default 0.
-O