[rules-users] Guvnor repository database use to store assets

[Nicolas Héron]

Ram,
Yes they have to be deleted so that at startup Guvnor can created them.
At startup, Jackrabbit (containent in Guvnor) reads all the database and
creates the two directories. You do not need to backup them.
Nicolas

2011/9/4 puja nandamuri <med_9501 at yahoo.com>

> 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 <nicolas.heron.java at gmail.com>* wrote:
>
>
> From: Nicolas Héron <nicolas.heron.java at gmail.com>
> Subject: Re: [rules-users] Guvnor repository database use to store assets
> To: "Rules Users List" <rules-users at lists.jboss.org>
> 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 <med_9501 at yahoo.com<http://mc/compose?to=med_9501@yahoo.com>
> >
>
> 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
> rules-users at lists.jboss.org<http://mc/compose?to=rules-users@lists.jboss.org>
> https://lists.jboss.org/mailman/listinfo/rules-users
>
>
>
> -----Inline Attachment Follows-----
>
>
> _______________________________________________
> rules-users mailing list
> rules-users at lists.jboss.org<http://mc/compose?to=rules-users@lists.jboss.org>
> https://lists.jboss.org/mailman/listinfo/rules-users
>
>
> _______________________________________________
> rules-users mailing list
> rules-users at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20110904/767894ed/attachment.html