The Penrose Project

• Overview
  • News
  • FAQ
  • Features
  • Licenses
  • Download
  • Demo
• Documentation
  • Quick Start
  • Version 1.2 (in development)
    • Complete
    • Server User Guide
    • Studio User Guide
    • Developer Guide
    • Embedding Penrose
    • Javadoc
  • Version 1.1 (stable)
    • Complete
    • Server User Guide
    • Studio User Guide
    • Developer Guide
    • Embedding Penrose
    • Javadoc
  • Use Cases
  • Community Wiki
• Developer
  • Nightly Builds
  • Code Repository
  • Road Map
  • Change Log
  • Project Management
• Support
  • WebChat
  • Forum & List
  • Bug/Feature Tracker
  • Team
  • Contact

Installing JDBC Driver

JDBC Drivers

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

• MySQL
• 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.