Homepage | About EASA | Contact
Sidebar
Database drivers in EASA
EASA ships with Java database drivers for both MySQL and Microsoft Access.
- Download, install and test a driver on a running EASA Server via,
- EASA→Set Mode→Administrator→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 Access | net.ucanaccess.jdbc.UcanaccessDriver (shipped with EASA) http://ucanaccess.sourceforge.net/site.html |
| MS SQL Server | com.microsoft.sqlserver.jdbc.SQLServerDriver https://www.microsoft.com/en-us/download/search.aspx?q=jdbc Warning, 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 |
| 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>:<PortNumber>/<DatabaseName>?<ParameterList> |
| MS Access | jdbc:ucanaccess:///<path-to-database-data> (note the three slashes) |
| MS SQL Server | Jdbc:sqlserver://<HostName>:<PortNumber>;DatabaseName=<DatabaseName> |
| Oracle 8i/9i/10g | jdbc:oracle:thin:@<Domain>:<PortNumber>:<DatabaseName> |
| PostgreSQL | jdbc:postgresql://<HostName>:<PortNumber>/<DatabaseName> |
| ODBC | not supported (from Java 8 onward) |
- Text inside < > should be replaced according to the specific database configuration,
- HostName → Domain or machine name where the database is installed
- PortNumber → Port Number where the database listens for connections
- DatabaseName → The database name
- ParameterList → 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 Access → jdbc:ucanaccess:///Users/easa-user/StockData.mdb
- MS SQL Server → jdbc:sqlserver://localhost:4900;DatabaseName=test
- PostgreSQL → jdbc:postgresql://localhost:5432/test