[Hippo-cms7-user] Persisting to mysql

Paul Bakker p.bakker at sourcesense.com
Wed Apr 8 11:27:28 CEST 2009


This is it:


<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE Repository PUBLIC "-//The Apache Software Foundation//DTD Jackrabbit 1.4//EN"
    "http://jackrabbit.apache.org/dtd/repository-1.4.dtd">
<Repository>


  <FileSystem class="org.apache.jackrabbit.core.fs.db.JNDIDatabaseFileSystem">
    
    
    
    
  </FileSystem>


  <Security appName="Jackrabbit">
    <AccessManager class="org.hippoecm.repository.security.HippoAccessManager"/>
    <LoginModule class="org.hippoecm.repository.security.HippoLoginModule"/>
  </Security>

  <Workspaces rootPath="${rep.home}/workspaces" defaultWorkspace="default"/>

  <Workspace name="${wsp.name}">
    <FileSystem class="org.apache.jackrabbit.core.fs.db.JNDIDatabaseFileSystem">
      
      
      
      
    </FileSystem>

    <PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager">
      
      
      
      
      
      
      
      
    </PersistenceManager>

    <SearchIndex class="org.hippoecm.repository.FacetedNavigationEngineThirdImpl">
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
    </SearchIndex>
  </Workspace>

  <Versioning rootPath="${rep.home}/version">
    <FileSystem class="org.apache.jackrabbit.core.fs.db.JNDIDatabaseFileSystem">
      
      
      
      
    </FileSystem>

    <PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager">
      
      
      
      
      
      
      
      
    </PersistenceManager>
  </Versioning>

  <SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
    
    
    
  </SearchIndex>

  <DataStore class="org.apache.jackrabbit.core.data.db.DbDataStore">
    
    
    
    
    
    
    <!-- broken in JR.. param name="tablePrefix" value="repository_"/ -->
  </DataStore>
</Repository>



It should be enough. Can you post your repository.xml?


On Wed, Apr 8, 2009 at 4:36 AM, Paul Bakker <p.bakker at sourcesense.com> wrote:
>
> Well, one jar: mysql-connector-java-5.1.6-bin.jar
> That should be enough shouldn't it?
>
>
> Hi Paul,
>
> Did you add the mysql jars to tomcat?
>
> Bart
>
> On Tue, Apr 7, 2009 at 4:19 PM, Paul Bakker <p.bakker at sourcesense.com> wrote:
>>
>> I have a another question about using MySQL.
>> If I take a webapp that uses mysql and runs fine in jetty, and I put it in tomcat, I get a RepositoryException:
>>
>>
>> javax.jcr.RepositoryException: Cannot instantiate persistence manager org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager: Not supported by BasicDataSource: Not supported by BasicDataSource
>>        at org.apache.jackrabbit.core.RepositoryImpl.createPersistenceManager(RepositoryImpl.java:1163)
>>        at org.apache.jackrabbit.core.RepositoryImpl.createVersionManager(RepositoryImpl.java:390)
>>        at org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:294)
>>
>>
>> The bit that I put in tomcat's server.xml is:
>>
>>
>>         <Context path="/cms" docBase="/tmp/website2/cms/target/website2-cms-1.0-SNAPSHOT" debug="0" reloadable="true">
>>            <Resource name="jdbc/hrepositoryDS"
>>                     type="javax.sql.DataSource"
>>                     auth="Container"
>>                     username="uname"
>>                     password="passw"
>>                     driverClassName="com.mysql.jdbc.Driver"
>>                     url="jdbc:mysql://localhost:3306/testhippodb?autoReconnect=true"
>>                     maxActive="100"
>>                     maxIdle="30"
>>            />
>>         </Context>
>>
>>
>> I suppose this is a tomcat question, but does anybody know what's going on?
>>
>> --
>> View this message in context: http://n2.nabble.com/Persisting-to-mysql-tp2409564p2599207.html
>> Sent from the Hippo CMS 7 mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> Hippo-cms7-user mailing list and forums
>> http://www.onehippo.org/cms7/support/community.html
>>
>
>
>
> --
> Hippo B.V.  -  Amsterdam
> Oosteinde 11, 1017 WT, Amsterdam, +31(0)20-5224466
>
> Hippo USA Inc.  -  San Francisco
> 101 H Street, Suite Q, Petaluma CA, 94952-3329, +1 (707) 773-4646
> -----------------------------------------------------------------
> http://www.onehippo.com   -  info at onehippo.com
> -----------------------------------------------------------------
> _______________________________________________
> Hippo-cms7-user mailing list and forums
> http://www.onehippo.org/cms7/support/community.html
>
>
>
> --
> View this message in context: http://n2.nabble.com/Persisting-to-mysql-tp2409564p2602776.html
> Sent from the Hippo CMS 7 mailing list archive at Nabble.com.
>
> _______________________________________________
> Hippo-cms7-user mailing list and forums
> http://www.onehippo.org/cms7/support/community.html
>



-- 
Hippo B.V.  -  Amsterdam
Oosteinde 11, 1017 WT, Amsterdam, +31(0)20-5224466

Hippo USA Inc.  -  San Francisco
101 H Street, Suite Q, Petaluma CA, 94952-3329, +1 (707) 773-4646
-----------------------------------------------------------------
http://www.onehippo.com   -  info at onehippo.com
-----------------------------------------------------------------
_______________________________________________
Hippo-cms7-user mailing list and forums
http://www.onehippo.org/cms7/support/community.html



-- 
View this message in context: http://n2.nabble.com/Persisting-to-mysql-tp2409564p2604137.html
Sent from the Hippo CMS 7 mailing list archive at Nabble.com.




More information about the Hippo-cms7-user mailing list