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

can't view logs using oracle due to column 'comment'

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: EJBCA 3.1
    • Fix Version/s: EJBCA 3.1.3
    • Component/s: CA GUI
    • Labels:
      None
    • Environment:
      oracle 9

      Description

      the view log functionality does not work with oracle :

      Oracle does not support a table named 'comment' :
      this is adressed in the file jbosscmp-jdbc-LogEntryDataBean, ok
      <cmp-field>
      <field-name>comment</field-name>
      <column-name>comment_</column-name>
      </cmp-field>

      but in :

      • se.anatom.ejbca.util.query.LogMatch (line 46)
      • se.anatom.ejbca.log.LocalLogSessionBean (line 129)

      the name of the table 'comment' is hard coded in the constants used for sql select, this table does not exist in the DB .

      ( I replaced "comment" with "comment_" in the constants of these two classes and everything works fine )

        Attachments

          Activity

            People

            Assignee:
            tomas Tomas Gustavsson
            Reporter:
            simon.lebettre Simon Lebettre
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: