Appboard/2.6/admin/db drivers
Due to licensing restrictions AppBoard ships with a limited set of JDBC drivers. The appropriate drivers may need to be installed to interface with your chosen configuration database or data sources.
Included JDBC Drivers
Database | Filename | Notes |
---|---|---|
MySQL / MariaDB | mariadb-java-client-1.1.8.jar | The default driver used for MySQL and MariaDB connections. Alternatively install the MySQL driver (see below). |
PostgreSQL | postgresql-9.4-1201-jdbc41.jar |
Installing a JDBC Driver
To install a new database driver:
- download the driver file or package, usually there is a .jar which is the relevant file.
- copy the driver to: [INSTALL_HOME]/webapps/enportal/WEB-INF/lib/
- restart AppBoard.
See below for a table of common drivers and where to obtain them.
Database | Link to JDBC driver | Filename |
---|---|---|
MySQL | http://dev.mysql.com/downloads/connector/j/ | mysql-connector-java-version-bin.jar |
Oracle | http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html | oracle-thinJDBC-version.jar |
SQL Server | http://jtds.sourceforge.net/ | jtds-version.jar |
DB2 | http://www-01.ibm.com/software/data/db2/linux-unix-windows/downloads.html | db2jcc4.jar |
Sybase (jConnect 5.5) | http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect | jconn2.jar |
HSQLDB | http://hsqldb.org/ | hsqldb.jar |
Cloudera Impala (Apache Hive) | contact Edge support | multiple files |