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
>
>
>