FirebirdSQL / jaybird

JDBC driver for Firebird
https://firebirdsql.org/en/jdbc-driver/
GNU Lesser General Public License v2.1
94 stars 23 forks source link

Support statements longer than 64KB with native/embedded connections #713

Closed mrotteveel closed 2 years ago

mrotteveel commented 2 years ago

Since Firebird 3.0, Firebird supports statement texts longer than 64KB (with a server imposed internal limit of 10MB). This is already supported in the pure-java implementation, but not in the native/embedded implementations.

To pass statements longer than 64KB in native/embedded, a Firebird 3.0 or higher client library is required, and a null-terminated string should be offered to isc_dsql_prepare (pass length 0 and a null-terminated string, instead of actual length and normal string).