<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> <param name="schemaObjectPrefix" value="${<a href="http://wsp.name" target="_blank">wsp.name</a>}_"/></div>
<div>to <param name="schemaObjectPrefix" value="version_"/></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"><<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">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>-- <br>Eyal Edri<br>
</div></div>