jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stefan Guggisberg" <stefan.guggisb...@gmail.com>
Subject Re: hsql?
Date Tue, 27 Jun 2006 12:45:47 GMT
On 6/27/06, Torgeir Veimo <torgeir@pobox.com> wrote:
> Anyone used hsql with jackrabbits SimpleDbPersistenceManager?
>
> I tried with schema set to mysql, but am getting
>
> javax.jcr.RepositoryException: Cannot instantiate persistence manager
> org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager: Wrong
> data type: BLOB in statement [create table VERSION_NODE (NODE_ID
> char(36) not null, NODE_DATA blob]: Wrong data type: BLOB in statement
> [create table VERSION_NODE (NODE_ID char(36) not null, NODE_DATA blob]
>
> Is there another schema type that is a bit better for use with hsql?

try 'default' but you might also create your own hsqldb-specific schema.

cheers
stefan
>
> My config looks like
>
> <PersistenceManager
> class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
>      <param name="driver" value="org.hsqldb.jdbcDriver"/>
>      <param name="url" value="jdbc:hsqldb:${wsp.home}/db"/>
>      <param name="schemaObjectPrefix" value="${wsp.name}_"/>
>      <param name="schema" value="mysql" />
>      <param name="externalBLOBs" value="true"/>
> </PersistenceManager>
>
> --
> -Torgeir
>

Mime
View raw message