oracle-r2dbc icon indicating copy to clipboard operation
oracle-r2dbc copied to clipboard

OracleR2dbcOptions doesn't support defaultRowPrefetch

Open kano5252 opened this issue 1 year ago • 3 comments

It seems 1.2 Oracle r2dbc doesn't support defaultRowPrefetch ConnectionPropety

here's the issue: Oracle version: 19c spring boot r2dbc 3.2.5 I have a table (80k rows ), select all data using R2dbcTemplate which needs nearly 63 seconds, on DB visualizer Tool after set JDBC Fetch size to 5000, it only needs 0.6s, As far as I know, JDBC fetch Size is defaultRowPrefetch in Oracle, but seems it's not supported yet, please advise how to set it.

kano5252 avatar May 29 '24 07:05 kano5252