Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Download the appropriate JDBC driver for your database:

    RDBMSRecommended DriverExample of JAR FileDriver ClassDownload From
    MySQLConnector/Jmysql-connector-java-5.1.41-bin.jarcom.mysql.jdbc.Driverhttp://www.mysql.com/downloads/connector/j/
    Oracleojdbc7.jarojdbc7.jaroracle.jdbc.driver.OracleDriverhttp://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html
    SQL ServerMicrosoft JDBC Driversqljdbc42.jarcom.microsoft.sqlserver.jdbc.SQLServerDriverhttp://www.microsoft.com/en-au/download/details.aspx?id=11774
    DB2DB2 JDBC Driverdb2jcc4.jarcom.ibm.db2.jcc.DB2Driverhttp://www-01.ibm.com/software/data/db2/linux-unix-windows/downloads.html
    PostgreSQLPostgreSQL JDBC 4.2 Driver, 42.0.0postgresql-42.0.0.jarorg.postgresql.Driverhttps://jdbc.postgresql.org/download.html
    Note
    iconfalse

     The JDBC driver must support JDBC 4.2 (Java 8).

    Note
    iconfalse

    You do not need to download a driver to use the default H2 RDBMS as this driver is included with SuperADMIN.

  2. Copy the driver .jar file to C:\Program Files\STR\SuperADMIN\server\lib\endorsed (or equivalent directory if you installed to a non-default location). You will need to create this directory if it does not already exist.

Step 3 - Configure SuperADMIN

...

You will need to restart the SuperADMIN/SuperSERVER service to apply this change. When the service has started, verify that the tables have been created in your RDBMS. For example:

Image RemovedImage Added

Note
iconfalse
SuperADMIN does not delete the legacy XML file (UserCatalog.xml) following a successful migration, although this file will no longer be required or used and will not need to be restored during a future upgrade.