Jackrabbit Content Repository
  1. Jackrabbit Content Repository
  2. JCR-1180

DatabaseFileSystem and DatabasePersistenceManager don't allow choice of db schema

    Details

    • Type: Improvement Improvement
    • Status: Patch Available
    • Priority: Minor Minor
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: jackrabbit-core
    • Labels:
      None
    • Environment:
      All

      Description

      I have a need to store my repository objects under a different db schema than the default for the rdbms (I'm using postgresql, so in my case the default is 'public')

      The current implementation of the DatabasePersistenceManager and DatabaseFileSystem do not support changing the schema.

      Problems:

      • schemaObjectPrefix allows the user to add a table prefix, but you cannot use this to set a schema ie <schema>.table, as the . is stripped out and replaced with an escaped version
      • schema param currently refers to a ddl resource, not what people would naturally think is the param to set the schema for the repository

      Fix:

      • rename the current schema -> schemaDDL
      • add an optional schema param which allows the user to select which schema they want to use
      • improve error messages so that when an incorrect schemaDDL is chosen the user doesn't have to dig through nabble etc to find an answer
      1. jackrabbit-core.patch
        25 kB
        Kev Jackson
      2. DatabasePersistenceManager.java
        39 kB
        Antonio Mota
      3. DatabaseFileSystem.java
        45 kB
        Antonio Mota
      4. postgresql.ddl
        1 kB
        Antonio Mota
      5. postgresql.ddl
        2 kB
        Antonio Mota
      6. TablePrefix.patch
        73 kB
        Stephen Byrne
      7. TablePrefix.patch
        73 kB
        Stephen Byrne
      8. JCR-1180_2.2.7.patch
        73 kB
        Stephen Byrne

        Activity

        Stephen Byrne made changes -
        Attachment JCR-1180_2.2.7.patch [ 12490847 ]
        Stephen Byrne made changes -
        Attachment TablePrefix.patch [ 12478818 ]
        Stephen Byrne made changes -
        Attachment TablePrefix.patch [ 12477579 ]
        Jukka Zitting made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Jukka Zitting made changes -
        Workflow jira [ 12415377 ] no-reopen-closed, patch-avail [ 12467893 ]
        Antonio Mota made changes -
        Comment [ The .java classes ]
        Antonio Mota made changes -
        Comment [ The .ddl files ]
        Antonio Mota made changes -
        Attachment postgresql.ddl [ 12381888 ]
        Attachment postgresql.ddl [ 12381887 ]
        Antonio Mota made changes -
        Attachment DatabaseFileSystem.java [ 12381886 ]
        Attachment DatabasePersistenceManager.java [ 12381885 ]
        Thomas Mueller made changes -
        Assignee Thomas Mueller [ tmueller ]
        Jukka Zitting made changes -
        Fix Version/s 1.4 [ 12312447 ]
        Jukka Zitting made changes -
        Priority Major [ 3 ] Minor [ 4 ]
        Affects Version/s 1.4 [ 12312447 ]
        Kev Jackson made changes -
        Attachment jackrabbit-core.patch [ 12368185 ]
        Kev Jackson made changes -
        Attachment jackrabbit-core-add-schema.patch [ 12367991 ]
        Kev Jackson made changes -
        Field Original Value New Value
        Attachment jackrabbit-core-add-schema.patch [ 12367991 ]
        Kev Jackson created issue -

          People

          • Assignee:
            Thomas Mueller
            Reporter:
            Kev Jackson
          • Votes:
            2 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:

              Development