jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stefan Guggisberg <stefan.guggisb...@gmail.com>
Subject example db-based persistence manager
Date Fri, 12 Aug 2005 15:44:27 GMT

i added a example for a db-based persistence manager in the
contrib/db-persistence directory.
i wouldn't recommend it for production use, it's thought as an
example/proof of concept to demonstrate the following points:

- simple (if not to say primitive;) schema, using custom bianry serialization 
  format (-> ObjectPersistenceManager) 
- generic
- automatic schema creation (easy deployment)
- transactional 
- ok performance

i successfully tested it with mysql & mssql.

basic docu copied from java doc:

SimpleDbPersistenceManager is a generic JDBC-based PersistenceManager
for Jackrabbit that persists ItemState and NodeReferences objects
using a simple custom serialization format and a very basic
non-normalized database schema (in essence tables with one 'key' and
one 'data' column).

It is configured through the following properties:
- driver: the FQN name of the JDBC driver class
- url: the database url of the form jdbc:subprotocol:subname
- user: the database user
- password: the user's password
- schema: type of schema to be used (e.g. mysql, mssql, etc.);
- schemaObjectPrefix: prefix to be prepended to schema objects
             The required schema objects are automatically created by
executing the DDL
             statements read from the [schema].ddl file. The .ddl file
is read from the resources
             by calling getClass().getResourceAsStream(schema +
".ddl"). Every line in the
             specified .ddl file is executed separatly by calling 
             java.sql.Statement.execute(String) where every occurence
of the the string
             "${schemaObjectPrefix}" has been replaced with the value
of the property

The following is a fragment from a sample configuration:
     <param name="driver" value="com.mysql.jdbc.Driver"/>
     <param name="url" value="jdbc:mysql:///test"/>
     <param name="schema" value="mysql"/>
     <param name="schemaObjectPrefix" value="${wsp.name}_"/>

have fun,


View raw message