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 pa

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

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 empt

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 cann

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 compo

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 Rep

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

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 fr

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 inst

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

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 (ConnectionRecoveryManage

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

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 t

[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