[NIFI-3611] Add option to select transaction isolation level for QueryDataBaseTable processor

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.9.0
• Component/s: Extensions
• Assignee: Eric Hanson
• Reporter: Eric Hanson
• Created: 16/Mar/17 14:14
• Updated: 21/Jan/19 08:21
• Resolved: 21/Jan/19 08:21

Description

In many organizations, when reading from transactional DB systems, it is required to read from tables using the TRANSACTION_READ_UNCOMMITTED transaction isolation level. The QueryDatabaseTable processor should have an option in the properties to select from a list of transaction isolation levels. Not all drivers will support all isolation levels, but there should be an option to set this for the one's that do.

Issue Links

• links to: GitHub Pull Request #3248