search

xerial / sqlite-jdbc

SQLite JDBC Driver
Apache License 2.0
2.86k stars 619 forks source link

SQLITE_TOOBIG since upgrad to java 21 and 3.48.1.0 #1108

Closed andreasholzgethan closed 6 months ago

andreasholzgethan commented 6 months ago

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 6 months ago

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 6 months ago

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