DataSource with Jackrabbit

[Nicolas Muller, modificado hace 14 años.]

Hello,

I am using the database persistence manager in an environnment WebSphere 6 - Sql Server 2005.
For developpment I am using Tomcat 6 and Sql Serveur 2005.

This is my repository.xml file. It is good for Webpshere and Tomcat. Both are using login/password. I cannot configure it with datasource.
My Liferay version is 4.4.2.

<?xml version="1.0"?>

<Repository>

<FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
<param name="driver" value="javax.naming.InitialContext" />
<param name="url" value="java:comp/env/jdbc/JCR" />
<param name="schema" value="mssql"/>
<param name="schemaObjectPrefix" value="J_R_FS_"/>
</FileSystem>

<Security appName="Jackrabbit">
<AccessManager class="org.apache.jackrabbit.core.security.SimpleAccessManager" />
<LoginModule class="org.apache.jackrabbit.core.security.SimpleLoginModule">
<param name="anonymousId" value="anonymous" />
</LoginModule>
</Security>
<Workspaces rootPath="${rep.home}/workspaces" defaultWorkspace="liferay" />
<Workspace name="${wsp.name}">
<PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.MSSqlPersistenceManager">
<param name="driver" value="javax.naming.InitialContext" />
<param name="url" value="java:comp/env/jdbc/JCR" />
<param name="schema" value="mssql" />
<param name="schemaObjectPrefix" value="J_PM_${wsp.name}_" />
<param name="externalBLOBs" value="false" />
</PersistenceManager>
<FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
<param name="driver" value="javax.naming.InitialContext" />
<param name="url" value="java:comp/env/jdbc/JCR" />
<param name="schema" value="mssql"/>
<param name="schemaObjectPrefix" value="J_FS_${wsp.name}_"/>
</FileSystem>
</Workspace>

<Versioning rootPath="${rep.home}/version">
<FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
<param name="driver" value="javax.naming.InitialContext" />
<param name="url" value="java:comp/env/jdbc/JCR" />
<param name="schema" value="mssql"/>
<param name="schemaObjectPrefix" value="J_V_FS_"/>
</FileSystem>
<PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.MSSqlPersistenceManager">
<param name="driver" value="javax.naming.InitialContext" />
<param name="url" value="java:comp/env/jdbc/JCR" />
<param name="schema" value="mssql" />
<param name="schemaObjectPrefix" value="J_V_PM_" />
<param name="externalBLOBs" value="false" />
</PersistenceManager>
</Versioning>


</Repository>

Do you have any ideas about ?

Thank a lot. With the datasource config I Have always this error :

Caused by: org.apache.jackrabbit.core.fs.FileSystemException: failed to initialize file system
at org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.init(DatabaseFileSystem.java:196)
at org.apache.jackrabbit.core.config.FileSystemConfig.createFileSystem(FileSystemConfig.java:47)
... 64 more
Caused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.apache.jackrabbit.core.fs.db.DbFileSystem.getConnection(DbFileSystem.java:187)
at org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.initConnection(DatabaseFileSystem.java:956)
at org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.init(DatabaseFileSystem.java:175)

Thanks a lot for your help

[Victor Zorin, modificado hace 14 años.]

Misconfigured driver and datasource, try the following:

<filesystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
		<param name="driver" value="net.sourceforge.jtds.jdbc.Driver">
		<param name="url" value="jdbc:jtds:sqlserver://your-db-hostname:1433/you_db_name_jcr">
		<param name="user" value="your-db-username">
		<param name="password" value="your-db-passowrd">
		<param name="schema" value="mssql">
		<param name="schemaObjectPrefix" value="J_R_FS_">
	</filesystem>

The above configuration uses jtds library for comms with MSSQL server.

[Brian Scott Schupbach, modificado hace 14 años.]

Hi Nicolas,

I am experiencing the same error when I am setting up my repository.xml file. Were you able to figure out how to use connection pooling with jackrabbit and mysql?

Any information you have would be greatly appreciated.

Thanks!

[Mark Doerr, modificado hace 14 años.]

I am curious to hear from someone who has successfully configured the Jackrabbit repository to use JNDI in Liferay. Anyone?

[Rodrigo Marquez, modificado hace 14 años.]

Me too. Someone has the solution for jackrabbit + oracle + JNDI?

[Chris Whittle, modificado hace 13 años.]

any one got an answer on this?

[Vanita Chawla, modificado hace 13 años.]

Has anyone got Liferay 5.2.4 (EE or CE) / Jackrabbit to work with a datasource (in weblogic or any other app server) and Oracle? We are getting ready to use Liferay 5.2.4 EE with Weblogic 10.3 and Oracle.

A few other questions:

• Do we need another database for Jackrabbit document library or can it coexist with the Portal database?
• Does it need a seperate database user other than the one Liferay Portal uses? In other words, can the Portal datasource be used for Jackrabbit as well?
• Has anyone used Jackrabbit with Oracle and Weblogic successfully before, specially in a clustered configuration?
• Is it possible to install Liferay with the document library file system hook and while the document library is empty switch it to use Jackrabbit, Weblogic datasource with Oracle database?

Any insight is much appreciated.

Thanks.
Vanita

[Chris Whittle, modificado hace 13 años.]

Hi Vanita,

Do we need another database for Jackrabbit document library or can it coexist with the Portal database?

Yes it's a separate database... See here for setup options

Does it need a seperate database user other than the one Liferay Portal uses? In other words, can the Portal datasource be used for Jackrabbit as well?

We used the same database user for both databases.. One thing I would also suggest is if you are going to use a DB datasource for your jackrabbit use a JNDI (see here)it's a pain to have both the workspace.xml and repository.xml with both of them having credentials stored...

Has anyone used Jackrabbit with Oracle and Weblogic successfully before, specially in a clustered configuration?

No we haven't.. I have heard Oracle is a pain but no first hand experience so don't take my word for it... We attempted a Weblogic Server and DB2 before during our POC and between having performance issues and other random issues with the server and not ever finding the correct one size fit all dialect for DB2 we gave up and went to using 5.2.4 EE, Tomcat, and SQLServer for our setup...

Is it possible to install Liferay with the document library file system hook and while the document library is empty switch it to use Jackrabbit, Weblogic datasource with Oracle database?

I would say yes as long as it's empty... once you do switch you will need to clean out all the files/folders (except your configuration files) in whatever your repository folder is...

[Vanita Chawla, modificado hace 13 años.]

Thanks Chris! It helps a lot.

regards
Vanita