Hi,

 

I am configuring Oracle Persistence manager for workspace and versioning but it throws the following error:

 

org.drools.repository.RulesRepositoryException: Unable to checkin.
 at org.drools.repository.VersionableItem.checkin(VersionableItem.java:505)
 at org.drools.repository.RulesRepository.createPackage(RulesRepository.java:581)
 at org.drools.brms.server.ServiceImplementation.createPackage(ServiceImplementation.java:490)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at org.jboss.seam.util.Reflections.invoke(Reflections.java:21)
 at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)
 at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
 at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:31)
 at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
 at org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:46)
 at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
 at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:42)
 at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
 at org.jboss.seam.security.SecurityInterceptor.aroundInvoke(SecurityInterceptor.java:40)
 at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
 at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:106)
 at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:155)
 at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:91)
 at org.drools.brms.server.ServiceImplementation_$$_javassist_3.createPackage(ServiceImplementation_$$_javassist_3.java)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)

 

But it works with MySQL database. Following is my configuration for filesystem and persistence.

 

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

                    <param name="url" value="jdbc:oracle:thin:@172.20.14.58:1521:orcl"/>

                        <param name="user" value="wamdev"/>

                        <param name="password" value="miami"/>

                        <param name="schemaObjectPrefix" value="brms_"/>

                        <param name="tableSpace" value="default"/>

            </FileSystem>

 

<PersistenceManager class="org.apache.jackrabbit.core.persistence.db.OraclePersistenceManager">

                        <param name="url" value="jdbc:oracle:thin:@172.20.14.58:1521:orcl"/>

                        <param name="user" value="wamdev"/>

                        <param name="password" value="miami"/>

                        <param name="schemaObjectPrefix" value="brms_"/>

                        <param name="tableSpace" value="default"/>

                        <param name="externalBLOBs" value="false"/>

             </PersistenceManager>

 

 

Can Anyone please guide on this?