JDBC Drivers

Both Penrose Server and Penrose Studio include the following JDBC drivers:

• HSQLDB
• JDBC-ODBC Bridge

If you are using other database server, you need to install the JDBC driver for your database or use the JDBC-ODBC Bridge.

Penrose Server

Assuming Penrose Server is installed in PENROSE_SERVER_HOME, copy your JDBC driver jar file into PENROSE_SERVER_HOME\lib\ext, then restart Penrose Server.

Penrose Studio

Assuming Penrose Studio is installed in PENROSE_STUDIO_HOME, copy your JDBC driver jar file into PENROSE_STUDIO_HOME\plugins\org.safehaus.penrose_x.x.x\lib\runtime.

Then go to PENROSE_STUDIO_HOME\plugins\org.safehaus.penrose_x.x.x\META-INF, edit the MANIFEST.MF, add your JDBC driver into Bundle-ClassPath:

Bundle-ClassPath: penrose-studio-x.x.x.jar,
 lib/runtime/penrose-x.x.x.jar,
 ...
 lib/runtime/mx4j-tools.jar,
 lib/runtime/mysql-connector-java-3.0.16-ga-bin.jar,
 lib/runtime/<jdbc driver>.jar

Note: if you add the new line at the bottom like above, make sure you add a comma at the end of the previous line.

Then go to PENROSE_STUDIO_HOME\configuration, remove the following directories:

org.eclipse.core.runtime
org.eclipse.osgi
org.eclipse.update

Finally, restart Penrose Studio.