This page contains release notes and the for the and the Review the database connector compatibility release matrix supported for the frevvo Database Connector:for your Live Forms version.
| Database Connector | Live Forms |
| v2.5.x3 | v7.3.x2+ |
| v2.5.21 | v7.2.1+x2 |
| v2.4 | Any version prior to v7.2.0 |
If you are running Database Connector v2.5.0 - v2.5.2
...
7/28/2017
...
you must upgrade to v2.5.
...
3+ due to issues solved in 2.5.3.
- In order to run the Database Connector v2.5.
...
- 3 you must upgrade to v7.
...
- 3.
...
- 2+.
...
- v2.
...
- 5.3 was not certified with earlier versions.
| Info |
|---|
frevvo only supports/certifies the Database Connector running in the Apache Tomcat container. Refer to our Supported Platforms for the list of Application Servers and databases supported/certified by frevvo. |
| Table of Contents | ||
|---|---|---|
|
v2.5.3 (r31018)
10/27/2017
This release contains enhancements and bug fixes. Download the Database Connector v2.5.3 Standalone bundle or just the database.war our frevvo Software Downloads Directory .
Enhancements:
- #21523 - Database connector version annotation added to generated XSDs to help manage changes
- #21549 - Errors for certain CRUD operations return an error to the frevvo forms server. The submission repository will flag the submission with an error icon. The tenant admin or any designated flow admins receive email alerts.
- #21643 - New Property to create error logs in JSON format
- #21665 - Log Database Driver version and revision numbers
- #21714 - Database Connector version/revision added to status page
Tickets fixed:
- #21524 - SQL queries with empty results fail with UncategorizedSQLException error
- #21527 - HTTP Get through the Database Connector doesn't return results
- #21543 - emitNullColumns atrribute default value reverted to 'false'. When ths attribute is set to false, the database connector will not return any xml or json value for any database column that is blank or null.
- #21594 - DBConnector fails when query has more parameters than the columns returned
- #21674,#21755 - DOC URL fails with "Unable to autocreate row for query" error when it hits the first empty row
- #21684 - MSSQL Driver not found error
- #21716 - NPE calling HTTP PUT from curl
- #21717 - Row count reported in database connector log is incorrect for create operation
v2.5.2 (r30569)
7/28/2017
This release contains bug fixes. The Database Connector v2.5.2 is included in the frevvo tomcat bundle. You can download the compatible version of the tomcat bundle from our frevvo Software Downloads Directory.
Tickets Fixed:
- #21139 - A third party JDBC driver to connect to Active Directory as an SQL database causes validation to fail. Drivers of this type are not supported
- #21150 - Adding SQL Server JDBC driver to WAR causing issues for customers who already have the driver installed in the tomcat/lib directory
- #21156 - MS SQL JDBC driver embedded in the dbconnector causing queries to not work after upgrading to version 2.5 of the Database Connector
- #21196 - Write dbconnector logs to tomcat/logs/database-connector.YYYY-MM-dd.log instead of frevvo.log
- #21232 - jTDS driver does not work with DBConnector v2.5.0
- #21279 - Log is not generated when configuration parameters are located in database.xml
#21411 - <cache/> element in configuration.xml causing error
#21421 - Autocreate="true" does not work"
#21428 - Empty resultsets report "Document is null. Premature end of file" errors in the debug console when testing forms
v2.5.0 (r29937)
4/29/2017
Version 2.5 of the Database Connector was certified with 7.2.1+ and requires Java 8. Anyone running an older version of should use version 2.4. This release contains enhancements and bug fixes. The Database Connector v2.5 can be deployed in any servlet container i.e.tomcat or in Standalone mode
The Database Connector .0 is included in the v7.2.1 in-house frevvo tomcat bundle. You can download in-house software from here. It is also available in a separate zipfile. Click here to download the standalone zipfile.
One advantage to using version v2.5 of the Database Connector with v7.2.1 is that the configuration.xml is separated from the underlying infrastructure database and related credentials. Review the enhancements below for more reasons to upgrade.the compatible version of the tomcat bundle from our frevvo Software Downloads Directory.
Enhancements:
- #18166 - Batch processing of POST/Create requests. JDBC inserts are 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 - Support for JSON payload 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 database.war is 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 included in the Database connector war.
- QuerySet and Query names only allow alphanumeric, dot, dash and underline characters. They must start with letters. This change 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.
Tickets Fixed:
- #19062 - MySQL column w/ timestamp datatype failing when trying to insert date/time control value.
- #9244 - http.post() to DB connector not working from rules for URL parameters and JSON payload in POST/PUT requests.
- #9565 - A query with '<' sign in it does not work.
- #12750 - DB Connector:Support PUT/POST for European Characters.
- #13134 - Database POST fails when there is % character in one of the fields.
- #18620 - SQLSERVER : Datatype nvarchar does not generate max-length restrictions
- #18207 - Errors while inserting, updating, selecting row(s) using the DB connector are simply logged and ignored: it always returns an HTTP 200 status code.
...