Jaybird 3.0.6
The following has been changed or fixed since Jaybird 3.0.5
- Fixed: Exceptions during fetch of cached result sets (holdable over commit, scrollable and metadata) prevented prepared statement reuse/re-execute with error "Statement state CURSOR_OPEN only allows next states [CLOSING, PREPARED, ERROR], received EXECUTING" (JDBC-531)
- Improvement: Added
FBManager.setDefaultCharacterSet
to set default database character set during database creation (JDBC-541) - New feature: Support for Firebird 3 case sensitive user names (JDBC-549)
- Fixed: Savepoints did not work in connection dialect 1 as savepoint names were always quoted (JDBC-556)
- Changed: The
DatabaseMetaData
statement cache introduced in Jaybird 3 was unlimited, it is now limited to 12 prepared statements; the least recently used statement will be closed and removed when a new statement is added (JDBC-557) - Fixed:
UPDATE OR INSERT
with existingRETURNING
clause handled incorrectly for generated keys (JDBC-566) - Fixed: Exceptions during initialization of result sets would not properly close the database cursor leading to error "Current statement state (CURSOR_OPEN) does not allow call to prepare" on reuse of the statement (or errors similar to described for JDBC-531 above). (JDBC-571)
A stopgap measure has been added to prevent similar problems from occurring. This will log its use on debug-level with message "ensureClosedCursor has to close a cursor at" and a stacktrace. - New feature: boolean connection property
ignoreProcedureType
to disable usage of metadata for stored procedure types inCallableStatement
. When set totrue
, call escapes andEXECUTE PROCEDURE
will default to useEXECUTE PROCEDURE
and not switch toSELECT
for selectable stored procedures. (JDBC-576) - New feature: connection properties
timeZoneBind
andsessionTimeZone
for limited support for Firebird 4TIME(STAMP) WITH TIME ZONE
types, anddecfloatBind
for limited support for Firebird 4DECFLOAT
types. (JDBC-538) - Fixed: Connection property
defaultIsolation
/isolation
did not work throughDriverManager
, but only onDataSource
implementations. (JDBC-584)
See the full release notes for more information.
The release is also available on maven(*):
<groupId>org.firebirdsql.jdbc</groupId>
<artifactId>jaybird-jdkXX</artifactId>
<version>3.0.6</version>
* The artifactId depends on your target Java version: jaybird-jdk18
for Java 8 and higher, or jaybird-jdk17
for Java 7