Review the database connector compatibility release matrix for your Live Forms version. 

v2.5.6 (r8db5160)

Cloud: Dec 15, 2018

In-house: 1/24/2019

Version 2.5.6 of the Database Connector is a small release containing one enhancement. In-house and Cloud customers running the Database Connector on-premise, can download the Database Connector Standalone zipfile or just the database.war zipfile from our frevvo Software Downloads Directory. This version was deployed to the frevvo Cloud on December 15, 2018.

You may notice the revision numbers for the Database Connector have changed. The revision number is now a unique 40 character string. Release notes refer to the revision number by the first 7 characters. See Version Information for details.

Enhancements:

• productDetailsByProductCode query added to the BIRT configuration.

v2.5.5 (r0381158)

Cloud: 6/9/2018

In-house: 4/20/2018

This release contains enhancements and bug fixes. In-house and Cloud customers, running the Database Connector on-premise, can download the Database Connector Standalone zip file or just the database.war from our frevvo Software Downloads Directory. This version has not been deployed to the frevvo Cloud

You may notice the revision numbers for the Database Connector   have changed. The revision number is now a unique 40 character string. Release notes refer to the revision number by the first 7 characters. See  Version Information for details.

Enhancements:

• TIP-22454 - Warning message added to Database Connector log when the connection threshold is exceeded.

Tickets fixed:

• TIP-22161 - Property to disable query/querySets is not working (#22204)

• TIP-22418 - HTTP Get with templatized URIs fails when control values have special characters

• TIP-22419] - DB connector queries where parameter values are encoded using encodeURIComponent() do not work after DB Connector 2.4 -> .2.5.4 upgrade

v2.5.4 (r31299)

2/2/2018

This release contains enhancements for our Cloud environment and bug fixes.It was installed to the frevvo Cloud on 1/7/2018. Cloud customers, running the Database Connector on-premise, can download the Database Connector Standalone zip file or just the database.war from our frevvo Software Downloads Directory.

It is recommended that In-house customers upgrade to Live Forms v7.4.x to be compatible with v1.1.1 of the Filesystem Connector. v7.4 was released for in-house customers on 2/14/1

Enhancements:

• #21859 - Add support for JAVA_OPTS in standalone database-connector (Cloud Only)

• #21872 - Management endpoints on port 8083 (Cloud Only)

Tickets fixed:

• #21969 - Workaround for generated schema that may not upload successfully when using copy/paste to make the xsd file in the Chrome browser.

• #22025 - NPE when calling a Stored Procedure that does not return a resultset using a <retrieve> statement 

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 from our frevvo Software Downloads Directory page.

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 this 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

Version 2.5.2 of the Database Connector was certified with Live Forms 7.2.4 and requires Java 8. If you run the Database Connector v2.5.2 with Live Forms v7.2.1, v7.2.2 or v7.2.3, logging entries for the Database Connector will be included with the Live Forms logging entries in the <frevvo-home>\tomcat\frevvo_YYYY-MM-DD.logfile. If you run the Database Connector with Live Forms v7.2.4, the Database Connector entries are logged separately in the <frevvo-home>\tomcat\logs\database-connector.YYYY-MM-DD logfile. 

If you are running Database Connector v2.5.0 - v2.5.2 you must upgrade to v2.5.3+ due to issues solved in 2.5.3.

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

If you are running Database Connector v2.5.0 - v2.5.2 you must upgrade to v2.5.3+ due to issues solved in 2.5.3. 

Enhancements: