Handling more JDBC connections with Dekho

Dekho can handle a lot of JDBC connections. Most users store their data using Microsoft SQL Server 2008 R2 or Oracle. What happens if you want to connect to some other type of databases?

In Dekho, some of the drivers are not automatically included. There are several reasons for this, but the most likely is a licensing/redistribution issue.  As a user, you can always get the .jar file (java library) and resolve the issue.

Here is a list of Drivers and the URL location to assist you locate the Java libraries needed.
( See step by step tutorial below for installation)

Driver Info
DB2 (IBM) Info: http://www.ibm.com/software/data/db2/udb/Jar File: Supported – no need to install extra .jar
HSQLDBServer Info: http://hsqldb.org/Download : http://sourceforge.net/projects/hsqldb/files/Jar File: hsqldb.jar + sqltool.jar
Informix Info:  http://www.oxygenxml.com/database_drivers.html
Download: http://www.systhemes.ca/download/public/informix/jdbc/Jar File:  ifxjdbcx.jar
JDBC/ODBC bridge
McKoi Info: http://www.mckoi.com/database/JDBCDriver.html
Download: http://www.mckoi.com/database/ver/mckoi1.0.6.zipJar File : mckoidb.jar + mkjdbc.jar
MySQL Info: http://dev.mysql.com/downloads/connector/j/Download: http://mirror.cogentco.com/pub/mysql/Connector-J/mysql-connector-java-5.1.25.zipJar File : mysql-connector-java-5.1.25-bin.jar
Oracle Info: http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-10201-088211.html
Jar File : Already installed in Dekho
Postgres Info : http://jdbc.postgresql.org/Download : http://jdbc.postgresql.org/download.htmlJar File : postgresql-9.2-1002.jdbc4.jar
SQL Server 2000 Info : http://msdn.microsoft.com/en-US/data/aa937724.aspxDownload: sqljdbc_4.0.2206.100_enu.exe from http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774
Jar File : sqljdbc4.jar + sqljdbc.jar
Sybase Info: http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnectDownload: http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnectJar File:


Example on how to add the MySQL functionality:
1. Download mysql-connector-java-5.1.25.zip (see link above)
2. Extract out the <mysql-connector-java-5.1.25-bin.jar>
3. Copy it in your Tomcat folder in  /web-apps/Dekho/web-inf/lib
4. Restart Tomcat
5. Go To Dekho:Admin:DataSources
5.1 Add
5.2 select [com.mysql.jdbc.Driver]
5.3 URL = jdbc:mysql://{databaseServerName}:{port3306}/{customerDatabase}
5.4 SCHEMA is optional
5.5 Username/password
6. Click TEST then OK

Well done! You can now use the Database tables from your MySql connection.

References : http://www.oxygenxml.com/database_drivers.html

Dekho Help : http://dekho.com.au/help/40/default.htm?turl=Documents%2Fapplicationintegration1.htm

This entry was posted in Other and tagged , , , , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *