setFetchSize Mariadb jdbcdriver version 3.0.4

user_3833111 0
Viewed 1785

We encounter an error when we go from 2.7.2 et 3.0.4 maridb jdbc driver with setFetchSize(Integer.MIN_VALUE)

java.sql.SQLSyntaxErrorException: (conn=27489500) invalid fetch size

So we switch to setFetchSize(1)

https://mariadb.com/kb/en/about-mariadb-connector-j/

Before version 1.4.0, the only accepted value for fetch size was Statement.setFetchSize(Integer.MIN_VALUE) (equivalent to Statement.setFetchSize(1)). This value is still accepted for compatilibity reasons but rather use Statement.setFetchSize(1), since according to JDBC the value must be >= 0.

And I found nothing in the release notes.

mariadb jdbc
1 Answers

This is a connector or idea bug, you need to downgrade.

I have the same problem, on the datagrid, searching the forums, the recommended solution is to reduce the version until the fix is released.

Ref: https://youtrack.jetbrains.com/issue/DBE-16376

user_29238720
Related