Sidebar
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
- In Administrator-mode, download, and install test a driver on a running EASA Server at: EASA > Configure > Configure Drivers
- Test the installed driver at: EASA > Configure > Configure Drivers > Configure Databases
- 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