Month: December 2013

Firebird Data Wizard 13.12 released

Leave a comment
Firebird Data Wizard SQL Maestro Group announces the release of Firebird Data Wizard 13.12, a powerful Windows GUI utility for Firebird data management.

Firebird Data Wizard provides you with a number of easy-to-use tools to transfer any database to Firebird, import data into Firebird tables, export data from tables, views and queries to most popular file formats, dump table data to SQL files as well as generate data-driven ASP.NET pages for your database.

New version features updated Data Import and SQL Dump tools, data export to JSON format, redesigned Start Page, and some other useful things.

There are also other useful things as well as versions for other DBMS (MySQL, Oracle, SQL Server, DB2, PostgreSQL, etc). Read full press release.

Jaybird 2.2.4 released

Leave a comment

The Firebird JDBC team is happy to announce the release of Jaybird 2.2.4.

This release contains the following fixes:

  • Fixed: Exceptions during statement preparation leave connection and transaction open after explicit close (JDBC-311)
  • Fixed batch update (or insert) with blob set through setBinaryStream() sets empty blob for all but the first batch entry (JDBC-312)
  • Fixed incomplete checks of database, transaction, statement and blob handle validity before continuing with actions. These incomplete checks could lead to unexpected exceptions (for example a NullPointerException in iscDatabaseInfo) (JDBC-313)
  • Fixed error when setting connection charset equal to "file.encoding" java property (JDBC-314)
  • Fixed connection character set not correctly set when specifying the Java connection characterset (charSet or localEncoding property)  (JDBC-315)
  • Fixed incorrect lengths and/or radix reported by getTypeInfo and getColumns metadata (JDBC-317, JDBC-318)
  • Initial Java 8 / JDBC 4.2 support (JDBC-319)
  • Firebird 3 BOOLEAN type support, see Support for Firebird 3 BOOLEAN type in the release notes for more details (JDBC-321)
  • Added fallback of loading GDSFactoryPlugin implementations to prevent NullPointerException in Hibernate reverse engineering wizard in NetBeans (JDBC-325)
  • Fixed: Jaybird should specify dialect 3 in dpb when no explicit dialect was set (JDBC-327)
  • Fixed: several DatabaseMetaData methods defined by JDBC to only accept the actual table name also accepted a LIKE-pattern or empty string or null. This was changed to conform to JDBC. This change can break applications that relied on the incorrect behavior (JDBC-331)
    Affected methods are: getPrimaryKeys, getBestRowIdentifier, getImportedKeys, getExportedKeys and getCrossReference. As part of this change getIndexInfo now handles names in the wrong case slightly different.
    Jaybird 3.0 will further modify and restrict the pattern matching and case sensitivity of metadata methods. See Future changes to Jaybird in the release notes for more details.

Downloads available from JDBC driver section on the Firebird website.

The release is also available on maven(*):

<groupId>org.firebirdsql.jdbc</groupId>
<artifactId>jaybird-jdkXX</artifactId>
<version>2.2.4</version>

* The artifactId depends on your target Java version: jaybird-jdk15, jaybird-jdk16, jaybird-jdk17 or jaybird-jdk18

LibreOffice 4.2 International Bug Hunting Session

Leave a comment

The Document Foundation announces LibreOffice 4.2 International Bug Hunting Session, which will start on December 6th and will end on December 8th. During the three days, volunteers from all over the world will test the beta of LibreOffice 4.2 to find bugs and regressions.

LibreOffice 4.2 will be released at the end of January 2014, with a large number of new features (https://wiki.documentfoundation.org/ReleaseNotes/4.2) and loads of fixed bugs. The community is working to make this major release the finest in the history of the free office suite.

In order to join the bug hunting session, volunteers should download LibreOffice 4.2 Beta 2, available fromhttp://www.libreoffice.org/download/pre-releases/.

Mentors will be available at least from 08:00 UTC to 22:00 UTC, and will be reachable through IRC (irc://chat.freenode.net/libreoffice-qa) and the QA mailing list.

Other information on LibreOffice 4.2 International Bug Hunting Session are available at https://wiki.documentfoundation.org/BugHunting_Session_4.2.0.

What is interesting for Firebird is finding/fixing bugs related to Libreoffice Base and Firebird

  • NEW TECHNOLOGY PREVIEW FEATURE: Firebird SQL connector for LibreOffice Base (Andrzej Hunt). When creating a new Database, select Firebird Embedded in the drop down menu (you have to first enable the Experimental features in Tools ▸ Options ▸ LibreOffice ▸Advanced). This allows creation of databases that perform many times faster than the previous built-in HSQLDB 1.8, avoiding the C++-to-Java overhead inherent in using HSQLDB. We plan to phase HSQLDB out over the next few releases, and provide a smooth migration path to Firebird. Connecting to modern HSQLDB 2.x external databases remains available through HSQLDB’s native interface, namely JDBC.

 

FirebirdDB.png
1 2