Homepage | About EASA | Contact
EASA ships with Java database drivers for both MySQL and Microsoft Access.
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) |