Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-6041

Management Service getTableMetaData and getTableCount cannot be used with a database table prefix

    Details

    • Type: Bug Report
    • Status: Closed
    • Priority: L3 - Default
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 7.7.0, 7.7.0-alpha2
    • Component/s: engine
    • Labels:

      Description

      AT
      • there is a getTableMetaData method which allows to specify the database table prefix
        TableMetaData getTableMetaData(String tableSchema, String tableName);
        
      • the test cases in ManagementServiceTest#testGetTableMetaData* are adjusted to use the new API to be prefix aware
      • the method ManagementService#getTableCount works with a table prefix configured
      Hint

      In TableDataManager the schema has to added as second parameter

      In DbSqlSession#getTableNamesPresent the schema (prefix) as to be added as second parameter instead of concatenated with the table name

        Activity

        sebastian.menski Sebastian Menski created issue -
        sebastian.menski Sebastian Menski made changes -
        Field Original Value New Value
        Description h5. AT

        - there is a getTableMetaData method which allows to specify the database table prefix
        {code}
        TableMetaData getTableMetaData(String tableSchema, String tableName);
        {code}
        - the test cases in ManagementAuthorizationTest#testGetTableMetaData* are adjusted to use the new API to be prefix aware

        h5. Hint

        In TableDataManager the schema has to [added as second parameter|https://github.com/camunda/camunda-bpm-platform/blob/25c446d84ad28bb0dd8e08dbbfa6c4bacb6b466b/engine/src/main/java/org/camunda/bpm/engine/impl/persistence/entity/TableDataManager.java#L217]
        h5. AT

        - there is a getTableMetaData method which allows to specify the database table prefix
        {code}
        TableMetaData getTableMetaData(String tableSchema, String tableName);
        {code}
        - the test cases in ManagementServiceTest#testGetTableMetaData* are adjusted to use the new API to be prefix aware

        h5. Hint

        In TableDataManager the schema has to [added as second parameter|https://github.com/camunda/camunda-bpm-platform/blob/25c446d84ad28bb0dd8e08dbbfa6c4bacb6b466b/engine/src/main/java/org/camunda/bpm/engine/impl/persistence/entity/TableDataManager.java#L217]
        sebastian.menski Sebastian Menski made changes -
        Summary Management Service getTableMetaData cannot be used with a database table prefix Management Service getTableMetaData and getTableCount cannot be used with a database table prefix
        sebastian.menski Sebastian Menski made changes -
        Description h5. AT

        - there is a getTableMetaData method which allows to specify the database table prefix
        {code}
        TableMetaData getTableMetaData(String tableSchema, String tableName);
        {code}
        - the test cases in ManagementServiceTest#testGetTableMetaData* are adjusted to use the new API to be prefix aware

        h5. Hint

        In TableDataManager the schema has to [added as second parameter|https://github.com/camunda/camunda-bpm-platform/blob/25c446d84ad28bb0dd8e08dbbfa6c4bacb6b466b/engine/src/main/java/org/camunda/bpm/engine/impl/persistence/entity/TableDataManager.java#L217]
        h5. AT

        - there is a getTableMetaData method which allows to specify the database table prefix
        {code}
        TableMetaData getTableMetaData(String tableSchema, String tableName);
        {code}
        - the test cases in ManagementServiceTest#testGetTableMetaData* are adjusted to use the new API to be prefix aware
        - the method ManagementService#getTableCount works with a table prefix configured

        h5. Hint

        In TableDataManager the schema has to [added as second parameter|https://github.com/camunda/camunda-bpm-platform/blob/25c446d84ad28bb0dd8e08dbbfa6c4bacb6b466b/engine/src/main/java/org/camunda/bpm/engine/impl/persistence/entity/TableDataManager.java#L217]

        In DbSqlSession#getTableNamesPresent the schema (prefix) as to be [added as second parameter instead of concatenated with the table name|https://github.com/camunda/camunda-bpm-platform/blob/25c446d84ad28bb0dd8e08dbbfa6c4bacb6b466b/engine/src/main/java/org/camunda/bpm/engine/impl/db/sql/DbSqlSession.java#L482]
        svetlana.dorokhova Svetlana Dorokhova made changes -
        Assignee Svetlana Dorokhova [ svetlana.dorokhova ]
        svetlana.dorokhova Svetlana Dorokhova made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        svetlana.dorokhova Svetlana Dorokhova made changes -
        Fix Version/s 7.7.0 [ 14607 ]
        svetlana.dorokhova Svetlana Dorokhova made changes -
        Status In Progress [ 3 ] Resolved [ 5 ]
        Original Estimate 0 minutes [ 0 ]
        Remaining Estimate 0 minutes [ 0 ]
        Assignee Svetlana Dorokhova [ svetlana.dorokhova ] Sebastian Menski [ sebastian.menski ]
        Resolution Fixed [ 1 ]
        sebastian.menski Sebastian Menski made changes -
        Resolution Fixed [ 1 ]
        Status Resolved [ 5 ] Reopened [ 4 ]
        Assignee Sebastian Menski [ sebastian.menski ] Svetlana Dorokhova [ svetlana.dorokhova ]
        svetlana.dorokhova Svetlana Dorokhova made changes -
        Status Reopened [ 4 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        svetlana.dorokhova Svetlana Dorokhova made changes -
        Assignee Svetlana Dorokhova [ svetlana.dorokhova ] Sebastian Menski [ sebastian.menski ]
        sebastian.menski Sebastian Menski made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        meyer Daniel Meyer made changes -
        Fix Version/s 7.7.0-alpha2 [ 14898 ]
        thorben.lindhauer Thorben Lindhauer made changes -
        Workflow camunda BPM [ 38628 ] Backup_camunda BPM [ 61623 ]

          People

          • Assignee:
            sebastian.menski Sebastian Menski
            Reporter:
            sebastian.menski Sebastian Menski
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development