Jaybird 3.0.6 released

We are happy to announce the release of Jaybird 3.0.6.

This release is largely a bugfix release, but contains additional support for Firebird 4.

Jaybird 3.0.6 contains the following fixes and changes:

  • 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 existing RETURNING 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)
  • New feature: boolean connection property ignoreProcedureType to disable usage of metadata for stored procedure types in CallableStatement When set to true>, call escapes and EXECUTE PROCEDURE will default to use EXECUTE PROCEDURE and not switch to SELECT for selectable stored procedures. (JDBC-576)
  • New feature: connection properties timeZoneBind and sessionTimeZone for limited support for Firebird 4 TIME(STAMP) WITH TIME ZONE types, and decfloatBind for limited support for Firebird 4 DECFLOAT types. (JDBC-538)
  • Fixed: Connection property defaultIsolation/isolation did not work through DriverManager, but only on DataSource implementations. (JDBC-584)

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

See also:

1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 5.00 out of 5)
Loading...

IBProvider v5.4 and LCPI ADO.NET Provider for OLE DB v1.13

Hello All,

We are pleased to annonce update of our components for work with Firebird and InterBase DBMS.

https://www.ibprovider.com/eng/news/n_190520.html

IBProvider v5.4

  • Improved authentication code of builtin client for Firebird 3.0 (13th protocol).
  • Improved code quality in general.

LCPI ADO.NET provider for OLE DB v1.13

  • Improved OleDbConnection.AttachToNativeSession method.

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 3.00 out of 5)
Loading...

Jaybird 4.0.0-beta-1 available for testing

The first beta for Jaybird 4 is available for testing.

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)
  • Authentication plugin improvements
  • Firebird 4 DECFLOAT support
  • Firebird 4 extended numeric precision support
  • Firebird 4 time zone support
  • JDBC RowId support
  • JDBC DatabaseMetaData.getPseudoColumns implemented
  • JDBC DatabaseMetaData.getVersionColumns implemented
  • Improved JDBC function escape support
  • New JDBC protocol prefix jdbc:firebird:
  • Generated keys support improvements

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

See also:

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading...

IBProvider News. Support For Visual Studio 2019

Hello All!

In latest update of our components, we offer support for Visual Studio 2019, which was released a week ago:

  1. New DDEX providers (v1.12) for our ADO.NET provider (FW4.5, FW4.6.2, FW4.7.2) and VS2019. The installation instruction is the same as for Visual Studio 2017.
  2. IBProvider v5.3.1 compiled by VS2019 (signature of binaries – vc16)

IBProvider vc16 builds (32/64bit) have gone through load testing, so you can start using them in your solutions without any problems.

This news at our web site: https://www.ibprovider.com/eng/news/n_190411-vs2019.html

Thanks&Regards. IBProvider Team.

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 3.00 out of 5)
Loading...

Daily Export Firebird data to AWS Aurora

Bipost Sync new release! A tool design to daily export FirebirdSQL data to AWS S3 and Aurora-MySQL. New features include:

  • Tenant: an option to send data from multiple Firebird databases and consolidate on a single AWS Aurora-MySQL database.
  • Firebird 3.x support.
  • Send data from new engines (Sybase SQL Anywhere).

Contact information: info@factorbi.com MX: +521 (55) 7656-4690 US: +1 (646) 504-7812

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

DB Explorer For Firebird Databases

Explore and run queries against your Firebird® databases without leaving VS Code. This extension allows you to connect directly to your Firebird databases, list tables and fields, run queries, display/export results and more.

Features

NEW! SQL Mock Data Generator
Manage multiple database connections
List hosts, databases, tables and fields inside Explorer View
Firebird Reserved Words Code Completion
Table and field names Code Completion
Run Firebird SQL queries
Run predefined custom queries
View results in a table
Realtime results filtering and sorting
Export results to JSON, CSV, XSLX or PDF file

Find more here.
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Database .NET v27.2 released

Database .NET v27.2 is an innovative, powerful and intuitive multiple database management tool.

https://fishcodelib.com/Database.htm

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

IBProvider News

Hello All,

We want to notify about two updates of IBProvider, which finalize migration from v3 to v5.

IBProvider v5.1
  • Improved integration of provider subsystems.
IBProvider v5.2
  • Removed obsolete OLE DB properties.
Special offer

We offer 12+4 months of support and upgrades to anyone, who purchases licenses for IBProvider (32/64bit) until the end of March 2019.

Thanks&Regards, IBProvider Team.

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...
1 2 3 135