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(a)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(a)gmail.com>* wrote:
From: Nicolas Héron <nicolas.heron.java(a)gmail.com>
Subject: Re: [rules-users] Guvnor repository database use to store assets
To: "Rules Users List" <rules-users(a)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@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(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users