<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
On 9/4/11 4:45 PM, Nicolas Héron wrote:
<blockquote
cite="mid:CAAWMVGWp=wD3ugJrTN+guFtL6LJLxw2RQxVkMGkYEqQ0Rjw6Xg@mail.gmail.com"
type="cite">
<div>Ram,</div>
Yes they have to be deleted so that at startup Guvnor can created
them.</blockquote>
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. <br>
<blockquote
cite="mid:CAAWMVGWp=wD3ugJrTN+guFtL6LJLxw2RQxVkMGkYEqQ0Rjw6Xg@mail.gmail.com"
type="cite">
<div>At startup, Jackrabbit (containent in Guvnor) reads all the
database and creates the two directories. You do not need to
backup them.</div>
</blockquote>
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.<br>
<br>
Thanks.<br>
<blockquote
cite="mid:CAAWMVGWp=wD3ugJrTN+guFtL6LJLxw2RQxVkMGkYEqQ0Rjw6Xg@mail.gmail.com"
type="cite">
<div>Nicolas<br>
<br>
<div class="gmail_quote">2011/9/4 puja nandamuri <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:med_9501@yahoo.com">med_9501@yahoo.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex;">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="font:inherit" valign="top">Nicolas,
<div><br>
</div>
<div>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. </div>
<div><br>
</div>
<div>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. <br>
<br>
--- On <b>Sun, 9/4/11, Nicolas Héron <i><<a
moz-do-not-send="true"
href="mailto:nicolas.heron.java@gmail.com"
target="_blank">nicolas.heron.java@gmail.com</a>></i></b>
wrote:<br>
<blockquote style="border-left:2px solid rgb(16,
16, 255);margin-left:5px;padding-left:5px">
<br>
From: Nicolas Héron <<a
moz-do-not-send="true"
href="mailto:nicolas.heron.java@gmail.com"
target="_blank">nicolas.heron.java@gmail.com</a>><br>
Subject: Re: [rules-users] Guvnor repository
database use to store assets<br>
To: "Rules Users List" <<a
moz-do-not-send="true"
href="mailto:rules-users@lists.jboss.org"
target="_blank">rules-users@lists.jboss.org</a>><br>
Date: Sunday, September 4, 2011, 11:15 AM
<div>
<div class="h5"><br>
<br>
<div>Hi,
<div>Guvnor stores everything in the
database.</div>
<div>The directories workspace and
repository are for the lucene indexes
used by jackrabbit.</div>
<div>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.</div>
<div>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.</div>
<div>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..)</div>
<div>Now are you using the community
version ? The question you ask is
typically one that you would ask to a
professional support.</div>
<div>Regards</div>
<div>Nicolas Heron<br>
<br>
<div>2011/9/4 puja nandamuri <span
dir="ltr"><<a
moz-do-not-send="true"
rel="nofollow"
href="http://mc/compose?to=med_9501@yahoo.com"
target="_blank">med_9501@yahoo.com</a>></span><br>
<blockquote style="margin:0 0 0
.8ex;border-left:1px #ccc
solid;padding-left:1ex">
<table border="0" cellpadding="0"
cellspacing="0">
<tbody>
<tr>
<td style="font:inherit"
valign="top">Hi All,<br>
<br>
we are currently using
SQLServer as the database
repository for Guvnor
5.2.0.CR1<br>
<br>
Can somone throw some light
on how the database is used
by Guvnor in the following
scenario?<br>
<br>
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 .<br>
<br>
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.<br>
<br>
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.<br>
<br>
the expectation is that
Guvnor will read the assets
from the existing database
and create new repository
and workspace directories on
file system .<br>
<br>
<br>
Guvnor threw errors saying <br>
<br>
<p>Caused By:
java.sql.SQLException:
[OWLS][SQLServer JDBC
Driver][SQLServer]CREATE
TABLE permission denied in
database 'GuvnorRules'.</p>
<p><br>
</p>
<p>does Guvnor create new
Tables everytime we deploy
a fresh instance of Guvnor
to weblogic ?</p>
<p><br>
</p>
<p>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?</p>
<p>
<br>
</p>
<p>I have attached a sample
of my repository.xml for
reference.</p>
<p><br>
</p>
<p>I appreciate your
thoughts and feedback.</p>
<p><br>
</p>
<p>
Thanks,</p>
<p><br>
</p>
<p>Ram<br>
</p>
<p><br>
</p>
<p><br>
</p>
<br>
<br>
<br>
</td>
</tr>
</tbody>
</table>
<br>
_______________________________________________<br>
rules-users mailing list<br>
<a moz-do-not-send="true"
rel="nofollow"
href="http://mc/compose?to=rules-users@lists.jboss.org"
target="_blank">rules-users@lists.jboss.org</a><br>
<a moz-do-not-send="true"
rel="nofollow"
href="https://lists.jboss.org/mailman/listinfo/rules-users"
target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
<br>
</blockquote>
</div>
<br>
</div>
</div>
<br>
</div>
</div>
-----Inline Attachment Follows-----
<div class="im"><br>
<br>
<div>_______________________________________________<br>
rules-users mailing list<br>
<a moz-do-not-send="true"
href="http://mc/compose?to=rules-users@lists.jboss.org"
target="_blank">rules-users@lists.jboss.org</a><br>
<a moz-do-not-send="true"
href="https://lists.jboss.org/mailman/listinfo/rules-users"
target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
</div>
</div>
</blockquote>
</div>
</td>
</tr>
</tbody>
</table>
<br>
_______________________________________________<br>
rules-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
<a moz-do-not-send="true"
href="https://lists.jboss.org/mailman/listinfo/rules-users"
target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
<br>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
rules-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a>
<a class="moz-txt-link-freetext" href="https://lists.jboss.org/mailman/listinfo/rules-users">https://lists.jboss.org/mailman/listinfo/rules-users</a>
</pre>
</blockquote>
<br>
</body>
</html>