IBProvider v5.11. Support of WireCompression

Hello Everyone.

Starting from the current version (5.11), the built-in IBProvider client for Firebird (fb.direct) has support for connection data compression.

To enable compression, just specify «remote:wire_compression=enabled» in the connection string.

By default, IBProvider uses a built-in implementation of data compressor algorithms.

Full news text – https://www.ibprovider.com/eng/news/n_200123.html

Kind Regards, IBProvider Team.

upscene releases new advanced data generator

Upscene Productions is happy to announce the next major version of their test data generator tool:

“Advanced Data Generator 4”

A fast test-data generator tool that comes with a library of real-life data, can generate data to your database,
script or data files, many filling options, templates and much more.

Jaybird 4.0.0-beta-2 available for testing

We are happy to announce the second beta for Jaybird 4.

We’d really appreciate it if you take the time to test this version of Jaybird with your applications. Bug reports about undocumented changes in behavior are appreciated. Feedback can be sent to the Firebird-java mailing list or reported on the issue tracker http://tracker.firebirdsql.org/browse/JDBC.

Jaybird 4 is – compared to Jaybird 3 – an incremental release that builds on the foundations of Jaybird 3. The focus of this release has been on further improving JDBC support and adding support for the new data types and features of Firebird 4.

The main new features are:

  • Wire encryption support (backported to Jaybird 3.0.4)
  • Database encryption support (backported to Jaybird 3.0.4)
  • Wire compression support
  • Authentication plugin improvements
  • Firebird 4 data type bind configuration support (since Jaybird 4.0.0-beta-2)
  • Firebird 4 DECFLOAT support
  • Firebird 4 extended numeric precision support
  • Firebird 4 time zone support
  • Firebird 4 statement timeout support (since Jaybird 4.0.0-beta-2)
  • JDBC RowId support
  • DatabaseMetaData getPseudoColumns implemented
  • DatabaseMetaData getVersionColumns implemented
  • DatabaseMetaData getFunctions implemented (since Jaybird 4.0.0-beta-2)
  • DatabaseMetaData getFunctionColumns implemented (since Jaybird 4.0.0-beta-2)
  • Improved JDBC function escape support
  • New JDBC protocol prefix jdbc:firebird:
  • URL encoding in query part of JDBC URL (backported to Jaybird 3.0.9)
  • Generated keys support improvements
  • Operation monitoring

Jaybird 4.0.0-beta-2 is for testing purposes only, and not intended for production use.

See also:

IBProvider News

In the current update, IBProvider v5.9 and LCPI OLE DB Services v1.12 started to use a common thread pool. This rearrangement of subsystems makes the operating system resource management more efficient and improves the overall performance of high-load applications.

Shared thread pool

Currently, the threads are being used for the following tasks:

  • Connection pool
  • Query pool
  • Asynchronous loading of result sets
  • Asynchronous notifications of the provider
  • Working with files
  • Garbage collection in updatable result sets

Read full news text: https://www.ibprovider.com/eng/news/n_191210-shared_thread_pool.html

Kind Regards, IBProvider Team.

Patched IB DataPump

IB DataPump is an old and very known utility from CleverComponents used to pump data from several source databases to IB/FB databases. Unfortunately, it isn’t updatet from a long time and has a problem with Firebird 3 servers. A few months ago, it became Open Source, so it was possible to fix this problem.

Norbert Saint Georges was kind enough to compile a new version with the fix and provide a download link at tetrasys.fi/data/ibpump.7z

Jaybird 3.0.8 released

Jaybird 3.0.8 has been released. This release contains one bug fix:

  • Fixed: On Firebird 3 and 4 with WireCrypt=Enabled, the connection could hang or throw exceptions like “Unsupported or unexpected operation code”. (JDBC-599)

Jaybird 3.0 supports Firebird 2.0 and higher, on Java 7, 8, 11 and 13. Basic Java 9 and higher compatibility is provided through the Java 8 version of the driver.
See also:

dbMigration .NET v11.7 released

dbMigration .NET v11.7 is a simple, easy and intuitive multiple database migration and data synchronization tool, With it you can easily migrate schema and data to Firebird and vice versa.

https://fishcodelib.com/DBMigration.htm

Jaybird 3.0.7 released

Jaybird 3.0.7 has been released. This release contains a new feature and two bug fixes:

  • Fixed: attempts to use a blob after it was freed or after transaction end could throw a NullPointerException or just work depending on whether the connection had a new transaction. (JDBC-587)
  • Fixed: Instances of java.sql.Blob and java.sql.Clob obtained from a result set were freed after calls to ResultSet.next(). (JDBC-588)
  • New feature: added FBEventManager.createFor(Connection) to create an EventManager for an existing connection. Backported from Jaybird 4. (JDBC-594)

Jaybird 3.0 supports Firebird 2.0 and higher, on Java 7, 8, 11 and 13. Basic Java 9 and higher compatibility is provided through the Java 8 version of the driver.

See also:

1 9 10 11 12 13 147