Skip to Main Content

jdbc oracle driver fetchsize bug

User_BZU3SOct 25 2022 — edited Oct 25 2022

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

Comments
Post Details
Added on Oct 25 2022
5 comments
32 views