<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
All Jackrabbit template ddl files are in the jackrabbit-core jar.
That would be a good place to start. <br>
<br>
Thanks.<br>
On 9/6/11 12:18 PM, puja nandamuri wrote:
<blockquote
cite="mid:1315325920.9177.YahooMailClassic@web33807.mail.mud.yahoo.com"
type="cite">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="font: inherit;" valign="top">the account
configured for the repository database has the following
change of permissions after the intial tables creation by
Guvnor.<br>
<br>
<!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-US</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:DontVertAlignCellWithSp/>
<w:DontBreakConstrainedForcedTables/>
<w:DontVertAlignInTxbx/>
<w:Word11KerningPairs/>
<w:CachedColBalance/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><span
style="font-size:11.0pt;font-family:"Arial","sans-serif";
mso-fareast-font-family:"Times
New Roman";mso-bidi-font-family:"Times New
Roman";
color:#1F497D;mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:
AR-SA">changed db_owner to db_datareader,<span
style="mso-spacerun:yes">
</span>db_datawriter and as usual, it has public rights</span>.<br>
<br>
I am not an database expert but, should not the above
permissions allow for ( DatabaseMetaData#getTables) ?<br>
<br>
any pointers on what exactly might be the sql used in this
case ?<br>
<br>
Thanks,<br>
<br>
Ram<br>
<br>
--- On <b>Mon, 9/5/11, Tihomir Surdilovic <i><a class="moz-txt-link-rfc2396E" href="mailto:tsurdilo@redhat.com"><tsurdilo@redhat.com></a></i></b>
wrote:<br>
<blockquote style="border-left: 2px solid rgb(16, 16,
255); margin-left: 5px; padding-left: 5px;"><br>
From: Tihomir Surdilovic <a class="moz-txt-link-rfc2396E" href="mailto:tsurdilo@redhat.com"><tsurdilo@redhat.com></a><br>
Subject: Re: [rules-users] Guvnor repository database
use to store assets<br>
To: <a class="moz-txt-link-abbreviated" href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
Date: Monday, September 5, 2011, 11:02 AM<br>
<br>
<div id="yiv708861624"> Jackrabbit will not try to
create any new tables after it initially created them.
However it does call a
*PersistenceManager.checkSchema() method which AFAIK
tries to read from the db metadata (
DatabaseMetaData#getTables). If the user does not have
permissions to do that, it will fail which I think is
the case in your scenario.<br>
<br>
Thanks.<br>
On 9/5/11 1:04 PM, puja nandamuri wrote:
<blockquote type="cite">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="font:inherit;" valign="top">Hi,
<div><br>
</div>
<div>Sorry, I think the original question I
had asked still seems to have been
unanswered.</div>
<div><br>
</div>
<div>This is the question I had.</div>
<div><br>
</div>
<div>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?</div>
<div><br>
</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>In other words, just the war file has
been recompiled. we also deleted the
workspace and repository directories
previously created by Guvnor. </div>
<div><br>
</div>
<div>The DBA had locked the userid
permissions to prevent any new table
creation in the Guvnor database.</div>
<div><br>
</div>
<div>During Guvnor startup, Guvnor had
complained about not having permission to
create Tables.</div>
<div><br>
</div>
<div>My question is :</div>
<div><br>
</div>
<div>why does Guvnor need to create any
additional tables and not use the existing
Table structure in the database. </div>
<div><br>
</div>
<div> I would appreciate any thoughts on
this.</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
<br>
--- On <b>Sun, 9/4/11, Nicolas Héron <i><a
moz-do-not-send="true"
rel="nofollow"
class="yiv708861624moz-txt-link-rfc2396E"
ymailto="mailto:nicolas.heron.java@gmail.com" target="_blank"
href="/mc/compose?to=nicolas.heron.java@gmail.com"><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" rel="nofollow"
class="yiv708861624moz-txt-link-rfc2396E"
ymailto="mailto:nicolas.heron.java@gmail.com"
target="_blank"
href="/mc/compose?to=nicolas.heron.java@gmail.com"><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" rel="nofollow"
class="yiv708861624moz-txt-link-rfc2396E"
ymailto="mailto:rules-users@lists.jboss.org"
target="_blank"
href="/mc/compose?to=rules-users@lists.jboss.org"><rules-users@lists.jboss.org></a><br>
Date: Sunday, September 4, 2011, 10:52
PM<br>
<br>
<div id="yiv708861624">Hi,
<div><br>
<div class="yiv708861624gmail_quote">
<blockquote
class="yiv708861624gmail_quote"
style="margin:0 0 0
.8ex;border-left:1px #ccc
solid;padding-left:1ex;">
<div>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>
</div>
</blockquote>
<div> </div>
<div>May be it is recommended. But
when you modify a lot the
assets, rename, copy,
delete,etc.. Guvnor gets lost.</div>
<div> </div>
<blockquote
class="yiv708861624gmail_quote"
style="margin:0 0 0
.8ex;border-left:1px #ccc
solid;padding-left:1ex;">
<div>
<div class="yiv708861624im">
<blockquote 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>
</div>
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>
</div>
</blockquote>
<div><br>
</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>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. </div>
<div>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.</div>
<div>Thanks</div>
<div>Nicolas</div>
<div> </div>
<blockquote
class="yiv708861624gmail_quote"
style="margin:0 0 0
.8ex;border-left:1px #ccc
solid;padding-left:1ex;">
<div> <br>
</div>
</blockquote>
</div>
</div>
</div>
<br>
-----Inline Attachment Follows-----<br>
<br>
<div class="yiv708861624plainMail">_______________________________________________<br>
rules-users mailing list<br>
<a moz-do-not-send="true"
rel="nofollow">rules-users@lists.jboss.org</a><br>
<a moz-do-not-send="true"
rel="nofollow" target="_blank"
href="https://lists.jboss.org/mailman/listinfo/rules-users">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
</div>
</blockquote>
</div>
</td>
</tr>
</tbody>
</table>
<br>
<fieldset class="yiv708861624mimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
rules-users mailing list
<a moz-do-not-send="true" rel="nofollow" class="yiv708861624moz-txt-link-abbreviated" ymailto="mailto:rules-users@lists.jboss.org" target="_blank" href="/mc/compose?to=rules-users@lists.jboss.org">rules-users@lists.jboss.org</a>
<a moz-do-not-send="true" rel="nofollow" class="yiv708861624moz-txt-link-freetext" target="_blank" href="https://lists.jboss.org/mailman/listinfo/rules-users">https://lists.jboss.org/mailman/listinfo/rules-users</a>
</pre>
</blockquote>
<br>
</div>
<br>
-----Inline Attachment Follows-----<br>
<br>
<div class="plainMail">_______________________________________________<br>
rules-users mailing list<br>
<a moz-do-not-send="true"
ymailto="mailto:rules-users@lists.jboss.org"
href="/mc/compose?to=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>
</div>
</blockquote>
</td>
</tr>
</tbody>
</table>
<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>