Uploaded image for project: 'Jackrabbit Oak'
  1. Jackrabbit Oak
  2. OAK-8470

Allow a database schema to be targeted via RDB Document Store

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

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

      Tested on Tomcat with Microsoft SQLServer

      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).

        Attachments

          Activity
          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

            • Assignee:
              Unassigned
              Reporter:
              ashcradr Ryan Ashcraft

              Dates

              • Created:
                Updated:

                Issue deployment