ANN: AnySQL Maestro 13.2 released

AnySQL Maestro SQL Maestro Group announces the release of AnySQL Maestro 13.2, a powerful tool to manage any database engine accessible via ODBC driver or OLE DB provider (MS Access, SQL Server, Firebird, Oracle, MySQL, PostgreSQL, etc).

AnySQL Maestro comes in both Freeware and Professional editions (more information).

New version introduces enhanced data management abilities, advanced SQL Dump wizard, updated SQL Editor and other new features (full press release).

ZeosLib 7.0.3 stable for Delphi/Lazarus is released

Stable version of zeoslib 7 is released.

The most important improvement you’ll find in this version is support for the compilers Delphi2009 and newer, with their unicode strings.

Other changes in this release are
– Some new components for grouping connections (alpha status)
– Postgres event alerter component comparable with the existing Interbase/Firebird event alerter (alpha status)
– Pooled connections (alpha status)
– Real prepared statement support (always for firebird, on demand for mysql and postgres), allowing to prepare queries once and execute them multipe times with different input variables.
– New FreeTDS driver for connections to Mssql and Sybase that can replace the old dblib protocol.
– TZStoredproc got a full makeover. Now Stored procedures should work for postgres, firebird, mysql, mssql and oracle (alpha status)
– A load of bugs have been fixed.

Downloads of the new beta release can be found on sourceforge or our mirror download directory http://zeosdownloads.firmos.at/downloads/

New IBExpertBenchmark tool: Compare your db server performance on different hardware, OS’s and Firebird server version

Have you ever tried to compare the database speed of your Firebird server with new server hardware? Is a XEON Machine better than an Opteron? What improvements can you expect from fast SAS hard disks, RAID controllers or Enterprise SSDs? Is SuperClassic really better than Superserver?
We’ve created a new tool which offers a reproducible speed index for your computer working as a Firebird Server: IBExpertBenchmark

Jaybird 2.2.2 Released

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

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.2</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.2:

  • Fixed: FBMaintenanceManager.listLimboTransactions() reports incorrect transaction id when the result contains multi-site transactions in limbo (JDBC-266)
  • Fixed: Calling PreparedStatement.setClob(int, Clob) with a non-Firebird Clob (eg like Hibernate does) or calling PreparedStatement.setClob(int, Reader) throws FBSQLException: “You can’t start before the beginning of the blob” (JDBC-281)
  • Fixed: Connection property types not properly processed from isc_dpb_types.properties (JDBC-284)
  • Fixed: JNI implementation of parameter buffer writes incorrect integers (JDBC-285, JDBC-286)
  • Changed: Throw SQLException when calling execute, executeQuery, executeUpdate and addBatch methods accepting a query string on a PreparedStatement or CallableStatement as required by JDBC 4.0 (JDBC-288)
    NOTE: Be aware that this change can break existing code if you depended on the old, non-standard behavior! With addBatch(String) the old behavior lead to a memory leak and unexpected results.
  • Fixed: LIKE escape character JDBC escape ({escape ‘<char>’}) doesn’t work (JDBC-290)
  • Added: Support for a connect timeout using connection property connectTimeout. This property can be specified in the JDBC URL or Properties object or on the DataSource. If the connectTimeout property is not specified, the general DriverManager property loginTimeout is used. The value is the timeout in seconds. (JDBC-295)
    For the Java wire protocol the connect timeout will detect unreachable hosts. In the JNI implementation (native protocol) the connect timeout works as the DPB item isc_dpb_connect_timeout which only works after connecting to the server for the op_accept phase of the protocol. This means that – for the native protocol – the connect timeout will not detect unreachable hosts within the timeout. As that might be unexpected, an SQLWarning is added to the connection if the property is specified with the native protocol.
  • As part of the connect timeout change, hostname handling (if the hostname is an IP-address) in the Java wire protocol was changed. This should not have an impact in recent Java versions, but on older Java versions (Java 5 up to update 5) this might result in a delay in connecting using an IP-address, if that address can’t be reverse-resolved to a hostname. Workaround is to add an entry for that IP-address to the /etc/hosts or %WINDIR%\System32\Drivers\etc\hosts file.
1 43 44 45 46 47 147