Uploaded image for project: 'EJBCA'
  1. EJBCA
  2. ECA-7141

orm entry for AcemNonceData incorrect for PostgreSQL

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: EJBCA 6.14.0
    • Fix Version/s: EJBCA 6.14.0
    • Component/s: None
    • Labels:
      None
    • Stakeholder:
      Customer
    • Issue discovered during:
      Customer
    • Sprint:
      EJBCA Sprint 16

      Description

      orm-ejbca-postgres.sql

       

      <entity class="org.ejbca.acme.AcmeNonceData" access="PROPERTY" metadata-complete="false">
       <attributes>
       <id name="nonce"><column name="nonce" column-definition="TEXT"/></id>
       <basic fetch="EAGER" name="timeExpires"><column name="timeExpires" column-definition="INT(8)" nullable="false"/></basic>
       <basic fetch="EAGER" name="rowProtection"><column name="rowProtection" column-definition="TEXT"/><lob/></basic>
       <version name="rowVersion"><column name="rowVersion" column-definition="INT4" nullable="false"/></version>
       </attributes>
       </entity>

       

      should be:

       

      <entity class="org.ejbca.acme.AcmeNonceData" access="PROPERTY" metadata-complete="false">
       <attributes>
       <id name="nonce"><column name="nonce" column-definition="TEXT"/></id>
       <basic fetch="EAGER" name="timeExpires"><column name="timeExpires" column-definition="INT8" nullable="false"/></basic>
       <basic fetch="EAGER" name="rowProtection"><column name="rowProtection" column-definition="TEXT"/></basic>
       <version name="rowVersion"><column name="rowVersion" column-definition="INT4" nullable="false"/></version>
       </attributes>
       </entity>
      
      

       

      INT(8) should be INT8

      there should be no <lob/> in PSQL

        Attachments

          Activity

            People

            • Assignee:
              tomas Tomas Gustavsson
              Reporter:
              tomas Tomas Gustavsson
              Verified by:
              Henrik Sunmark
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 15 minutes Original Estimate - 15 minutes
                15m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 20 minutes
                20m