You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@jackrabbit.apache.org by "Ricardo Martínez (Commented JIRA)" <ji...@apache.org> on 2011/11/03 11:55:32 UTC
[jira] [Commented] (JCR-3123) Jackrabbit 1.6 doesn't work with JNDI
datasource against Oracle database
[ https://issues.apache.org/jira/browse/JCR-3123?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13143041#comment-13143041 ]
Ricardo Martínez commented on JCR-3123:
---------------------------------------
Hi all,
For your information, I upgraded to version 2.2.9 of jackrabbit following the steps in this post:
http://www.liferay.com/es/community/forums/-/message_boards/message/7925932 (How to upgrade Jackrabbit), and it works correctly in the repository database through oracle 11g2 Jackrabbit.
> Jackrabbit 1.6 doesn't work with JNDI datasource against Oracle database
> ------------------------------------------------------------------------
>
> Key: JCR-3123
> URL: https://issues.apache.org/jira/browse/JCR-3123
> Project: Jackrabbit Content Repository
> Issue Type: Bug
> Affects Versions: 1.6, 1.6.5
> Environment: Liferay 6.0.6 + Oracle 11g + jboss 5
> Reporter: Ricardo Martínez
> Labels: datasource, jndi, liferay, oracle
>
> This is the error to configure datasource through to JNDI (Oracle)
> -------------------------------------------------------
> 2011-10-13 08:47:54,411 ERROR [org.apache.jackrabbit.core.RepositoryImpl] (main) failed to start Repository: failed to load repository properties: failed to persist repository properties: null
> javax.jcr.RepositoryException: failed to load repository properties: failed to persist repository properties: null: failed to persist repository properties: null: null
> -----------------------------------------
> Repository.xml example:
> <!-- FILESYSTEM -->
> <FileSystem class="org.apache.jackrabbit.core.fs.db.OracleFileSystem">
> <param name="driver" value="javax.naming.InitialContext"/>
> <param name="url" value="java:jdbc/LiferayPool"/>
> <param name="schema" value="oracle"/>
> <param name="schemaObjectPrefix" value="LR_FS_"/>
> <param name="tableSpace" value="default"/>
> </FileSystem>
>
> <!-- SECURITY CONFIGURATION-->
> <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>
>
> <!-- WORKSPACE location of workspaces root directory and name of default workspace -->
> <Workspaces rootPath="${rep.home}/workspaces" defaultWorkspace="liferay" />
> <Workspace name="Liferay">
> <FileSystem class="org.apache.jackrabbit.core.fs.db.OracleFileSystem">
> <param name="driver" value="javax.naming.InitialContext"/>
> <param name="url" value="java:jdbc/LiferayPool"/>
> <param name="schema" value="oracle"/>
> <param name="schemaObjectPrefix" value="LR_WS_FS_" />
> </FileSystem>
> <PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.OraclePersistenceManager">
> <param name="driver" value="javax.naming.InitialContext"/>
> <param name="url" value="java:jdbc/LiferayPool"/>
> <param name="schema" value="oracle" />
> <param name="schemaObjectPrefix" value="LR_WS_PM_" />
> <param name="externalBLOBs" value="false" />
> </PersistenceManager>
> </Workspace>
> <Versioning rootPath="${rep.home}/version">
> <!-- Uncomment to move to DB -->
> <FileSystem class="org.apache.jackrabbit.core.fs.db.OracleFileSystem">
> <param name="driver" value="javax.naming.InitialContext"/>
> <param name="url" value="java:jdbc/LiferayPool"/>
> <param name="schema" value="oracle"/>
> <param name="schemaObjectPrefix" value="LR_V_FS_"/>
> </FileSystem>
>
> <PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.OraclePersistenceManager">
> <param name="driver" value="javax.naming.InitialContext"/>
> <param name="url" value="java:jdbc/LiferayPool"/>
> <param name="schema" value="oracle" />
> <param name="schemaObjectPrefix" value="LR_V_PM_" />
> <param name="externalBLOBs" value="false" />
> </PersistenceManager>
> </Versioning>
>
> <!-- Cluster Configuration -->
> <!-- Uncomment to move to database -->
> <Cluster id="nodo1" syncDelay="2000">
> <Journal class="org.apache.jackrabbit.core.journal.OracleDatabaseJournal">
> <param name="revision" value="${rep.home}/revision.log" />
> <param name="driver" value="javax.naming.InitialContext"/>
> <param name="url" value="java:jdbc/LiferayPool"/>
> <param name="schema" value="oracle"/>
> <param name="schemaObjectPrefix" value="LR_C_" />
> </Journal>
> </Cluster>
> </Repository>
> If i prove with the JNDI parameters:
> <param name="driver" value="javax.naming.InitialContext"/>
> <param name="url" value="java:comp/env/jdbc/LiferayPool"/>
> mark this error:
> "jdbc not bound"
> In contrast if only it's change in FileSystem by jdbc whether it works correctly
> repository.xml (example):
> <Repository>
> <!-- FILESYSTEM -->
> <FileSystem class="org.apache.jackrabbit.core.fs.db.OracleFileSystem">
> <param name="driver" value="oracle.jdbc.driver.OracleDriver"/>
> <param name="url" value="jdbc:oracle:thin:@xxx.xxx.xxx.xxx:1521:name" />
> <param name="user" value="qua" />
> <param name="password" value="qua" />
> <param name="schema" value="oracle"/>
> <param name="schemaObjectPrefix" value="LR_FS_"/>
> </FileSystem>
> ....
> .....
> "next parameters configured (workspace, versioning, cluster,...) through jndi..."
> ......
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira