Regardless of the version of the driver, as long as the sql statement is like this, the fetchsize setting is invalid and always returns 1
sql is as follows:
select tab.TABLE_NAME,tab.COLUMN_NAME
,tab.DATA_TYPE,tab.COLUMN_ID,tab.DATA_DEFAULT,tab.NULLABLE,com.COMMENTS
,tab.CHAR_LENGTH
from user_tab_columns tab, user_col_comments com
where tab.COLUMN_NAME =com.COLUMN_NAME
and com.TABLE_NAME=tab.TABLE_NAME
And I found that sql like this doesn't work either:
select * from user_tab_columns
When I change the same jdbc configuration to other sql, it is normal