Appboard/2.4/admin/db drivers: Difference between revisions
imported>Jason.nicholls No edit summary |
imported>Jason.nicholls No edit summary |
||
Line 38: | Line 38: | ||
|http://www-01.ibm.com/software/data/db2/linux-unix-windows/downloads.html | |http://www-01.ibm.com/software/data/db2/linux-unix-windows/downloads.html | ||
|<tt>db2jcc4.jar</tt> | |<tt>db2jcc4.jar</tt> | ||
|- | |||
|Sybase (jConnect 5.5) | |||
|http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect | |||
|<tt>jconn2.jar</tt> | |||
|} | |} |
Revision as of 02:55, 1 April 2014
Due to licensing restrictions many common JDBC database drivers do not ship with the core AppBoard product. As a result these need to be added in order for the relevant database Data Sources to work.
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 |
PostgreSQL | http://jdbc.postgresql.org/ | postgresql-version.jdbc4.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 |