[rules-users] how to move a repository from derby database to Oracle Database

[Jaroslaw Kijanowski]

What you have provided is just the driver class, but yeah, this is the 
right one.
Moreover I would also consider to change the FileSystem to use 
"org.apache.jackrabbit.core.fs.db.OracleFileSystem" instead of the local 
file system.
But this is strictly Jackrabbit related stuff and you would need to have 
a look at their docs for further details.

vadlam wrote:
> In the repository.xml, there are 2 sections where the default database derby
> can be replaced with Oracle.
> 
>  <PersistenceManager
> class="org.apache.jackrabbit.core.persistence.bundle.DerbyPersistenceManager">
>           
>           
>         </PersistenceManager>
> 		
> 		
> to be replaced with 
> 	
>        <PersistenceManager
> class="org.apache.jackrabbit.core.persistence.bundle.OraclePersistenceManager">
>          
>      
>     
>      
>      
>      
>     
>      
>       
>         </PersistenceManager>
> 	-->
> 
> <PersistenceManager
> class="org.apache.jackrabbit.core.persistence.bundle.DerbyPersistenceManager">
>           
>           
>         </PersistenceManager>
> 		 
> to be replaced with 		
> 	<!-- 	 
>         <PersistenceManager
> class="org.apache.jackrabbit.core.persistence.bundle.OraclePersistenceManager">
>          
>      
>     
>      
>      
>      
>     
>      
>       
> 	 
>      
>         </PersistenceManager>	
> 
> Does this look right? Basicallly, using the same Oracle database, but
> different tables for storing rules and versions.