jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Mueller <muel...@adobe.com>
Subject Re: HSQLDB as persistence manager
Date Mon, 14 Feb 2011 08:03:47 GMT
Hi,

I didn't test HSQLDB recently, but it looks like you would need to create
a special hsqldb.ddl file first, in
jackrabbit-core/src/main/resources/org/apache/jackrabbit/core/persistence/b
undle/hsqldb.ddl - and then use the following configuration:

<PersistenceManager
class="org.apache.jackrabbit.core.persistence.pool.BundleDbPersistenceManag
er">
    <param name="driver" value="org.hsqldb.jdbcDriver"/>
    <param name="url"
value="jdbc:hsqldb:${wsp.home}/db;create=true;hsqldb.default_table_type=cac
hed"/>
    <param name="schemaObjectPrefix" value="${wsp.name}_"/>
    <param name="databaseType" value=hsqldb/>
</PersistenceManager>


If you don't use "sqldb.default_table_type=cached", HSQLDB will try to
keep all data in memory (which is faster, but quickly runs out of memory).
When comparing HSQLDB with other databases, please note HSQLDB has lower
durability goals (unlike H2, HSQLDB doesn't call FileDescriptor.sync).

Regards,
Thomas


Mime
View raw message