View source for SMILA/Documentation/Adding JDBC Drivers

=== Adding JDBC Drivers ===

By default SMILA includes only JDBC drivers for Derby. If you want to access other databases then you have to provide according JDBC drivers.
To add a JDBC driver you have to do the following steps:
* Copy your JDBC driver jars into folder <tt>SMILA/plugins/org.eclipse.smila.jdbc/lib</tt>
* Edit <tt>SMILA/plugins/org.eclipse.smila.jdbc/META-INF/MANIFEST.MF</tt> and add the jars to the bundle classpath, e.g.
<pre>
Bundle-ClassPath: .,
 lib/postgresql-9.1-902.jdbc4.jar,
 lib/mysql-connector-java-5.1.20-bin.jar
</pre>
* '''Do not forget the whitespace character in front of the path.'''
* JDBC-4-compliant drivers should be found automatically after a restart. For other drivers you must add the driver class name to the <tt>SMILA-JDBC</tt> header in <tt>META-INF/MANIFEST.MF</tt>, e.g.
<pre>
SMILA-JDBC: org.apache.derby.jdbc.EmbeddedDriver,
 org.apache.derby.jdbc.ClientDriver
</pre>


[[Category:SMILA]]