<div dir="ltr">OK,<div><br></div><div>after changing the default workspace.xml file PersistantManager to also MSSQL settings,</div><div><br></div><div>things look a lot better... (created another tables on Drools db).</div>
<div><br></div><div>thanks :)</div><div><br></div><div>Eyal.<br><br><div class="gmail_quote">On Wed, May 5, 2010 at 2:52 PM, eyal edri <span dir="ltr"><<a href="mailto:eyal.edri@gmail.com">eyal.edri@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div dir="ltr">Getting there..<div><br></div><div>I've manged to make drools find the jdbc.jar and even start successfully!! :)</div>
<div>so it auto-created some VERSION_x tables in the Drools DB.</div><div><br></div><div>
the conf i'm using is: (diff driver + url)</div><div><br></div><div><div class="im"><div><span style="font-size:x-small"><PersistenceManager class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager"></span></div>
</div><div><span style="font-size:x-small"> <param name="driver" value="<span style="background-color:rgb(153, 0, 0)">com.microsoft.sqlserver.jdbc.SQLServerDriver</span>"/></span></div>
<div><span style="font-size:x-small"> <param name="url" value="<span style="background-color:rgb(153, 0, 0)">jdbc:sqlserver://my-sql:1433;databaseName=Drools</span>;"/></span></div>
<div class="im">
<div><span style="font-size:x-small"> <param name="schema" value="mssql"/></span></div><div><span style="font-size:x-small"> <param name="user" value="sa"/></span></div>
<div><span style="font-size:x-small"> <param name="password" value="xxx"/></span></div><div><span style="font-size:x-small"> <param name="schemaObjectPrefix" value="${<a href="http://wsp.name" target="_blank">wsp.name</a>}_"/></span></div>
<div><span style="font-size:x-small"> <param name="externalBLOBs" value="false"/></span></div><div><span style="font-size:x-small"></PersistenceManager></span></div>
<div><br></div></div></div><div><br></div><div>now, when i tell him to create a new sample project it fails with:</div><div><br></div><div><div><span style="background-color:rgb(204, 102, 0)">14:39:45,497 INFO [STDOUT] ERROR 05-05 14:39:45,496 (RulesRepositoryAdministrator.java:clearRulesRepository:79) javax.jcr.RepositoryException: /: unable to update item.: 17528b92-d60d-48cf-82dd-7c9654effe34: 17528b92-d60d-48cf-82dd-7c9654effe34</span></div>
<div><span style="background-color:rgb(204, 102, 0)">14:39:54,217 INFO [STDOUT] ERROR 05-05 14:39:54,216 (RepositoryServiceServlet.java:doUnexpectedFailure:62) org.drools.repository.RulesRepositoryException: javax.jcr.InvalidItemStateException: /: the item cannot be saved because it has been modified externally.</span></div>
<div><br></div><div>ideas?</div><div><div></div><div class="h5"><div><br></div><br><div class="gmail_quote">On Wed, May 5, 2010 at 2:32 PM, eyal edri <span dir="ltr"><<a href="mailto:eyal.edri@gmail.com" target="_blank">eyal.edri@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<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><div> <param name="schemaObjectPrefix" value="${<a href="http://wsp.name" target="_blank">wsp.name</a>}_"/></div>
</div><div>to <param name="schemaObjectPrefix" value="version_"/></div><div><br></div><div>now i get an exception about not finding the jdbc driver. </div>
<div><br></div><div><div><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><div></div><div><div><br></div><div class="gmail_quote">On Wed, May 5, 2010 at 2:08 PM, eyal edri <span dir="ltr"><<a href="mailto:eyal.edri@gmail.com" target="_blank">eyal.edri@gmail.com</a>></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'm a drools newbie, and i'm trying to connect GUVNOR to MSSQL.</div><div>
I'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> <Workspace name="${<a href="http://wsp.name" target="_blank">wsp.name</a>}"></div><div> <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem"></div>
<div> <param name="path" value="${wsp.home}"/></div>
<div> <span style="background-color:rgb(255, 204, 51)"> <PersistenceManager class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager"></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)"> <param name="driver" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/></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)"> <param name="url" value="jdbc:microsoft:sqlserver://my-sql:1433;;DatabaseName=Drools;SelectMethod=Cursor;"/></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)"> <param name="schema" value="mssql"/></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)"> <param name="user" value="sa"/></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)"> <param name="password" value="xxx"/></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)"> <param name="schemaObjectPrefix" value="${<a href="http://wsp.name" target="_blank">wsp.name</a>}_"/></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)"> <param name="externalBLOBs" value="false"/></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)"></PersistenceManager></span></div>
<div>....</div><div><br></div><div> </Workspace></div><div><br></div><div>and versioning also:</div><div><br></div><div><div><Versioning rootPath="${rep.home}/version"></div><div> </div><div> <span style="background-color:rgb(255, 153, 0)"> <PersistenceManager class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager"></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)"> <param name="driver" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/></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)"> <param name="url" value="jdbc:microsoft:sqlserver://my-sql:1433;;DatabaseName=Drools;SelectMethod=Cursor;"/></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)"> <param name="schema" value="mssql"/></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)"> <param name="user" value="sa"/></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)"> <param name="password" value="xxx"/></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)"> <param name="schemaObjectPrefix" value="${<a href="http://wsp.name" target="_blank">wsp.name</a>}_"/></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)"> <param name="externalBLOBs" value="false"/></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)"></PersistenceManager></span></div>
<div> </Versioning></div></div><div><br></div><div><br></div><div><ul><li>i'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'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></div></div>-- <br>Eyal Edri<br>
</div></div>
</blockquote></div><br><br clear="all"><br></div></div>-- <br>Eyal Edri<br>
</div></div>
</blockquote></div><br><br clear="all"><br>-- <br>Eyal Edri<br>
</div></div>