User Tools

Site Tools


Database drivers in EASA

EASA ships with a Java database driver for MySQL.

Here we provide details to independently download (for licensing reasons) and configure other database drivers.

EASA software is tested to be compatible with the following databases:

  • MySQL
  • SQL Server
  • Postgres
  1. In Administrator-mode, download, and install test a driver on a running EASA Server at: EASA > Configure > Configure Drivers
  2. Test the installed driver at: EASA > Configure > Configure Drivers > Configure Databases
  3. Restart the EASA Server
Database Type Driver Name
Download Link
MYSQL com.mysql.jdbc.Driver (shipped with EASA)
https://dev.mysql.com/downloads/connector/j/
MS SQL Server
com.microsoft.sqlserver.jdbc.SQLServerDriver
Insure database-jdbc driver compatibility and download a driver
Update to at least 4.1 to avoid a bug in 4.0 (2008) which causes saved-then-retrieved dates to be two days younger
4.2 or later is recommended
Oracle 8i/9i/10g oracle.jdbc.driver.OracleDriver
https://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
Use thin JDBC driver for use with JDK 1.2 or 1.3, drivers for 1.4 or higher will not work
PostgreSQL org.postgresql.Driver
https://jdbc.postgresql.org/download.html
Database Type URL
MYSQL jdbc:mysql://<hostname>:<port-number>/<database-name>?<parameter-list>
MS SQL Server Jdbc:sqlserver://<host-name>:<port-number>;DatabaseName=<database-name>
Oracle 8i/9i/10g jdbc:oracle:thin:@<domain>:<port-number>:<database-name>
PostgreSQL jdbc:postgresql://<host-name>:<port-number>/<database-name>
ODBC not supported (from Java 8 onward)

<text-inside-tags> should be replaced (including tags) according to the specific database configuration:

  • host-name - Domain or machine name where the database is installed
  • port-number - Port number where the database listens for connections
  • database-name - The database name
  • parameter-list - Some databases allow a list of parameters as a part of the URL
  • domain - Account domain name to log in to the database (Oracle)
  • path-to-database-data - three slashes and then the absolute path to a file

URL examples:

  • MySQL - jdbc:mysql://localhost:3306/test?autoReconnect=true
  • Oracle - jdbc:oracle:thin:@localhost:1521:TEST
  • MS SQL Server - jdbc:sqlserver://localhost:1433;DatabaseName=test
  • PostgreSQL - jdbc:postgresql://localhost:5432/test