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

[Jaroslaw Kijanowski]

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=''
> 
>