Uploaded image for project: 'James Server'
  1. James Server
  2. JAMES-396

Wrong column order (IMHO) in primary key definition for SpoolRepositories.

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.2.0
    • 2.3.0
    • None
    • None

    Description

      In sqlResources.xml many JDBCSpoolRepository createTable definition declare a primary key as (message_name, repository_name) instead of (repository_name, message_name) .
      this is "bad" for hypersonic, mysql, mssql, oracle, postgresql, sapdb
      db2 seems to be correctly configured.

      Why?

      AFAIK every query we do against the spool will include a filter on the repository_name. Some of them also includes the message_name but others does not include the message_name!

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            bago Stefano Bagnara
            bago Stefano Bagnara
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment