Appendix: Installing the MySQL Driver

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<%version%>.jar to $SQLSTREAM_HOME/lib.

s-Server is currently defined to use mysql-connector-java-3.1.14-bin.jar.

As a result, you will need to create a symbolic link so the old name can be referenced:

    cd $SQLSTREAM_HOME/lib
    ln -s mysql-connector-java-5.1.45-bin.jar mysql-connector-java-3.1.14-bin.jar 

After copying the file and creating the symbolic link, restart s-Server.