SQLITE_TOOBIG since upgrad to java 21 and 3.48.1.0

[andreasholzgethan]

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]

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]

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