setFetchSize() in JDBC

[Gauri attal]

Hi,

Can anyone give me a small excutable example on setFetchSize() method in JDBC?

When i am working with it,
<<can not connect to the databasejava.sq l.SQLException: Invalid Fetch Size>>
is the given error report. can u please help me out with a small example?

Thank You,
Gauri.

[JosAH]

Hi,

Can anyone give me a small excutable example on setFetchSize() method in JDBC?

When i am working with it,
<<can not connect to the databasejava.sq l.SQLException: Invalid Fetch Size>>
is the given error report. can u please help me out with a small example?

Thank You,
Gauri.

Did you specify a fetch size < 0?

kind regards,

Jos

[Gauri attal]

Did you specify a fetch size < 0?

kind regards,

Jos

Hi,

No, i dint specify fetch size <0..What ever be the size given, the same error, as said in the previous mail,is reported..

ThankYou,
Gauri.

[JosAH]

Hi,

No, i dint specify fetch size <0..What ever be the size given, the same error, as said in the previous mail,is reported..

ThankYou,
Gauri.

This sounds creepy; I understand that you didn't set any fetch size yourself?
I suspect a configuration error somewhere or even a wrong jdbc driver ...
Have you checked all that?

kind regards,

Jos