Appendix: Downloading and Installing Third Party JDBC Drivers

<< Click to Display Table of Contents >>

Navigation:  Installing SQLstream Blaze > Installation Guide Appendix >

Appendix: Downloading and Installing Third Party JDBC Drivers

Previous pageReturn to chapter overviewNext page

The SQL/MED plugin lets SQLstream s-Server interface with third-party databases such as Oracle, Microsoft SQL Server, PostgreSQL, MySQL, and Teradata.

The s-Server installer includes JDBC drivers for Oracle, Microsoft SQL Server, Teradata, and PostgreSQL SQL. Those drivers require no additional steps to use.

In order to use other JDBC drivers with SQLstream s-Server, you need to copy all required jar files to the $SQLSTREAM_HOME/corelib directory and restart s-Server.

Installing the MySQL JDBC Driver

To use the MySQL JDBC driver, download the driver package from http://dev.mysql.com/downloads/connector/j/

Next, copy the file mysql-connector-java.jar to $SQLSTREAM_HOME/corelib and restart s-Server.

Note: s-Server is currently defined to use mysql-connector-java-3.1.14-bin.jar. If you are using a version of mysql-connector other than this one, you will need to edit a script in $SQLSTREAM_HOME/bin/ called defineAspenRuntime.sh. To do so, open this script in a text editor and search for "mysql". The line you need to change is as follows:

MYSQL_DRIVER=$EIGEN_HOME/thirdparty/mysql-connector/mysql-connector-java-3.1.14-bin.jar

Note: Some Linux distributions include the MySQL JDBC driver as part of their installation package. If this is the case for your Linux distribution, then copy the file /usr/share/java/mysql-connector-java.jar to $SQLSTREAM_HOME/corelib and restart s-Server.