Better Oracle JDBC driver

[garyaiki]

I'm told the Oracle thin driver returns a resultset 1 row at a time. So I'm shopping for a better driver. Which drivers are better? What have people tried?

[rcleveng]

> I'm told the Oracle thin driver returns a resultset 1
> row at a time. So I'm shopping for a better driver.
> Which drivers are better? What have people tried?

Actually the Oracle JDBC drivers don't fetch one at a time. By default they use 10, however you can set this with the setFetchSize method.

See http://docs.oracle.com/cd_a91034/DOC/java.901/a90211/resltset.htm#1023642

Hope this helps,

Rob