xerial/sqlite-jdbc

SQLITE_TOOBIG since upgrad to java 21 and 3.48.1.0

andreasholzgethan opened this issue · 2 comments

andreasholzgethan commented

Hi everyone,

in our project we have struggles since we've upgraded our versions.
We've upgraded the sqlite-jdbc from 3.28.0 to 3.48.1.0 and the Java Version from 1.8 to 21.

Since this upgrade we are getting the following errors:
Cause: org.sqlite.SQLiteException: [SQLITE_TOOBIG] String or BLOB exceeds size limit (statement too long)

With the versions 3.28.0 and 1.8 the same sql statement is working. May someone know why this is not working anymore?

Thanks!

Best
Andreas

gotson commented

There is no such version as 3.48.1.0.

3.28.0 is from 2019, there are a lot of changes since then. Limits are enforced in SQLite now, you need to change them to allow higher limits if you don't want to shorten your statements.

andreasholzgethan commented

Sorry my fault, I meant version 3.45.1.0 :)

Ok thanks for the fast answer! We will have a look on the limits.

Best Andreas