looking for sample config for BundleDbPersistenceManager

[Ijonas Kisselbach <ij...@gmail.com>]

Hi,

I'm trying to get the BundleDbPersistenceManager to work and I'm not getting
very far... Can someone tell me where I'm going wrong or post a sample
config ? Does the PM execute the DDL file, or do I have to run that manually
to create the underlying tables ?

Thanks,
Ijonas Kisselbach.

My setup:
Model-2 deployment of Jackrabbit via JCA on JBoss 4.0.5 and MySQL on Mac OS
X 10.4.9

My config:
        <PersistenceManager class="
org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager">
          <param name="driver" value="com.mysql.jdbc.Driver"/>
          <param name="url" value="jdbc:mysql://localhost/jackrabbit"/>
          <param name="user" value="jcr"/>
          <param name="password" value="jcr"/>
        </PersistenceManager>


My jboss stack trace:
15:22:22,679 INFO  [RepositoryImpl] Starting repository...
15:22:22,699 INFO  [LocalFileSystem] LocalFileSystem initialized at path
/Users/ijonas/java/jboss/jackrabbit/repository
15:22:22,823 INFO  [NodeTypeRegistry] no custom node type definitions found
15:22:22,831 INFO  [LocalFileSystem] LocalFileSystem initialized at path
/Users/ijonas/java/jboss/jackrabbit/version
15:22:22,889 INFO  [BundleDbPersistenceManager] JDBC driver created:
com.mysql.jdbc.Driver@fa5c30
15:22:23,222 INFO  [jcr/local] Failed to create repository
15:22:23,222 INFO  [jcr/local] javax.jcr.RepositoryException: Cannot
instantiate persistence manager
org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager:
null: null
15:22:23,223 INFO  [jcr/local]  at
org.apache.jackrabbit.core.RepositoryImpl.createPersistenceManager(
RepositoryImpl.java:1184)
15:22:23,223 INFO  [jcr/local]  at
org.apache.jackrabbit.core.RepositoryImpl.createVersionManager(
RepositoryImpl.java:365)
15:22:23,223 INFO  [jcr/local]  at org.apache.jackrabbit.core.RepositoryImpl
.<init>(RepositoryImpl.java:282)
15:22:23,223 INFO  [jcr/local]  at
org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:584)
15:22:23,223 INFO  [jcr/local]  at
org.apache.jackrabbit.jca.JCARepositoryManager$Reference.create(
JCARepositoryManager.java:167)
15:22:23,223 INFO  [jcr/local]  at
org.apache.jackrabbit.jca.JCARepositoryManager.createRepository(
JCARepositoryManager.java:75)
15:22:23,223 INFO  [jcr/local]  at
org.apache.jackrabbit.jca.JCAManagedConnectionFactory.createRepository(
JCAManagedConnectionFactory.java:289)
15:22:23,223 INFO  [jcr/local]  at
org.apache.jackrabbit.jca.JCAManagedConnectionFactory.createConnectionFactory
(JCAManagedConnectionFactory.java:124)
15:22:23,223 INFO  [jcr/local]  at
org.jboss.resource.connectionmanager.ConnectionFactoryBindingService.createConnectionFactory
(ConnectionFactoryBindingService.java:128)
15:22:23,223 INFO  [jcr/local]  at
org.jboss.resource.connectionmanager.ConnectionFactoryBindingService.startService
(ConnectionFactoryBindingService.java:65)

Re: looking for sample config for BundleDbPersistenceManager

[Jukka Zitting <ju...@gmail.com>]

Hi,

On 6/4/07, Ijonas Kisselbach <ij...@gmail.com> wrote:
> I'm trying to get the BundleDbPersistenceManager to work and I'm not getting
> very far... Can someone tell me where I'm going wrong or post a sample
> config?

You need to add the following parameters:

    <param name="schema" value="mysql"/>
    <param name="schemaObjectPrefix" value="${wsp.name}"/>

I guess both of these could be the set as defaults, or at least the
error log could be more precise about the problem. And of course we
should have documentation for the configuratio. Could you please file
Jira issues for these?

> Does the PM execute the DDL file, or do I have to run that manually
> to create the underlying tables ?

The PM automatically executes the DDL file if it doesn't find the
tables it needs. The only requirement is that the configured database
account has the right to create tables.

BR,

Jukka Zitting