Category: Developer News

News from the Firebird developers.

Update of .NET Provider for OLEDB. Support of schemas implemented.

Leave a comment

We continue to develop our .NET Provider for OLEDB. In the new build (#1434), we have implemented the methods to obtain database metadata:

  • OleDbConnection.GetOleDbSchemaTable
  • OleDbConnection.GetSchema

GetOleDbSchemaTable

Supported schemas:

  • SchemaGuids
  • DbInfoKeywords
  • DbInfoLiterals
  • All schemas of the OLEDB Provider

Distinctions compared to standard OLEDB.NET Provider:

  • The SchemaGuids schema describes all schemas including SchemaGuids, DbInfoKeywords and DbInfoLiterals.
  • The SchemaGuids schema supports restrictions for the Schema column.

GetSchema

Supported schemas:

  • MetaDataCollections
  • Restrictions
  • DataTypes
  • ReservedWords
  • DataSourceInformation
  • CharacterSets
  • Collations
  • Tables
  • Views
  • Columns
  • Procedures
  • ProcedureParameters
  • ProcedureColumns
  • Indexes

Distinctions compared to standard OLEDB.NET Provider:

  • The MetaDataCollections schema supports restrictions for the column CollectionName.
  • The Restrictions schema supports restrictions for the columns CollectionName and RestrictionName.
  • More accurate population of the DataSourceInformation schema.
  • More accurate population of the Restrictions schema.

Implementation peculiarities

  • Caching of data from its own schemas (SchemaGuids, DbInfoKeywords, DbInfoLiterals, …).
  • Coherence of information from metadata schemas with the descriptions of the resulting rowset columns and command parameters (ensured by IBProvider).
  • Different algorithms of metadata loading for Interbase and Firebird. Including – our provider takes into account the version of the server and the version of database ODS (ensured by IBProvider).
  • Caching of OLEDB metadata schemas is carried out on the IBProvider level (see a property «schema_cache»).

Other changes

  • The OleDbSchemaGuid class added with the lists of known OLEDB schema identifiers.
  • The OleDbSchemaRestriction class added with the lists of restriction indexes for known OLEDB schemas.
  • The OleDbLiteral class added.
  • The OleDbMetaDataCollectionNames class added.
  • The number of tests and debug structures ensuring the correct work of components increased.

New examples

If you are interested in working with stored procedures grouped into PACKAGE, please take a look at the new example for our .NET Provider:

  • Creation and working with PACKAGE (C#, FB3)

    • It is time for Firebird on Android and IOS ?

    3 comments

    With the release of Delphi XE5, with support for iOS and Android it also brings InterBase versions of these two O.S-es, people started to question whether we can expect a version of Firebird for mobile platforms. Apparently, it will happen! Paul Beach said he already has a version of FB compiling for iOS, but it still needs testing. Anyway, the release versions for iOS / Android should not happen now, since developers are totally focused on Firebird 3 release.

    News via firebase.com.br

    Update:
    Firebird client can be build for Android
    Also on the Apple side: Paul Beach managed to cross-compile Firebird for iOS

    Firebird Code Factory 13.9 released

    Leave a comment
    Firebird Code Factory SQL Maestro Group announces the release of Firebird Code Factory 13.9, a powerful Windows GUI utility for querying Firebird databases and managing the data.

    New version comes with keyboard interactive SSH authentication, updated Script Runner, redesigned start page, improved SQL editors and data grids, as well as with many 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.3 (Firebird JDBC) released

    Leave a comment

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

    See http://www.firebirdsql.org/en/jdbc-driver/ for the downloadlinks.

    The release is also available on maven:
    <groupId>org.firebirdsql.jdbc</groupId>
    <artifactId>jaybird-jdkXX</artifactId>
    <version>2.2.3</version>

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

    The following has been changed or fixed in Jaybird 2.2.3:

    • Fixed incorrect synchronization in native and embedded protocol (JNI) implementation for iscBlobInfo and iscSeekBlob (JDBC-300)
    • Fixed holdable ResultSet is closed on auto-commit (JDBC-304, JDBC-305)
    • Fixed table names missing or padded with spaces in Database view of IntelliJ IDEA (JDBC-308, IDEA-100786)
    • Fixed incorrect JDBC minor version reported under Java 7; this resulted in an incorrect column name (for Java 7) in the metadata of DatabaseMetaData.getColumns(…) (JDBC-309)
    • Added IOException to cause of GDSException with error 335544721; “Unable to complete network request to host “”” for further investigation (JDBC-306)

    More details are available in the Jaybird 2.2.3 releasenotes.

    1 … 15 16 17 18 19 … 58