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 <[email protected]> > 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 <[email protected]>* wrote: > > > From: Nicolas Héron <[email protected]> > Subject: Re: [rules-users] Guvnor repository database use to store assets > To: "Rules Users List" <[email protected]> > 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 > [email protected]<http://mc/[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
