This is a cheat sheet reference for configuration of the beans used in the Reporting package of MIStudio and TransSECS (see Reporting and Historical Servers).

In the references below, substitute “hostname” in the Database URL with the ip address of the database server. The format for a cloud connection will be slightly different, and can be found in the references provided when you set up the database in the cloud. In all cases the name of the database is “db_name” for consistency.

The latest JDBC driver can be found at: https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15

Database Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver

Database URL:

 jdbc:sqlserver://hostname:1433;databaseName=db_name 

The latest community edition of the JDBC driver can be found at: https://dev.mysql.com/downloads/connector/j/

Database Driver Class: com.mysql.cj.jdbc.Driver (this has changed, but older drivers will use com.mysql.jdbc.Driver)

Database URL:

 jdbc:mysql://hostname/db_name 
  or, with parameters, such as:  
 jdbc:mysql://hostname/db_name?socketTimeout=5000&connectTimeout=5000