This page contains release notes for the  Database Connector.

Compatibility release matrix supported for the frevvo Database Connector:

v2.5(r29937)

4/29/2017

Version 2.5 of the Database Connector was certified with  7.2+ and requires Java 8. Anyone running an older version of should use version 2.4.

One advantage to using version v2.5 of the Database Connector with v7.2 is that the configuration.xml is separated from the underlying infrastructure database and related credentials. SYSADMINS can change database hosts, usernames, passwords without touching the configuration.xml. The configuration file can be stored without security risks. Review the enhancements below for more reasons to upgrade.

Enhancements:

• #18166 - Batch processing of POST/Create requests. JDBC inserts are now batched instead of performing individual inserts.
• Logging improvements
• KIOSK mode - when no configuration.xml is defined, the KIOSK mode pre-loads BIRT (ClassicModels) and myStore QuerySets with in-memory Derby databases. This will make it very easy to try out the DB Connector.
• #19243 - JSON payload now supported from business rules when performing POSTs and PUTs.
• #20546 - Query statements are validated when the DB Connector starts instead of when used.
• Console prints the DB Connector version and revision number.
• #18620 - Generating max-length for SQL Server NVARCHAR
• #20532 - Ability to disable QuerySets and/or Querys while developing your integration.
• #18708, #18676 - Returns blank or null in the JSON results for columns that have blank or null values..
• The WAR is now executable - there is the option to either deploy the WAR in an existing Servlet Container or simply run the WAR in standalone mode (with java -jar dbconnector.war).
• The SQL Server JDBC driver is now open source and included in the WAR
• QuerySet and Query names only allow alphanumeric, dot, dash, and underline characters and it can only start with letters - this makes sure that they are automatically XML and JSON friendly.
• The driver and validationQuery attributes in <resource-def> are now optional: they will be properly inferred based on the current database.
• The configuration.xml file is automatically picked up from the current directory where the DB Connector was launched or from ./config/configuration.xml. It can be manually set by using the frevvo.connectors.database.configuration property as before. This is specially useful when running the DB Connector standalone.
• #9564 - Ability to generate schemas for all queries in a queryset. This makes it possible to download a single XSD for all queries at once.

v2.4

6/22/14

This version is a rebuild and has the same content as the v2.3.1 connector.

v2.3.1 (r20198)

3/18/2013

• Retrieved data can now be cached by the connector for improved performance.
• Status Url database/status returns current configuration information
• All database operations now log start/stop time and a WARN if time exceeds a configured threshold
• Using prepared statements to execute all queries for enhanced security
• #4638 Improved logging message make diagnosing and solving database issues faster/easier.
• #6532 Values passed to the connector that contain Url special characters such as '&' cause value truncation
• #8123 POST Url paramenters were ignored when there was no XML document sent also
• #8693 Status 500 returned when sending a delete request
• #8705 Query to update same form fields twice and 2nd time returned row has NULL in one of the columns, value on form is not cleared. Old value from 1st query remained.
• #8906 DB column NOT NULL but with a default value should not be required in the auto generated XSD schema
• #6605 Errors are logged as INFO when they should be WARN or ERROR

v2.2 (r10466)

10/20/09

• #4515 - Update is no longer run after autocreate Insert. Not needed
• #4798 - Warn if deleteKey does not exist in the schema returned by the retrieve statement
• #5485 - UTF-8 characters retrieved from DB causing MalformedByteSequenceException in connector

v2.1 (r9567)

7/9/09

• #1466 - Column names with underscore characters sig1_name='{sig1_name}' not getting template replaced
• #5026 - readme is out of date
• #4648 - _mediaType=json returns JSON rather than the default XML

v2.0 (r8967)

5/7/09

• Datasource definitions delegated to the container and are resolved by the connector through JNDI lookup. The resource reference is configured in the connector configuration file.
• A single database connector instance can work with multiple databases.
• Execute stored procedures. If the stored procedure does not have OUT parameters it is not necessary to declare the statement as a procedure.
• It is possible to configure all Date and timestamp formats for both the database and the generated XML.
• Hot update of the configuration file. The connector will pick up the changes within 5 seconds.
• Parameters passed in the URL take precedence over values provided in the body of POST and PUT requests. Useful for  rules.
• Multiple statements. It is possible to execute multiple SQL statements for one URL. This is available for the "create", "update" and "delete" operations. The retrieve operation only allow one statement.

v1.0

GA Release