FBScanner 3.6.1 is released

New version of FBScanner (3.6.1) is released. FBScanner is an unique tool to trace and audit Firebird (1.0 – 2.5) and InterBase (4.0 – XE3) SQL traffic (connections, transactions, queries), it’s very efficient tool for performance optimization and SQL bug tracking.

FBScanner works like a proxy, and enables transparent data capture and analysis:

FBScanner is Firebird performance optimization tool

FBScanner can be used for the following tasks:

  • Find queries with bad performance (i.e., slow queries with high prepare and execute times, queries with bad plans)
  • Track transactions usage
  • Real-time view of connections, users and transactions (connections can be killed)
  • Retrospective analysis of SQL traffic
  • and more – see presentation here.

FBScanner has 2 licensing options:

  • Per server – FBScanner can be used on the single server or computer to track Firebird traffic.
  • Unlimited ISV subscription – FBScanner can be installed on any number of computers during the 1 year for use with the specific software application from the single independent software vendor (ISV).

All users of FBScanner 3 already have FBScanner 3.6.1 in IBSurgeon Deploy Center.

User of FBScanner 2.x can upgrade to FBScanner 3.6.1 with 50% discount – please contact upgrade@ib-aid.com

Download now:

Demo version of FBScanner can be found here:

FBScanner Demo version

Please look at the FBScanner User Guide to get more information about its capabilities:

FBScanner User Guide

Advanced Data Generator 3.2.0 released

adg3_64x64 Upscene Productions announces the release of:
Advanced Data Generator 3.2.0″

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

If you develop database applications, you need data for testing purposes!

Version 3 included many new features, eg:

  • Unicode support in an all new fresh user interface
  • Ability to use external databases as the source for data
  • New and improved data libraries for real life like data
  • New template types
  • Much improved documentation with comprehensive “How to”-section

This product comes in four versions:

  • Pro: ADO and ODBC connectivity
  • InterBase Edition
  • Firebird Edition
  • MySQL Edition

For more information and a trial download, see the news @ Upscene Productions, pricing information is available.

You like this news? Twitter it! Share it! Check out the PromoProgram!

IBProvider 3.18. Better support of MSSQL. Changeover to the new VS 2012 compiler

We are pleased to announce the new release of our OLEDB Provider: version 3.18.

Now in your projects for Firebird and Interbase you can more comfortable work with Linked Server of MSSQL 2012. Hurrah!

In new release:

  • Improved performance of the provider as a linked MSSQL server.
  • Provider compilation with Visual Studio 2012.

Plus:

You can download IBProvider here: Firebird and Interbase driver >>>

Firebird Data Wizard 13.12 released

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

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

Database Workbench 4.4.3 released, 15% autumn discount

Upscene Productions is proud to announce the next
version of the popular multi-DBMS development tool:

Database Workbench 4.4.3 Pro

For more information, see here.

Take advantage of our 15% autumn discount!

This release includes the free Lite Editions!

Database Workbench supports:
– Borland InterBase (6.x – XE )
– Firebird ( 1.x, 2.x )
– MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 & 2, SQL Express )
– MySQL 4.x, 5.x
– Oracle Database ( 8i, 9i, 10g, 11g )
– Sybase SQL Anywhere ( 9, 10, 11 and 12 )
– NexusDB ( 3.0 and up )

You like this news? Twitter it! Share it! Check out the PromoProgram!

1 36 37 38 39 40 147