<div dir="ltr">OK,<div><br></div><div>some progress,</div><div><br></div><div>i found out that the versioning section was casuing the problem, so i changed </div><div>  &lt;param name=&quot;schemaObjectPrefix&quot; value=&quot;${<a href="http://wsp.name" target="_blank">wsp.name</a>}_&quot;/&gt;</div>

<div>to   &lt;param name=&quot;schemaObjectPrefix&quot; value=&quot;version_&quot;/&gt;</div><meta http-equiv="content-type" content="text/html; charset=utf-8"><div><br></div><div>now i get an exception about not finding the jdbc driver. </div>

<div><br></div><div><div><span class="Apple-style-span" style="background-color: rgb(204, 102, 0);">Caused by: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver</span></div><div><br></div><div>

i put sql-jdbc.2.0.jar which i use in all my java apps in the class path (/usr/lib and also in the lib dir of the jboss server). with no luck.</div><div><br></div><div>is there another jar i should use for this driver? </div>

<div><br></div><div>attached is the new stacktrace.. </div><div><br></div><div>thanks,</div><div><br></div><div>Eyal.</div><div><br></div><div class="gmail_quote">On Wed, May 5, 2010 at 2:08 PM, eyal edri <span dir="ltr">&lt;<a href="mailto:eyal.edri@gmail.com">eyal.edri@gmail.com</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div dir="ltr">Hi,<div><br></div><div>I&#39;m a drools newbie, and i&#39;m trying to connect GUVNOR to MSSQL.</div><div>

I&#39;ve followed the guide and changed repository.xml as follows (the rest i left unchanged from the default repository.xml):</div>
<div><br></div><div><div> &lt;Workspace name=&quot;${<a href="http://wsp.name" target="_blank">wsp.name</a>}&quot;&gt;</div><div>        &lt;FileSystem class=&quot;org.apache.jackrabbit.core.fs.local.LocalFileSystem&quot;&gt;</div>

<div>            &lt;param name=&quot;path&quot; value=&quot;${wsp.home}&quot;/&gt;</div>
<div>       <span style="background-color:rgb(255, 204, 51)"> &lt;PersistenceManager class=&quot;org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager&quot;&gt;</span></div><div><span style="white-space:pre"><span style="background-color:rgb(255, 204, 51)">        </span></span><span style="background-color:rgb(255, 204, 51)">       &lt;param name=&quot;driver&quot; value=&quot;com.microsoft.jdbc.sqlserver.SQLServerDriver&quot;/&gt;</span></div>


<div><span style="white-space:pre"><span style="background-color:rgb(255, 204, 51)">        </span></span><span style="background-color:rgb(255, 204, 51)">       &lt;param name=&quot;url&quot; value=&quot;jdbc:microsoft:sqlserver://my-sql:1433;;DatabaseName=Drools;SelectMethod=Cursor;&quot;/&gt;</span></div>


<div><span style="white-space:pre"><span style="background-color:rgb(255, 204, 51)">        </span></span><span style="background-color:rgb(255, 204, 51)">       &lt;param name=&quot;schema&quot; value=&quot;mssql&quot;/&gt;</span></div>


<div><span style="white-space:pre"><span style="background-color:rgb(255, 204, 51)">        </span></span><span style="background-color:rgb(255, 204, 51)">       &lt;param name=&quot;user&quot; value=&quot;sa&quot;/&gt;</span></div>


<div><span style="white-space:pre"><span style="background-color:rgb(255, 204, 51)">        </span></span><span style="background-color:rgb(255, 204, 51)">       &lt;param name=&quot;password&quot; value=&quot;xxx&quot;/&gt;</span></div>


<div><span style="white-space:pre"><span style="background-color:rgb(255, 204, 51)">        </span></span><span style="background-color:rgb(255, 204, 51)">       &lt;param name=&quot;schemaObjectPrefix&quot; value=&quot;${<a href="http://wsp.name" target="_blank">wsp.name</a>}_&quot;/&gt;</span></div>


<div><span style="white-space:pre"><span style="background-color:rgb(255, 204, 51)">        </span></span><span style="background-color:rgb(255, 204, 51)">       &lt;param name=&quot;externalBLOBs&quot; value=&quot;false&quot;/&gt;</span></div>


<div><span style="background-color:rgb(255, 204, 51)">   </span><span style="white-space:pre"><span style="background-color:rgb(255, 204, 51)">        </span></span><span style="background-color:rgb(255, 204, 51)">&lt;/PersistenceManager&gt;</span></div>


<div>....</div><div><br></div><div>    &lt;/Workspace&gt;</div><div><br></div><div>and versioning also:</div><div><br></div><div><div>&lt;Versioning rootPath=&quot;${rep.home}/version&quot;&gt;</div><div>    </div><div>           <span style="background-color:rgb(255, 153, 0)"> &lt;PersistenceManager class=&quot;org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager&quot;&gt;</span></div>


<div><span style="white-space:pre"><span style="background-color:rgb(255, 153, 0)">        </span></span><span style="background-color:rgb(255, 153, 0)">       &lt;param name=&quot;driver&quot; value=&quot;com.microsoft.jdbc.sqlserver.SQLServerDriver&quot;/&gt;</span></div>


<div><span style="white-space:pre"><span style="background-color:rgb(255, 153, 0)">        </span></span><span style="background-color:rgb(255, 153, 0)">       &lt;param name=&quot;url&quot; value=&quot;jdbc:microsoft:sqlserver://my-sql:1433;;DatabaseName=Drools;SelectMethod=Cursor;&quot;/&gt;</span></div>


<div><span style="white-space:pre"><span style="background-color:rgb(255, 153, 0)">        </span></span><span style="background-color:rgb(255, 153, 0)">       &lt;param name=&quot;schema&quot; value=&quot;mssql&quot;/&gt;</span></div>


<div><span style="white-space:pre"><span style="background-color:rgb(255, 153, 0)">        </span></span><span style="background-color:rgb(255, 153, 0)">       &lt;param name=&quot;user&quot; value=&quot;sa&quot;/&gt;</span></div>


<div><span style="white-space:pre"><span style="background-color:rgb(255, 153, 0)">        </span></span><span style="background-color:rgb(255, 153, 0)">       &lt;param name=&quot;password&quot; value=&quot;xxx&quot;/&gt;</span></div>


<div><span style="white-space:pre"><span style="background-color:rgb(255, 153, 0)">        </span></span><span style="background-color:rgb(255, 153, 0)">       &lt;param name=&quot;schemaObjectPrefix&quot; value=&quot;${<a href="http://wsp.name" target="_blank">wsp.name</a>}_&quot;/&gt;</span></div>


<div><span style="white-space:pre"><span style="background-color:rgb(255, 153, 0)">        </span></span><span style="background-color:rgb(255, 153, 0)">       &lt;param name=&quot;externalBLOBs&quot; value=&quot;false&quot;/&gt;</span></div>


<div><span style="background-color:rgb(255, 153, 0)"> </span><span style="white-space:pre"><span style="background-color:rgb(255, 153, 0)">        </span></span><span style="background-color:rgb(255, 153, 0)">&lt;/PersistenceManager&gt;</span></div>


<div>    &lt;/Versioning&gt;</div></div><div><br></div><div><br></div><div><ul><li>i&#39;m running a standalone GUVNOR package.</li><li>i created an empty Drools db in my server: my-sql</li><li>I deleted all the repository dir content </li>


<li>i&#39;m getting a few exceptions:</li></ul><div><div><span style="background-color:rgb(204, 0, 0)">ERROR [[/drools-guvnor]] Exception sending context initialized event to listener instance of class org.jboss.seam.servlet.SeamListener</span></div>


<div><span style="background-color:rgb(204, 0, 0)">org.jboss.seam.InstantiationException: Could not instantiate Seam component: repositoryConfiguration</span></div></div></div><div><br></div><div>
(attached is the full stacktrace)</div><div><br></div><div>can anyone help?</div><div><br></div><br>-- <br>Eyal Edri<br>
</div></div>
</blockquote></div><br><br clear="all"><br>-- <br>Eyal Edri<br>
</div></div>