Appboard/2.5/admin/db drivers: Difference between revisions
imported>Jason.nicholls No edit summary |
imported>Jason.nicholls |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 7: | Line 7: | ||
{{Tip|For convenience and best practice it's recommended to add the drivers required in your environment to the custom export properties file. This way archives will include the drivers and they will not have to be installed separately. Refer to the [[appboard/2.5/admin/backup_and_recovery#Customizing_the_Export|Backup & Recovery]] documentation for more information}} | {{Tip|For convenience and best practice it's recommended to add the drivers required in your environment to the custom export properties file. This way archives will include the drivers and they will not have to be installed separately. Refer to the [[appboard/2.5/admin/backup_and_recovery#Customizing_the_Export|Backup & Recovery]] documentation for more information}} | ||
== Included JDBC Drivers == | |||
{|class='wikitable' | |||
!Database | |||
!Filename | |||
!Notes | |||
|- | |||
|MySQL / MariaDB | |||
|<tt>mariadb-java-client-1.1.8.jar</tt> | |||
|The default driver used for MySQL and MariaDB connections. Alternatively install the MySQL driver (see below). | |||
|- | |||
|PostgreSQL | |||
|<tt>postgresql-9.3-1102-jdbc41.jar</tt> | |||
| | |||
|} | |||
== Installing a JDBC Driver == | |||
To install a new database driver: | To install a new database driver: | ||
| Line 24: | Line 41: | ||
|http://dev.mysql.com/downloads/connector/j/ | |http://dev.mysql.com/downloads/connector/j/ | ||
|<tt>mysql-connector-java-''version''-bin.jar</tt> | |<tt>mysql-connector-java-''version''-bin.jar</tt> | ||
|- | |- | ||
|Oracle | |Oracle | ||
| Line 44: | Line 57: | ||
|http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect | |http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect | ||
|<tt>jconn2.jar</tt> | |<tt>jconn2.jar</tt> | ||
|- | |||
|Cloudera Impala (Apache Hive) | |||
|contact Edge support | |||
|''multiple files'' | |||
|} | |} | ||
Latest revision as of 17:06, 4 February 2015
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.3-1102-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 |
| Cloudera Impala (Apache Hive) | contact Edge support | multiple files |
