jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ricardo Martínez (Commented) (JIRA) <j...@apache.org>
Subject [jira] [Commented] (JCR-3123) Jackrabbit 1.6 doesn't work with JNDI datasource against Oracle database
Date Thu, 03 Nov 2011 10:55:32 GMT

    [ 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

       

Mime
View raw message