Uploaded image for project: 'JBoss Enterprise Application Platform'
  1. JBoss Enterprise Application Platform
  2. JBEAP-8044

JDBC persistence-store should use BIGINT type for IDs in database tables

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Blocker
    • 7.1.0.DR12
    • 7.1.0.DR9
    • ActiveMQ
    • None

    Description

      Artemis creates file table with ID of type INT [1]. This may not be enough from long term POV.

      Suggestion for improvement: Use BIGINT type.

      [1]

      createFileTableSQL = "CREATE TABLE " + tableName +
    "(ID INT AUTO_INCREMENT, FILENAME VARCHAR(255), EXTENSION VARCHAR(10), DATA BLOB, PRIMARY KEY(ID))";

      Customer impact: In production It may happen that ID number exceeds the maximum of type INT what will lead to inability of Artemis to work properly.

      Attachments

        Issue Links

          is incorporated by

          Component Upgrade - A task tracking an update to a bundled component or revision of component upstream of the project. JBEAP-8853 Upgrade Artemis 1.5.3.jbossorg-002

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Verified

          Component Upgrade - A task tracking an update to a bundled component or revision of component upstream of the project. JBEAP-8709 Upgrade Artemis to 1.5.3.jbossorg-001

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              fnigro Francesco Nigro
              eduda_jira Erich Duda (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: