[OAK-8470] Allow a database schema to be targeted via RDB Document Store

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.14.0
• Component/s: rdbmk

Environment

Tested on Tomcat with Microsoft SQLServer

• Assignee: Unassigned
• Reporter: Ryan Ashcraft
• Created: 10/Jul/19 15:04
• Updated: 10/Jul/19 15:04

Description

It would be useful in some environments to be able to target relational database DDL and operations to a specific schema.  Currently, there is no way to achieve this - sometimes leading to some extra contention w/ DBAs that want to specifically control where things live.  

Not a huge problem, but might be a useful feature for RDB users.

For Example:

• Target the underlying JDBC datasource to a specific schema
• Run DDL in that schema to source the tables
• The RDBDocumentStore will ignore the schema and run the DDL and subsequent database operations against the default schema for the database (vice the JDBC datasource).