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

External RA: Oracle Database mapping support in RA GUI

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: EJBCA 6.0.3, EJBCA 6.1.1
    • Fix Version/s: EJBCA 6.2.0
    • Component/s: Legacy External RA
    • Labels:
      None
    • Environment:
      Externale RA GUI
    • Issue discovered during:
      Community

      Description

      It is possible to add Oracle Database Support for External RA GUI modifing
      externalra-gui xml build file (see also attached file):

      $EJBCA_HOME/modules/externalra-gui/build.xml

      adding the following line at row 106:

      <condition property="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect"><matches pattern="jdbc:oracle:thin:" st ring="${externalra-gui.datasource.jdbc-url}"/></condition>

      To deploy External RA GUI on a different database then H2, data.properties file configuration is also needed. In case of Oracle database the following line must be uncommented:

      database.name=oracle

      To make external RA GUI deploy totally independent from normal EJBCA deploy, I suggest you to define in externalra-gui.properties configuration file a database name section like this:

      #externalra-database.name=hsqldb
      #externalra-database.name=mysql
      #externalra-database.name=postgres
      #externalra-database.name=mssql
      #externalra-database.name=oracle
      #externalra-database.name=sybase
      #externalra-database.name=informix
      #externalra-database.name=derby
      #externalra-database.name=db2
      #externalra-database.name=ingres

      and using this parameter in build.xml to setup the correct datasource.

      BR
      Costantino Palladino

        Attachments

          Activity

            People

            Assignee:
            tomas Tomas Gustavsson
            Reporter:
            costantino.palladino Costantino Palladino
            Verified by:
            Mike Agrenius Kushner
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: