z2-Environment

h1. How to add other JDBC drivers

(DRAFT)

There are different alternatives on how to add a JDBC driver to Z2. If you set up your own system (as in [[How to create your own system]]) we recommend to stick to the Z2 convention and put all JDBC drivers into the module *com.zfabrik.db.drivers*.

Another approach that should work as well is to put your drivers into your domain module (as in for example [[Sample-hibernate-basic]]), or if you have more than one, in some shared utility module that is referenced by all domain modules.

The latter approach applies in particular, if you want to modify the existing samples without setting up your own *z2-base.base* clone. 

Let's assume we want to use the sample [[Sample-hibernate-basic]] with MySQL instead of Derby. Due to licensing issues, Z2 does not contain the MySQL JDBC driver.

If you have the sample installed and setup, go to http://dev.mysql.com/downloads/connector/j/ and download the JDBC driver for MySQL. Extract the .jar file into *com.zfabrik.samples.hibernate-basic.domain/java/bin.api/lib*.

Modify the persistence unit definition in *com.zfabrik.samples.hibernate-basic.domain/java/src.impl/META-INF/persistence.xml* to use 

<pre><code class="xml">

<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect" />

</code></pre> 

instead of using the Derby dialect. Also change *com.zfabrik.samples.hibernate-basic.domain/DB.properties* to say

<pre><code class="ruby">

ds.prop.driverClass=com.mysql.jdbc.Driver

ds.prop.user=<user>

ds.prop.password=<password>

ds.prop.url=jdbc:mysql://localhost:3306/<database>

</code></pre> 

where of course the user name, password, and specifics of the JDBC URL need to be adapted.