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

2010-05-03 Thread Jaroslaw Kijanowski 
The first FileSystem path param should be the same as in the default 
repository.xml file. This is



and not



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 
___
rules-users mailing list
rules-users@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users

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

2010-05-03 Thread vadlam 

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-repository-from-derby-database-to-Oracle-Database-tp758128p773632.html
Sent from the Drools - User mailing list archive at Nabble.com.
___
rules-users mailing list
rules-users@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users

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

2010-05-01 Thread Jaroslaw Kijanowski 
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
> 
> 
> 
>  Jackrabbit 1.4//EN"
>
> "http://jackrabbit.apache.org/dtd/repository-1.4.dtd";>
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>  class="org.apache.jackrabbit.core.security.SimpleAccessManager">
> 
> 
> 
>  class="org.apache.jackrabbit.core.security.SimpleLoginModule">
>
>
>
>
> 
> 
> 
> 
>  defaultWorkspace="default"/>
> 
> 
> 
>  class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
> 
> 
> 
> 
>   
> class="org.apache.jackrabbit.core.persistence.bundle.OraclePersistenceManager">
>  
>  
> 
>  
>  
>  
> 
>  
>   
> 
>   
> 
>  class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>  class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
> 
> 
>   
> 
> 
>   
>   
>  class="org.apache.jackrabbit.core.persistence.bundle.OraclePersistenceManager">
>  
>  
> 
>  
>  
>  
> 
>  
>   
>
>  
> 
>
>   
> 
> 
> 
>  class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
> 
> 
> 
> 
> 
> 
> 
___
rules-users mailing list
rules-users@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users

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

2010-05-01 Thread vadlam 

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



http://jackrabbit.apache.org/dtd/repository-1.4.dtd";>
















   
   
   
   












  

   
 
 

 
 
 

 
  























 
 

 
 
 

 
  
 
 

 












-- 
View this message in context: 
http://drools-java-rules-engine.46999.n3.nabble.com/how-to-move-a-repository-from-derby-database-to-Oracle-Database-tp758128p770559.html
Sent from the Drools - User mailing list archive at Nabble.com.
___
rules-users mailing list
rules-users@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users

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

2010-04-30 Thread 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.
> 
>  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
>  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-0c9dabf8
> 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-0c9dabf8
> on database directory
> C:\bea923HULA\user_projects\domains\hulaCdm_R110\config\drools\workspaces\default\db
>   
> 
> Database Class Loader started - derby.database.classpath=''
> 
> 
___
rules-users mailing list
rules-users@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users

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

2010-04-30 Thread vadlam 

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.




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-0c9dabf8
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-0c9dabf8
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-repository-from-derby-database-to-Oracle-Database-tp758128p768408.html
Sent from the Drools - User mailing list archive at Nabble.com.
___
rules-users mailing list
rules-users@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users

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

2010-04-29 Thread Jaroslaw Kijanowski 
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.
> 
>  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
___
rules-users mailing list
rules-users@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users

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

2010-04-29 Thread vadlam 

after I delete repository,,version ,workspaces directories and delete all
tables in the database and startweblogic again, I get the following error.

http://drools-java-rules-engine.46999.n3.nabble.com/how-to-move-a-repository-from-derby-database-to-Oracle-Database-tp758128p766133.html
Sent from the Drools - User mailing list archive at Nabble.com.
___
rules-users mailing list
rules-users@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users

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

2010-04-29 Thread Jaroslaw Kijanowski 
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.(VersionManagerImpl.java:157)
> at
> org.apache.jackrabbit.core.RepositoryImpl.createVersionManager(RepositoryImpl.java:400)
> at
> org.apache.jackrabbit.core.RepositoryImpl.(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:2

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

2010-04-29 Thread 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.
> 
>   class="org.apache.jackrabbit.core.persistence.bundle.DerbyPersistenceManager">
>   
>   
> 
>   
>   
> to be replaced with 
>   
> class="org.apache.jackrabbit.core.persistence.bundle.OraclePersistenceManager">
>  
>  
> 
>  
>  
>  
> 
>  
>   
> 
>   -->
> 
>  class="org.apache.jackrabbit.core.persistence.bundle.DerbyPersistenceManager">
>   
>   
> 
>
> to be replaced with   
>

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

2010-04-29 Thread vadlam 

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.(VersionManagerImpl.java:157)
at
org.apache.jackrabbit.core.RepositoryImpl.createVersionManager(RepositoryImpl.java:400)
at
org.apache.jackrabbit.core.RepositoryImpl.(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.Initializa

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

2010-04-29 Thread vadlam 

In the repository.xml, there are 2 sections where the default database derby
can be replaced with Oracle.

 
  
  



to be replaced with 

   
 
 

 
 
 

 
  

-->


  
  

 
to be replaced with

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

2010-04-29 Thread Jaroslaw Kijanowski 
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? 
___
rules-users mailing list
rules-users@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users

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

2010-04-26 Thread vadlam 

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-repository-from-derby-database-to-Oracle-Database-tp758128p758128.html
Sent from the Drools - User mailing list archive at Nabble.com.
___
rules-users mailing list
rules-users@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users