Versions Compared

Old Version 2

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This page contains release notes for the following the frevvo Database  Database Connector. 

v2.3.1 (

...

r20198) 

  • 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

...

  • 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 frevvo rules 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.

...