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

[Michael Anstis]

AFAIK, JCR (JackRabbit or ModeShape) should not create any more tables after
the repository has first been persisted according to your repository XML
file.

However I do not know whether JCR uses the existence of the folder hierarchy
as an indicator that it has been initialized.

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

> Hi,
>
> Sorry, I think the original question I had asked still seems to have been
> unanswered.
>
> This is the question I had.
>
> does Guvnor keep creating additional tables as per the need or is the Table
> structure that Guvnor creates in the beginning where all the assets are
> stored remains the same until we manually delete the Tables?
>
>
> after creating rules and assets for several days, we had to re deploy  a
> freshly compiled Guvnor war file( everything remaining the same)  using the
> same repository xml and same database connected through jndi datasource.
>
> In other words, just the war file has been recompiled. we also deleted the
> workspace and repository directories previously created by Guvnor.
>
> The DBA had locked the userid permissions to prevent any new table creation
> in the Guvnor database.
>
> During Guvnor startup, Guvnor had complained about not having permission to
> create Tables.
>
> My question is :
>
> why does Guvnor need to create any additional tables and not use the
> existing Table structure in the database.
>
>  I would appreciate any thoughts on this.
>
>
>
>
>
> --- 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, 10:52 PM
>
>
> Hi,
>
> 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.
>
>
> May be it is recommended. But when you modify a lot the assets, rename,
> copy, delete,etc.. Guvnor gets lost.
>
>
>  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.
>
>
>
> The search indexes, they are stored on the file system no ? And with no
> index, you cannot reach any of the assets. So when you delete thoses
> directories, at startup, they are re-created and the database is read. I do
> not know what is read, but it can take quite some times, depending on the
> size of the package. Now If there is a way to store thoses indexes in the
> database, I would be happy to know how.
>
> The project I am on has many rules and many big web decision tables that
> end up with more than 100000 rules.  I am using 5.3 snapshot with MVEL beta6
> => Startup time =5 minutes and building the package, 3 to 5 minutes on a HP
> G6 processor. On my PC that has an i5 processor and a 32 bits linux, I
> cannot build anymore the package.
> With those sizes, which is not that much, Guvnor/jackrabbits gets lots on
> the indexes : it gives jackrabbit exceptioorn or spaces are not considered.
> So then, what I do is delete those two directories and restart guvnor and
> everything is fine again.
> Thanks
> Nicolas
>
>
>
>
> -----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/20110905/e30b4915/attachment.html