Appboard/2.4/admin/db drivers: Difference between revisions

imported>Jason.nicholls
No edit summary
imported>Jason.nicholls
No edit summary
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{DISPLAYTITLE:Loading Database Drivers}}
{{DISPLAYTITLE:Loading Database Drivers}}
[[Category:AppBoard 2.4]]
Due to licensing restrictions AppBoard does not ship with JDBC database drivers. Loading the appropriate drivers for the specific databases being access is required. This is if using an external configuration database, or for database data sources.


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.


{{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.}}
{{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.}}


To install a new database driver:
To install a new database driver:
Line 21: Line 24:
|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>
|-
|PostgreSQL
|http://jdbc.postgresql.org/
|<tt>postgresql-''version''.jdbc4.jar</tt>
|-
|Oracle
|http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
|<tt>oracle-thinJDBC-''version''.jar</tt>
|-
|SQL Server
|http://jtds.sourceforge.net/
|<tt>jtds-''version''.jar</tt>
|-
|DB2
|http://www-01.ibm.com/software/data/db2/linux-unix-windows/downloads.html
|<tt>db2jcc4.jar</tt>
|-
|Sybase (jConnect 5.5)
|http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect
|<tt>jconn2.jar</tt>
|}
|}

Latest revision as of 11:10, 18 July 2014


Due to licensing restrictions AppBoard does not ship with JDBC database drivers. Loading the appropriate drivers for the specific databases being access is required. This is if using an external configuration database, or for database data sources.


Template-tip.png
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.


To install a new database driver:

  1. download the driver file or package, usually there is a .jar which is the relevant file.
  2. copy the driver to: [INSTALL_HOME]/webapps/enportal/WEB-INF/lib/
  3. 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