5:57 p.m.
we have some rules developed under the default setup in Drools Guvnor. Those
are stored to the default derby database .
we would like to move repository to Oracle database.
How do we do that?
I have configured the Oracle database settings using th persistence manager
in place of derby.
when I restart the server, how do the rules get moved to the Oracle
Repsoitory?
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/how-to-move-a-reposit...
Sent from the Drools - User mailing list archive at Nabble.com.
11:08 a.m.
Before you switch to Oracle, go to the Administration tab and export
your repository.
Then configure your repository.xml file to point to Oracle, remove the
repository directory (most probably in jboss-as/bin) and start your
server. Then go to the admin tab and import your repo (first you need to
unzip the xml file).
Cheers,
Jarek
vadlam wrote:
we have some rules developed under the default setup in Drools
Guvnor. Those
are stored to the default derby database .
we would like to move repository to Oracle database.
How do we do that?
I have configured the Oracle database settings using th persistence manager
in place of derby.
when I restart the server, how do the rules get moved to the Oracle
Repsoitory?
12:40 p.m.
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.
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/how-to-move-a-reposit...
Sent from the Drools - User mailing list archive at Nabble.com.
1:06 p.m.
after exporting the repository, changing the persistence settings to Oracle,
deleting the respository directory and restarting server again,
I get these errors. Do I need to delete the version directory as well
besides the repository directory ?
ERROR 29-04 10:59:11,004 (ConnectionRecoveryManager.java:logException:447)
could not execute statement, reason: ORA-0140
0: cannot insert NULL into
("DROOLSUSER"."VERSION_NAMES"."ID")
, state/code: 23000/1400
ERROR 29-04 10:59:11,019 (BundleDbPersistenceManager.java:storeBundle:1270)
failed to write bundle: deadbeef-face-babe-ca
fe-babecafebabe
java.lang.IllegalStateException: Unable to insert index:
java.sql.SQLException: ORA-01400: cannot insert NULL into ("DROOLSUSE
R"."VERSION_NAMES"."ID")
at
org.apache.jackrabbit.core.persistence.bundle.util.NGKDbNameIndex.insertString(NGKDbNameIndex.java:71)
at
org.apache.jackrabbit.core.persistence.bundle.util.DbNameIndex.stringToIndex(DbNameIndex.java:101)
at
org.apache.jackrabbit.core.persistence.bundle.util.BundleBinding.writeBundle(BundleBinding.java:249)
at
org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.storeBundle(BundleDbPersistenceManager.jav
a:1262)
at
org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.putBundle(AbstractBundlePersistenceM
anager.java:703)
at
org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.store(AbstractBundlePersistenceManag
er.java:643)
at
org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.store(BundleDbPersistenceManager.java:526)
at
org.apache.jackrabbit.core.version.VersionManagerImpl.<init>(VersionManagerImpl.java:157)
at
org.apache.jackrabbit.core.RepositoryImpl.createVersionManager(RepositoryImpl.java:400)
at
org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:294)
at
org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:557)
at
org.apache.jackrabbit.core.TransientRepository$2.getRepository(TransientRepository.java:245)
at
org.apache.jackrabbit.core.TransientRepository.startRepository(TransientRepository.java:265)
at
org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:333)
at
org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:363)
at
org.drools.guvnor.server.repository.RepositoryStartupService.newSession(RepositoryStartupService.java:135)
at
org.drools.guvnor.server.repository.RepositoryStartupService.create(RepositoryStartupService.java:56)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
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:28)
at
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
at
org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44)
at
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
at
org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
at
org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:166)
at
org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:102)
at
org.drools.guvnor.server.repository.RepositoryStartupService_$$_javassist_0.create(RepositoryStartupService_$$_java
ssist_0.java)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
at
org.jboss.seam.util.Reflections.invokeAndWrap(Reflections.java:138)
at org.jboss.seam.Component.callComponentMethod(Component.java:2171)
at org.jboss.seam.Component.callCreateMethod(Component.java:2094)
at org.jboss.seam.Component.newInstance(Component.java:2054)
at org.jboss.seam.contexts.Contexts.startup(Contexts.java:304)
at org.jboss.seam.contexts.Contexts.startup(Contexts.java:278)
at
org.jboss.seam.contexts.ServletLifecycle.endInitialization(ServletLifecycle.java:112)
at org.jboss.seam.init.Initialization.init(Initialization.java:727)
at
org.jboss.seam.servlet.SeamListener.contextInitialized(SeamListener.java:34)
at
weblogic.servlet.internal.EventsManager$FireContextListenerAction.run(EventsManager.java:376)
at
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at
weblogic.servlet.internal.EventsManager.notifyContextCreatedEvent(EventsManager.java:82)
at
weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1616)
at
weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:2761)
at
weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:889)
at
weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:333)
at
weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:204)
at
weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:26)
at
weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:60)
at
weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:200)
at
weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:117)
at
weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:204)
at
weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:26)
at
weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:60)
at
weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:26)
at
weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:635)
at
weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:26)
at
weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:212)
at
weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:154)
at
weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:80)
at
weblogic.deploy.internal.targetserver.BasicDeployment.activate(BasicDeployment.java:181)
at
weblogic.deploy.internal.targetserver.BasicDeployment.activateFromServerLifecycle(BasicDeployment.java:358)
at
weblogic.management.deploy.internal.DeploymentAdapter$1.doActivate(DeploymentAdapter.java:52)
at
weblogic.management.deploy.internal.DeploymentAdapter.activate(DeploymentAdapter.java:186)
at
weblogic.management.deploy.internal.AppTransition$2.transitionApp(AppTransition.java:30)
at
weblogic.management.deploy.internal.ConfiguredDeployments.transitionApps(ConfiguredDeployments.java:233)
at
weblogic.management.deploy.internal.ConfiguredDeployments.activate(ConfiguredDeployments.java:169)
at
weblogic.management.deploy.internal.ConfiguredDeployments.deploy(ConfiguredDeployments.java:123)
at
weblogic.management.deploy.internal.DeploymentServerService.resume(DeploymentServerService.java:173)
at
weblogic.management.deploy.internal.DeploymentServerService.start(DeploymentServerService.java:89)
at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:181)
ERROR 29-04 10:59:11,175 (BundleDbPersistenceManager.java:logException:1478)
rollback failed
ERROR 29-04 10:59:11,175 (BundleDbPersistenceManager.java:logException:1480)
Reason: Closed Connection
ERROR 29-04 10:59:11,175 (BundleDbPersistenceManager.java:logException:1481)
State/Code: null/17008
ERROR 29-04 10:59:11,691 (ConnectionRecoveryManager.java:logException:447)
could not execute statement, reason: ORA-0140
0: cannot insert NULL into
("DROOLSUSER"."VERSION_NAMES"."ID")
, state/code: 23000/1400
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/how-to-move-a-reposit...
Sent from the Drools - User mailing list archive at Nabble.com.
1:14 p.m.
After the repo export, you need to delete the whole repository directory
which includes:
repository
version
workspaces
and you have to clear the schema in Oracle you want to use - Guvnor will
prepare the DB during deployment when accessing a fresh DB.
When you login, you should be asked to install a sample repo - simply
press "No, thanks" and then import your repo from xml.
vadlam wrote:
after exporting the repository, changing the persistence settings to
Oracle,
deleting the respository directory and restarting server again,
I get these errors. Do I need to delete the version directory as well
besides the repository directory ?
ERROR 29-04 10:59:11,004 (ConnectionRecoveryManager.java:logException:447)
could not execute statement, reason: ORA-0140
0: cannot insert NULL into
("DROOLSUSER"."VERSION_NAMES"."ID")
, state/code: 23000/1400
ERROR 29-04 10:59:11,019 (BundleDbPersistenceManager.java:storeBundle:1270)
failed to write bundle: deadbeef-face-babe-ca
fe-babecafebabe
java.lang.IllegalStateException: Unable to insert index:
java.sql.SQLException: ORA-01400: cannot insert NULL into ("DROOLSUSE
R"."VERSION_NAMES"."ID")
at
org.apache.jackrabbit.core.persistence.bundle.util.NGKDbNameIndex.insertString(NGKDbNameIndex.java:71)
at
org.apache.jackrabbit.core.persistence.bundle.util.DbNameIndex.stringToIndex(DbNameIndex.java:101)
at
org.apache.jackrabbit.core.persistence.bundle.util.BundleBinding.writeBundle(BundleBinding.java:249)
at
org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.storeBundle(BundleDbPersistenceManager.jav
a:1262)
at
org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.putBundle(AbstractBundlePersistenceM
anager.java:703)
at
org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.store(AbstractBundlePersistenceManag
er.java:643)
at
org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.store(BundleDbPersistenceManager.java:526)
at
org.apache.jackrabbit.core.version.VersionManagerImpl.<init>(VersionManagerImpl.java:157)
at
org.apache.jackrabbit.core.RepositoryImpl.createVersionManager(RepositoryImpl.java:400)
at
org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:294)
at
org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:557)
at
org.apache.jackrabbit.core.TransientRepository$2.getRepository(TransientRepository.java:245)
at
org.apache.jackrabbit.core.TransientRepository.startRepository(TransientRepository.java:265)
at
org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:333)
at
org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:363)
at
org.drools.guvnor.server.repository.RepositoryStartupService.newSession(RepositoryStartupService.java:135)
at
org.drools.guvnor.server.repository.RepositoryStartupService.create(RepositoryStartupService.java:56)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
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:28)
at
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
at
org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44)
at
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
at
org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
at
org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:166)
at
org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:102)
at
org.drools.guvnor.server.repository.RepositoryStartupService_$$_javassist_0.create(RepositoryStartupService_$$_java
ssist_0.java)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
at
org.jboss.seam.util.Reflections.invokeAndWrap(Reflections.java:138)
at org.jboss.seam.Component.callComponentMethod(Component.java:2171)
at org.jboss.seam.Component.callCreateMethod(Component.java:2094)
at org.jboss.seam.Component.newInstance(Component.java:2054)
at org.jboss.seam.contexts.Contexts.startup(Contexts.java:304)
at org.jboss.seam.contexts.Contexts.startup(Contexts.java:278)
at
org.jboss.seam.contexts.ServletLifecycle.endInitialization(ServletLifecycle.java:112)
at org.jboss.seam.init.Initialization.init(Initialization.java:727)
at
org.jboss.seam.servlet.SeamListener.contextInitialized(SeamListener.java:34)
at
weblogic.servlet.internal.EventsManager$FireContextListenerAction.run(EventsManager.java:376)
at
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at
weblogic.servlet.internal.EventsManager.notifyContextCreatedEvent(EventsManager.java:82)
at
weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1616)
at
weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:2761)
at
weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:889)
at
weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:333)
at
weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:204)
at
weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:26)
at
weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:60)
at
weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:200)
at
weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:117)
at
weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:204)
at
weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:26)
at
weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:60)
at
weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:26)
at
weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:635)
at
weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:26)
at
weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:212)
at
weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:154)
at
weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:80)
at
weblogic.deploy.internal.targetserver.BasicDeployment.activate(BasicDeployment.java:181)
at
weblogic.deploy.internal.targetserver.BasicDeployment.activateFromServerLifecycle(BasicDeployment.java:358)
at
weblogic.management.deploy.internal.DeploymentAdapter$1.doActivate(DeploymentAdapter.java:52)
at
weblogic.management.deploy.internal.DeploymentAdapter.activate(DeploymentAdapter.java:186)
at
weblogic.management.deploy.internal.AppTransition$2.transitionApp(AppTransition.java:30)
at
weblogic.management.deploy.internal.ConfiguredDeployments.transitionApps(ConfiguredDeployments.java:233)
at
weblogic.management.deploy.internal.ConfiguredDeployments.activate(ConfiguredDeployments.java:169)
at
weblogic.management.deploy.internal.ConfiguredDeployments.deploy(ConfiguredDeployments.java:123)
at
weblogic.management.deploy.internal.DeploymentServerService.resume(DeploymentServerService.java:173)
at
weblogic.management.deploy.internal.DeploymentServerService.start(DeploymentServerService.java:89)
at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:181)
ERROR 29-04 10:59:11,175 (BundleDbPersistenceManager.java:logException:1478)
rollback failed
ERROR 29-04 10:59:11,175 (BundleDbPersistenceManager.java:logException:1480)
Reason: Closed Connection
ERROR 29-04 10:59:11,175 (BundleDbPersistenceManager.java:logException:1481)
State/Code: null/17008
ERROR 29-04 10:59:11,691 (ConnectionRecoveryManager.java:logException:447)
could not execute statement, reason: ORA-0140
0: cannot insert NULL into
("DROOLSUSER"."VERSION_NAMES"."ID")
, state/code: 23000/1400
1:47 p.m.
after I delete repository,,version ,workspaces directories and delete all
tables in the database and startweblogic again, I get the following error.
<Apr 29, 2010 11:35:10 AM MST> <Warning> <HTTP> <BEA-101162>
<User defined
listener org.jboss.seam.servlet.SeamListener failed
: org.jboss.seam.InstantiationException: Could not instantiate Seam
component: repositoryConfiguration.
org.jboss.seam.InstantiationException: Could not instantiate Seam component:
repositoryConfiguration
at org.jboss.seam.Component.newInstance(Component.java:2066)
at org.jboss.seam.contexts.Contexts.startup(Contexts.java:304)
at org.jboss.seam.contexts.Contexts.startup(Contexts.java:278)
at
org.jboss.seam.contexts.ServletLifecycle.endInitialization(ServletLifecycle.java:112)
at org.jboss.seam.init.Initialization.init(Initialization.java:727)
Truncated. see log file for complete stacktrace
java.lang.ClassCastException:
org.apache.xalan.processor.TransformerFactoryImpl
at javax.xml.transform.TransformerFactory.newInstance(Unknown
Source)
at
org.apache.jackrabbit.core.config.RepositoryConfig.internalCreateWorkspaceConfig(RepositoryConfig.java:530)
at
org.apache.jackrabbit.core.config.RepositoryConfig.createWorkspaceConfig(RepositoryConfig.java:591)
at
org.apache.jackrabbit.core.config.RepositoryConfig.init(RepositoryConfig.java:335)
at
org.apache.jackrabbit.core.config.RepositoryConfig.create(RepositoryConfig.java:142)
Truncated. see log file for complete stacktrace
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/how-to-move-a-reposit...
Sent from the Drools - User mailing list archive at Nabble.com.
1:27 a.m.
This doesn't tell me much. Maybe there's more in the log?
-> "Truncated. see log file for complete stacktrace"
This might help as well.
http://www.ibm.com/developerworks/forums/thread.jspa?threadID=103468
One more thought - you have provided the Oracle driver to your app
server, right?
vadlam wrote:
after I delete repository,,version ,workspaces directories and delete
all
tables in the database and startweblogic again, I get the following error.
<Apr 29, 2010 11:35:10 AM MST> <Warning> <HTTP> <BEA-101162>
<User defined
listener org.jboss.seam.servlet.SeamListener failed
: org.jboss.seam.InstantiationException: Could not instantiate Seam
component: repositoryConfiguration.
org.jboss.seam.InstantiationException: Could not instantiate Seam component:
repositoryConfiguration
at org.jboss.seam.Component.newInstance(Component.java:2066)
at org.jboss.seam.contexts.Contexts.startup(Contexts.java:304)
at org.jboss.seam.contexts.Contexts.startup(Contexts.java:278)
at
org.jboss.seam.contexts.ServletLifecycle.endInitialization(ServletLifecycle.java:112)
at org.jboss.seam.init.Initialization.init(Initialization.java:727)
Truncated. see log file for complete stacktrace
java.lang.ClassCastException:
org.apache.xalan.processor.TransformerFactoryImpl
at javax.xml.transform.TransformerFactory.newInstance(Unknown
Source)
at
org.apache.jackrabbit.core.config.RepositoryConfig.internalCreateWorkspaceConfig(RepositoryConfig.java:530)
at
org.apache.jackrabbit.core.config.RepositoryConfig.createWorkspaceConfig(RepositoryConfig.java:591)
at
org.apache.jackrabbit.core.config.RepositoryConfig.init(RepositoryConfig.java:335)
at
org.apache.jackrabbit.core.config.RepositoryConfig.create(RepositoryConfig.java:142)
Truncated. see log file for complete stacktrace
11:56 a.m.
Yes, The same driver information works when the repository directories exist.
My suspicion is that this error happens when the repository directory
specified in repositoryx.ml does not exist during system startup.
I get the same error whether it is default derby settings or Oracle settings
if Repository ,version,workspace directories do not exist. The error stack
trace below is when I use the derby settings.The error message is same as
when I use Oracle settings.
<Apr 30, 2010 9:42:10 AM MST> <Warning> <HTTP> <BEA-101162>
<User defined
listener org.jboss.seam.servlet.SeamListener failed:
org.jboss.seam.InstantiationException: Could not instantiate Seam
component: repositoryConfiguration.
org.jboss.seam.InstantiationException: Could not instantiate Seam component:
repositoryConfiguration
at org.jboss.seam.Component.newInstance(Component.java:2066)
at org.jboss.seam.contexts.Contexts.startup(Contexts.java:304)
at org.jboss.seam.contexts.Contexts.startup(Contexts.java:278)
at
org.jboss.seam.contexts.ServletLifecycle.endInitialization(ServletLifecycle.java:112)
at org.jboss.seam.init.Initialization.init(Initialization.java:727)
Truncated. see log file for complete stacktrace
java.lang.ClassCastException:
org.apache.xalan.processor.TransformerFactoryImpl
at javax.xml.transform.TransformerFactory.newInstance(Unknown
Source)
at
org.apache.jackrabbit.core.config.RepositoryConfig.internalCreateWorkspaceConfig(RepositoryConfig.java:530)
at
org.apache.jackrabbit.core.config.RepositoryConfig.createWorkspaceConfig(RepositoryConfig.java:591)
at
org.apache.jackrabbit.core.config.RepositoryConfig.init(RepositoryConfig.java:335)
at
org.apache.jackrabbit.core.config.RepositoryConfig.create(RepositoryConfig.java:142)
Truncated. see log file for complete stacktrace
<Apr 30, 2010 9:42:10 AM MST> <Error>
<Deployer> <BEA-149231> <Unable to set
the activation state to true for the application
'drools-guvnor'.
weblogic.application.ModuleException:
at
weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:891)
at
weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:333)
at
weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:204)
at
weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:26)
at
weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:60)
Truncated. see log file for complete stacktrace
java.lang.ClassCastException:
org.apache.xalan.processor.TransformerFactoryImpl
at javax.xml.transform.TransformerFactory.newInstance(Unknown
Source)
at
org.apache.jackrabbit.core.config.RepositoryConfig.internalCreateWorkspaceConfig(RepositoryConfig.java:530)
at
org.apache.jackrabbit.core.config.RepositoryConfig.createWorkspaceConfig(RepositoryConfig.java:591)
at
org.apache.jackrabbit.core.config.RepositoryConfig.init(RepositoryConfig.java:335)
at
org.apache.jackrabbit.core.config.RepositoryConfig.create(RepositoryConfig.java:142)
Truncated. see log file for complete stacktrace
This is what is logged in derby.log file when this error happens.
----------------------------------------------------------------
2010-04-29 17:35:50.808 GMT:
Booting Derby version The Apache Software Foundation - Apache Derby -
10.2.1.6 - (452058): instance c013800d-0128-4aa3-875c-00000c9dabf8
on database directory
C:\bea923HULA\user_projects\domains\hulaCdm_R110\config\drools\version\db
Database Class Loader started - derby.database.classpath=''
----------------------------------------------------------------
2010-04-29 17:35:53.995 GMT:
Booting Derby version The Apache Software Foundation - Apache Derby -
10.2.1.6 - (452058): instance e03f4017-0128-4aa3-875c-00000c9dabf8
on database directory
C:\bea923HULA\user_projects\domains\hulaCdm_R110\config\drools\workspaces\default\db
Database Class Loader started - derby.database.classpath=''
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/how-to-move-a-reposit...
Sent from the Drools - User mailing list archive at Nabble.com.
1:29 a.m.
Oh, ok, so you've provided a homeDirectory property in components.xml
Then, as you already mentioned, create this directory and put the
repository.xml file there.
To sum it up:
1. export your repo, stop the app server
2. delete everything inside the directory specified as homeDirectory in
components.xml, but keep that directory itself - you need to do this to
clean up after Derby
3. put the new repository.xml file into the homeDirectory and make sure
you're starting with a clean Oracle DB
4. start your server - you should be asked to install a sample
repository once logged in to Guvnor - ignore that and import your repo
from the Administration menu
Does this work?
vadlam wrote:
Yes, The same driver information works when the repository
directories exist.
My suspicion is that this error happens when the repository directory
specified in repositoryx.ml does not exist during system startup.
I get the same error whether it is default derby settings or Oracle settings
if Repository ,version,workspace directories do not exist. The error stack
trace below is when I use the derby settings.The error message is same as
when I use Oracle settings.
<Apr 30, 2010 9:42:10 AM MST> <Warning> <HTTP> <BEA-101162>
<User defined
listener org.jboss.seam.servlet.SeamListener failed:
org.jboss.seam.InstantiationException: Could not instantiate Seam
component: repositoryConfiguration.
org.jboss.seam.InstantiationException: Could not instantiate Seam component:
repositoryConfiguration
at org.jboss.seam.Component.newInstance(Component.java:2066)
at org.jboss.seam.contexts.Contexts.startup(Contexts.java:304)
at org.jboss.seam.contexts.Contexts.startup(Contexts.java:278)
at
org.jboss.seam.contexts.ServletLifecycle.endInitialization(ServletLifecycle.java:112)
at org.jboss.seam.init.Initialization.init(Initialization.java:727)
Truncated. see log file for complete stacktrace
java.lang.ClassCastException:
org.apache.xalan.processor.TransformerFactoryImpl
at javax.xml.transform.TransformerFactory.newInstance(Unknown
Source)
at
org.apache.jackrabbit.core.config.RepositoryConfig.internalCreateWorkspaceConfig(RepositoryConfig.java:530)
at
org.apache.jackrabbit.core.config.RepositoryConfig.createWorkspaceConfig(RepositoryConfig.java:591)
at
org.apache.jackrabbit.core.config.RepositoryConfig.init(RepositoryConfig.java:335)
at
org.apache.jackrabbit.core.config.RepositoryConfig.create(RepositoryConfig.java:142)
Truncated. see log file for complete stacktrace
<Apr 30, 2010 9:42:10 AM MST> <Error> <Deployer> <BEA-149231>
<Unable to set
the activation state to true for the application
'drools-guvnor'.
weblogic.application.ModuleException:
at
weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:891)
at
weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:333)
at
weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:204)
at
weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:26)
at
weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:60)
Truncated. see log file for complete stacktrace
java.lang.ClassCastException:
org.apache.xalan.processor.TransformerFactoryImpl
at javax.xml.transform.TransformerFactory.newInstance(Unknown
Source)
at
org.apache.jackrabbit.core.config.RepositoryConfig.internalCreateWorkspaceConfig(RepositoryConfig.java:530)
at
org.apache.jackrabbit.core.config.RepositoryConfig.createWorkspaceConfig(RepositoryConfig.java:591)
at
org.apache.jackrabbit.core.config.RepositoryConfig.init(RepositoryConfig.java:335)
at
org.apache.jackrabbit.core.config.RepositoryConfig.create(RepositoryConfig.java:142)
Truncated. see log file for complete stacktrace
This is what is logged in derby.log file when this error happens.
----------------------------------------------------------------
2010-04-29 17:35:50.808 GMT:
Booting Derby version The Apache Software Foundation - Apache Derby -
10.2.1.6 - (452058): instance c013800d-0128-4aa3-875c-00000c9dabf8
on database directory
C:\bea923HULA\user_projects\domains\hulaCdm_R110\config\drools\version\db
Database Class Loader started - derby.database.classpath=''
----------------------------------------------------------------
2010-04-29 17:35:53.995 GMT:
Booting Derby version The Apache Software Foundation - Apache Derby -
10.2.1.6 - (452058): instance e03f4017-0128-4aa3-875c-00000c9dabf8
on database directory
C:\bea923HULA\user_projects\domains\hulaCdm_R110\config\drools\workspaces\default\db
Database Class Loader started - derby.database.classpath=''
3:19 p.m.
The directory specified in components.xml as home directory is
/config/drools.
I have the repository.xml in this directory.
After I delete all the directories under drools and just have repository.xml
in config/drools and restart, I get this error. so, I guess the problem is
that jackrabbit cannot find the repository directory specified in
repository.xml and hence causing this error.
The same error happens irrespective of whether I have Oracle persistence or
default derby persistence setttings.
here is the Repository.xml I use. In components.xml, I have config/drools
defined as the home directory
<?xml version="1.0"?>
<!--
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements. See the NOTICE file distributed with
this work for additional information regarding copyright ownership.
The ASF licenses this file to You under the Apache License, Version 2.0
(the "License"); you may not use this file except in compliance with
the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
-->
<!DOCTYPE Repository PUBLIC "-//The Apache Software Foundation//DTD
Jackrabbit 1.4//EN"
"http://jackrabbit.apache.org/dtd/repository-1.4.dtd">
<!-- Example Repository Configuration File -->
<Repository>
<!--
virtual file system where the repository stores global state
(e.g. registered namespaces, custom node types, etc.)
-->
<FileSystem
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<!--param name="path"
value="C:/Data/jboss/repository"/-->
</FileSystem>
<!--
security configuration
-->
<Security appName="Jackrabbit">
<!--
access manager:
class: FQN of class implementing the AccessManager interface
-->
<AccessManager
class="org.apache.jackrabbit.core.security.SimpleAccessManager">
<!-- -->
</AccessManager>
<LoginModule
class="org.apache.jackrabbit.core.security.SimpleLoginModule">
<!-- anonymous user name ('anonymous' is the default value) -->
<!-- -->
<!--
default user name to be used instead of the anonymous user
when no login credentials are provided (unset by default)
-->
<!-- -->
</LoginModule>
</Security>
<!--
location of workspaces root directory and name of default workspace
-->
<Workspaces rootPath="${rep.home}/workspaces"
defaultWorkspace="default"/>
<!--
workspace configuration template:
used to create the initial workspace if there's no workspace yet
-->
<Workspace name="${wsp.name}">
<!--
virtual file system of the workspace:
class: FQN of class implementing the FileSystem interface
-->
<FileSystem
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
</FileSystem>
<!--
persistence manager of the workspace:
class: FQN of class implementing the PersistenceManager
interface
-->
<!--
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.DerbyPersistenceManager">
</PersistenceManager>
-->
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.OraclePersistenceManager">
</PersistenceManager>
<!--
Search index and the file system it uses.
class: FQN of class implementing the QueryHandler interface
-->
<SearchIndex
class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
</SearchIndex>
</Workspace>
<!--
Configures the versioning
-->
<Versioning rootPath="${rep.home}/version">
<!--
Configures the filesystem to use for versioning for the
respective
persistence manager
-->
<FileSystem
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
</FileSystem>
<!--
Configures the persistence manager to be used for persisting
version state.
Please note that the current versioning implementation is based
on
a 'normal' persistence manager, but this could change in future
implementations.
-->
<!--
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.DerbyPersistenceManager">
</PersistenceManager>
-->
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.OraclePersistenceManager">
</PersistenceManager>
</Versioning>
<!--
Search index for content that is shared repository wide
(/jcr:system tree, contains mainly versions)
-->
<SearchIndex
class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
</SearchIndex>
</Repository>
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/how-to-move-a-reposit...
Sent from the Drools - User mailing list archive at Nabble.com.
12:55 a.m.
Looks like you're missing a couple of things in he repository.xml file.
In all FileSystem sections, leave the default 'path' parameter, taken
from the original repository.xml
Jackrabbit will replace rep.home with /config/drools - no need to carry
for this.
Your SearchIndex at the bottom is empty - it has no parameters - is
there a reason why you have removed them?
Same goes for all your PersistenceManagers - there are no parameters,
you need to provide driver, url, schema (set to "oracle"), user,
password and schemaObjectPrefix (default value taken from the original
repository.xml file is fine).
vadlam wrote:
The directory specified in components.xml as home directory is
/config/drools.
I have the repository.xml in this directory.
After I delete all the directories under drools and just have repository.xml
in config/drools and restart, I get this error. so, I guess the problem is
that jackrabbit cannot find the repository directory specified in
repository.xml and hence causing this error.
The same error happens irrespective of whether I have Oracle persistence or
default derby persistence setttings.
here is the Repository.xml I use. In components.xml, I have config/drools
defined as the home directory
<?xml version="1.0"?>
<!--
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements. See the NOTICE file distributed with
this work for additional information regarding copyright ownership.
The ASF licenses this file to You under the Apache License, Version 2.0
(the "License"); you may not use this file except in compliance with
the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
-->
<!DOCTYPE Repository PUBLIC "-//The Apache Software Foundation//DTD
Jackrabbit 1.4//EN"
"http://jackrabbit.apache.org/dtd/repository-1.4.dtd">
<!-- Example Repository Configuration File -->
<Repository>
<!--
virtual file system where the repository stores global state
(e.g. registered namespaces, custom node types, etc.)
-->
<FileSystem
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<!--param name="path"
value="C:/Data/jboss/repository"/-->
</FileSystem>
<!--
security configuration
-->
<Security appName="Jackrabbit">
<!--
access manager:
class: FQN of class implementing the AccessManager interface
-->
<AccessManager
class="org.apache.jackrabbit.core.security.SimpleAccessManager">
<!-- -->
</AccessManager>
<LoginModule
class="org.apache.jackrabbit.core.security.SimpleLoginModule">
<!-- anonymous user name ('anonymous' is the default value) -->
<!-- -->
<!--
default user name to be used instead of the anonymous user
when no login credentials are provided (unset by default)
-->
<!-- -->
</LoginModule>
</Security>
<!--
location of workspaces root directory and name of default workspace
-->
<Workspaces rootPath="${rep.home}/workspaces"
defaultWorkspace="default"/>
<!--
workspace configuration template:
used to create the initial workspace if there's no workspace yet
-->
<Workspace name="${wsp.name}">
<!--
virtual file system of the workspace:
class: FQN of class implementing the FileSystem interface
-->
<FileSystem
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
</FileSystem>
<!--
persistence manager of the workspace:
class: FQN of class implementing the PersistenceManager
interface
-->
<!--
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.DerbyPersistenceManager">
</PersistenceManager>
-->
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.OraclePersistenceManager">
</PersistenceManager>
<!--
Search index and the file system it uses.
class: FQN of class implementing the QueryHandler interface
-->
<SearchIndex
class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
</SearchIndex>
</Workspace>
<!--
Configures the versioning
-->
<Versioning rootPath="${rep.home}/version">
<!--
Configures the filesystem to use for versioning for the
respective
persistence manager
-->
<FileSystem
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
</FileSystem>
<!--
Configures the persistence manager to be used for persisting
version state.
Please note that the current versioning implementation is based
on
a 'normal' persistence manager, but this could change in future
implementations.
-->
<!--
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.DerbyPersistenceManager">
</PersistenceManager>
-->
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.OraclePersistenceManager">
</PersistenceManager>
</Versioning>
<!--
Search index for content that is shared repository wide
(/jcr:system tree, contains mainly versions)
-->
<SearchIndex
class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
</SearchIndex>
</Repository>
10:44 a.m.
for some reason, the xml info within the OraclePersistenceManager tag came
out as blank in the post.
I am attaching the file this time.
Also, I changed the path to point to rep.home variable as you suggested. I
still get the same error. http://n3.nabble.com/file/n773632/repository.xml
repository.xml
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/how-to-move-a-reposit...
Sent from the Drools - User mailing list archive at Nabble.com.
1:35 a.m.
The first FileSystem path param should be the same as in the default
repository.xml file. This is
<param name="path" value="${rep.home}/repository"/>
and not
<param name="path" value="${rep.home}"/>
vadlam wrote:
for some reason, the xml info within the OraclePersistenceManager tag
came
out as blank in the post.
I am attaching the file this time.
Also, I changed the path to point to rep.home variable as you suggested. I
still get the same error. http://n3.nabble.com/file/n773632/repository.xml
repository.xml
1:08 p.m.
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.
5349
days inactive
5357
days old
13 comments
2 participants
participants (2)
-
Jaroslaw Kijanowski -
vadlam