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).

...

URL

 The JDBC connection string for your chosen RDBMS. The following are typical connection strings:

MySQL
jdbc:mysql://mydatabasehost:3306/superstar_users?useUnicode=true&characterEncoding=UTF-8
PostgreSQL
                  jdbc:postgresql://mydatabasehost:5432/SuperSTAR_Users
DB2
jdbc:db2://mydatabasehost:50000/SuperSTAR_Users:currentSchema=SuperSTAR
Oracle
jdbc:oracle:thin:@mydatabasehost:1521:SuperSTAR_Users
SQL Server
jdbc:sqlserver://mydatabasehost:1433;databaseName=SuperSTAR_Users
USERNAME The username for the account you created in Step 1.
PASSWORDThe password for the account you created in Step 1. 
DBTYPE

One of the following strings:

StringRDBMS
H2
Embedded H2
MySQL
MySQL / MariaDB
Postgres
PostgreSQL
DB2-LUW
The Linux/Unix/Windows edition of DB2
DB2-zOS
                
The z/OS edition of DB2
Oracle
Oracle
SQLServer
SQL Server

...