FrontBase Distribution 4.2.9

This is a maintenance release with focus on bug fixes and optimizations.

FrontBase 4.2.9

The agent connection executing a WRITE BACKUP is now throttled such that the disk is not monopolized, which could starve other agent connections.

The query optimizer has been improved wrt. dealing with IN predicates more efficiently.

The amount of RAM used for when evaluating stored procedures has been reduced.

Incorrect collation used in connection with a LIKE operator on the information_schema.users table.

Initially deferred constraints was not always checked in connection with inserts.

sql92 command line tool

The new sql92 command

• THROTTLE <float>[s|%];

If s is specified the command will wait float seconds, if % is specified the command will wait such that the overall load will be float percent. The command is intended to regulate the load on a server during massive imports.

The set format format string have been enhanced such that blobs may be expanded with the %B flag and the general printf format strings can be specified with %p. There is no checks of the compatibility of the column values and the printf format string, so you may get unexpected results.

It also possible to refer to column by their label.

The complete SET FORMAT '<format>';:

• <format> :== %{<column>}{.<width>}<flag>
• %*{<width>}<flag>
• %{<width}[<template>|{<template>]
%%
• <column> :== positive integer
• "<label>"
• <width> :== positive integer
• <flag> :== c l T S n # r p

If the column or the width is omitted they are interpreted as 0.

The flags expands to

c : column value
• l : column label
• T : table name
• S : scehma name
• n : column name
• # : the row number in current result set
• r : the result set number
• B : expands to the standard sql92 blob definition for all blobs in one row

The expanded string is padded with spaces to the width.

%[{<width>}<template>|{<template>] iterates over all columns and expands the template for each. If the <column> is not spefied inside the iterator the current column is referenced. The first column is expanded using the first template and the following columns by expanding the second.

The %*<flag> from is a shorthand for %[%<flag>|,<%flag>].

The %% expand to %.

Other expansions:

• \n new line,
• \r carridge return,
• \t tab,
• \ddd to the decimal unsigned byte values,
• \c to the character.

JDBC 2.5.2

Changed method FBJPreparedStatement.executeSetObject (Now it supports the Types.BOOLEAN sql type).
• Fixed bug in FBJPreparedStatement.executeSetObject (Exception when using the Types.DATE sql type).
• Added method FBJMetaData.isSelect (Returns true if statement is SELECT or UNIQUE).
• - Added constructor FBJURL (Will initialize with java.util.Properties object ).
• - Changed method FBJDatabaseMetaData.getExportedKeys (Simplified CASE statement).
• Changed method FBJDataSource.getConnection (Prepare FBJURL with java.sql.Properties).
• Changed method FBJConnectionPoolDataSource.getPooledConnection (Prepare FBJURL with java.sql.Properties).
• Changed class FBJConnectionPoolDataSource (Imherits from FBJDataSource).
• Added support for enabling client side prepared statements in the connection url.

JDBC 2.5.1

• Added constructor FBJReplicationHandler (Will attempt to start the replicator if it is not running).
• Added method FBJReplicationHandler.isClient (Will check if a database is already a replicator client).
• Added method FBJReplicationHandler.resfresh (Updates the client information).
• Fixed bug in FBJClob (Handling of large Clobs incorrect).

Changes in FrontBase JDBC 2.5.0

• Added FBJReplicationHandler class (This class makes it possible to administer a replication setup through the driver).
• Fixed bug in FBJCallableStatement.execute (If procedure is a function the last result set will get returned).
• Fixed bug in FBJCallableStatement.parseSQL (Procedure name is trimmed due to bug in WebObjects).
• Added method FBJConnection.getDatabaseCreationVersion (Returns version of database that used to create database).
• Added method FBJConnection.getTransactionInfo (Returns the current transaction info).
• Fixed bug in FBJConnection.getDatabaseCreationVersion (Incorrect sort ordering).
• Fixed bug in FBJConnection.cancelFetch (Fetches were sometime canceled using invalid fetch handles).
• Added method FBJExecHandler.getLicenseInfo (Returns info on what is licensed and what is not).
• Changed method FBJExecHandler.close (Changed access modifier to public).
• Added method FBJErrorMessageTemplate.getSQLState (Returns a 5 digit string describing the exception).
• Changes FBJErrorMetaData constructors (Templates now loaded in instance initializer block).
• Changed method FBJStatement.executeQuery(Now it will accept updates but just return null).
• Added method FBJDatabaseMetaData.getCurrentSchema (Returns the current schema).
• Fixed bug in FBJMetaData.hasErrors (Checks on multiple metadata sets not performed correctly).
• Fixed bug in FBJResultSet constructor (Batch not fetched when handling EXTRACT statements).
• Fixed bug in FBJPreparedStatement.setBinaryStream (Saved data as BLOB but the API dictates the this data should be saved as BINARY data).
• Added method feature in FBJPreparedStatement.setObject (InputStream data can be saved as BLOB if Types.BLOB is specified).