On 9/4/11 4:45 PM, Nicolas Héron wrote:
Ram,
Yes they have to be deleted so that at startup Guvnor can created them.
Sorry, but you do not have to delete the workspace directory. Not sure
where you are getting this from? In cases where you have a large number
of packages/assets in Guvnor it is rather recommended _not_ to delete
the search indexes written onto the file system, because it takes extra
time to re-create them.
At startup, Jackrabbit (containent in Guvnor) reads all the database
and creates the two directories. You do not need to backup them.
Again, I don't know where you are getting this from. Jackrabbit does
_not_ read the entire DB on startup and does not write any of the JCR
content stored in an RDBMS to the file system if you have configured it
to store to the RDBMS. If you for any weird reason are seeing this on
your end, you should really have another look at your repository.xml.
Thanks.
Nicolas
2011/9/4 puja nandamuri <[email protected] <mailto:[email protected]>>
Nicolas,
In our case, we are not moving from one database to another. we
are using the same database. we just deployed a recompiled Guvnor
war file without any changes. we had to redeploy as part of our
deployment process.
In this case, my assumption was that Guvnor will load the existing
assets from database which has not changed. Only Guvnor has been
redeployed and the workspace and repository directories deleted to
be created afresh by Guvnor.
--- On *Sun, 9/4/11, Nicolas Héron /<[email protected]
<mailto:[email protected]>>/* wrote:
From: Nicolas Héron <[email protected]
<mailto:[email protected]>>
Subject: Re: [rules-users] Guvnor repository database use to
store assets
To: "Rules Users List" <[email protected]
<mailto:[email protected]>>
Date: Sunday, September 4, 2011, 11:15 AM
Hi,
Guvnor stores everything in the database.
The directories workspace and repository are for the lucene
indexes used by jackrabbit.
The best thing when you move guvnor from one database to
another is to use the export/import function that will work
even if you export from one type of database to another type
of database. It is how I do in my projects.
After importing, il may be necessary to delete those two
directories as sometimes jackrabbit (which is behind guvnor to
store the assets) does not update the index correctly. Yes it
is normal and a good practice when you install guvnor to a new
server.
Now if you are using jboss 5 or 6, modeshape may be a good
candidate also in replacement of Jackrabbit. But I have never
used Modeshape (my customer are using jboss 4 or apache
tomcat, etc..)
Now are you using the community version ? The question you ask
is typically one that you would ask to a professional support.
Regards
Nicolas Heron
2011/9/4 puja nandamuri <[email protected]
<http://mc/[email protected]>>
Hi All,
we are currently using SQLServer as the database
repository for Guvnor 5.2.0.CR1
Can somone throw some light on how the database is used by
Guvnor in the following scenario?
the first time we deploy Guvnor,we create an empty
database and let Guvnor create the necessary Table and
other structures necessary for it to save and load assets .
assuming that Guvnor creates the required structures such
as Tables etc during the first deploy and may not need to
create any further tables , we lock down the database from
creating any further tables. Guvnor works fine for all
subsequent rules creation and save.
we had to redeploy Guvnor a second time without changing
anything with respect to the database.we however, had to
delete the existing workspace and repository directories
created on local file system to let Guvnor create them afresh.
the expectation is that Guvnor will read the assets from
the existing database and create new repository and
workspace directories on file system .
Guvnor threw errors saying
Caused By: java.sql.SQLException: [OWLS][SQLServer JDBC
Driver][SQLServer]CREATE TABLE permission denied in
database 'GuvnorRules'.
does Guvnor create new Tables everytime we deploy a fresh
instance of Guvnor to weblogic ?
or is it the way that I have generated my repository.xml
that is causing Guvnor to create new tables to save non
asset related data such as indexing etc?
I have attached a sample of my repository.xml for reference.
I appreciate your thoughts and feedback.
Thanks,
Ram
_______________________________________________
rules-users mailing list
[email protected]
<http://mc/[email protected]>
https://lists.jboss.org/mailman/listinfo/rules-users
-----Inline Attachment Follows-----
_______________________________________________
rules-users mailing list
[email protected]
<http://mc/[email protected]>
https://lists.jboss.org/mailman/listinfo/rules-users
_______________________________________________
rules-users mailing list
[email protected] <mailto:[email protected]>
https://lists.jboss.org/mailman/listinfo/rules-users
_______________________________________________
rules-users mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/rules-users
_______________________________________________
rules-users mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/rules-users
