Configuring the back end storage

Meandre Storage

By default, Meandre relies on Jena back end storage system. Detailed information of the supported back end relational stores can be found at http://jena.sourceforge.net/DB/. When booted from scratch Meandre uses and embedded version of Derby to satisfy persistency requirements.

Derby

The example listed below shows an example of the meandre-config-store.xml to point to an embedded Derby back end. For the embedded usage, Meandre creates the Derby database if it does not exist.

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
   <comment>Meandre storage configuration file for an embedded Derby back end</comment>
   <entry key="DB_USER"></entry>
   <entry key="DB_DRIVER_CLASS">org.apache.derby.jdbc.EmbeddedDriver</entry>
   <entry key="DB">Derby</entry>
   <entry key="MEANDRE_ADMIN_USER">admin</entry>
   <entry key="MEANDRE_AUTHENTICATION_REALM_FILENAME">./meandre-realm.properties</entry>
   <entry key="MEANDRE_STORE_CONFIG_FILE">./meandre-config-store.xml</entry>
   <entry key="DB_PASSWD"></entry>
   <entry key="DB_URL">jdbc:derby:./MeandreStore;create=true;logDevice=./DerbyLog</entry>
</properties>

MySQL

The example listed below shows an example of the meandre-config-store.xml to point to a MySQL back end. The MySQL database needs to be created by the database administrator, and proper permissions granted to the user connecting to the database. More information about how to manage a MySQl server can be found at http://dev.mysql.com/doc/refman/5.0/en/.

 
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
  <comment>Meandre storage configuration file for a MySQL back end</comment>
  <entry key="DB_USER">meandre</entry>
  <entry key="DB_DRIVER_CLASS">com.mysql.jdbc.Driver</entry>
  <entry key="DB">MySQL</entry>
  <entry key="MEANDRE_ADMIN_USER">admin</entry>
  <entry key="MEANDRE_AUTHENTICATION_REALM_FILENAME">./meandre-realm.properties</entry>
  <entry key="MEANDRE_STORE_CONFIG_FILE">./meandre-config-store.xml</entry>
  <entry key="DB_PASSWD">meandre</entry> 
  <entry key="DB_URL"><![CDATA[jdbc:mysql://your-server.com/Meandre?useUnicode=yes&characterEncoding=utf8&autoReconnect=true]]></entry>
</properties>
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.