<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">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 class="Apple-style-span" style="background-color: rgb(255, 204, 51); "> <PersistenceManager class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager"></span></div><div><span class="Apple-tab-span" style="white-space:pre"><span class="Apple-style-span" style="background-color: rgb(255, 204, 51);">        </span></span><span class="Apple-style-span" style="background-color: rgb(255, 204, 51);"> <param name="driver" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/></span></div>
<div><span class="Apple-tab-span" style="white-space:pre"><span class="Apple-style-span" style="background-color: rgb(255, 204, 51);">        </span></span><span class="Apple-style-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 class="Apple-tab-span" style="white-space:pre"><span class="Apple-style-span" style="background-color: rgb(255, 204, 51);">        </span></span><span class="Apple-style-span" style="background-color: rgb(255, 204, 51);"> <param name="schema" value="mssql"/></span></div>
<div><span class="Apple-tab-span" style="white-space:pre"><span class="Apple-style-span" style="background-color: rgb(255, 204, 51);">        </span></span><span class="Apple-style-span" style="background-color: rgb(255, 204, 51);"> <param name="user" value="sa"/></span></div>
<div><span class="Apple-tab-span" style="white-space:pre"><span class="Apple-style-span" style="background-color: rgb(255, 204, 51);">        </span></span><span class="Apple-style-span" style="background-color: rgb(255, 204, 51);"> <param name="password" value="xxx"/></span></div>
<div><span class="Apple-tab-span" style="white-space:pre"><span class="Apple-style-span" style="background-color: rgb(255, 204, 51);">        </span></span><span class="Apple-style-span" style="background-color: rgb(255, 204, 51);"> <param name="schemaObjectPrefix" value="${<a href="http://wsp.name">wsp.name</a>}_"/></span></div>
<div><span class="Apple-tab-span" style="white-space:pre"><span class="Apple-style-span" style="background-color: rgb(255, 204, 51);">        </span></span><span class="Apple-style-span" style="background-color: rgb(255, 204, 51);"> <param name="externalBLOBs" value="false"/></span></div>
<div><span class="Apple-style-span" style="background-color: rgb(255, 204, 51);"> </span><span class="Apple-tab-span" style="white-space:pre"><span class="Apple-style-span" style="background-color: rgb(255, 204, 51);">        </span></span><span class="Apple-style-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 class="Apple-style-span" style="background-color: rgb(255, 153, 0);"> <PersistenceManager class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager"></span></div>
<div><span class="Apple-tab-span" style="white-space:pre"><span class="Apple-style-span" style="background-color: rgb(255, 153, 0);">        </span></span><span class="Apple-style-span" style="background-color: rgb(255, 153, 0);"> <param name="driver" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/></span></div>
<div><span class="Apple-tab-span" style="white-space:pre"><span class="Apple-style-span" style="background-color: rgb(255, 153, 0);">        </span></span><span class="Apple-style-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 class="Apple-tab-span" style="white-space:pre"><span class="Apple-style-span" style="background-color: rgb(255, 153, 0);">        </span></span><span class="Apple-style-span" style="background-color: rgb(255, 153, 0);"> <param name="schema" value="mssql"/></span></div>
<div><span class="Apple-tab-span" style="white-space:pre"><span class="Apple-style-span" style="background-color: rgb(255, 153, 0);">        </span></span><span class="Apple-style-span" style="background-color: rgb(255, 153, 0);"> <param name="user" value="sa"/></span></div>
<div><span class="Apple-tab-span" style="white-space:pre"><span class="Apple-style-span" style="background-color: rgb(255, 153, 0);">        </span></span><span class="Apple-style-span" style="background-color: rgb(255, 153, 0);"> <param name="password" value="xxx"/></span></div>
<div><span class="Apple-tab-span" style="white-space:pre"><span class="Apple-style-span" style="background-color: rgb(255, 153, 0);">        </span></span><span class="Apple-style-span" style="background-color: rgb(255, 153, 0);"> <param name="schemaObjectPrefix" value="${<a href="http://wsp.name">wsp.name</a>}_"/></span></div>
<div><span class="Apple-tab-span" style="white-space:pre"><span class="Apple-style-span" style="background-color: rgb(255, 153, 0);">        </span></span><span class="Apple-style-span" style="background-color: rgb(255, 153, 0);"> <param name="externalBLOBs" value="false"/></span></div>
<div><span class="Apple-style-span" style="background-color: rgb(255, 153, 0);"> </span><span class="Apple-tab-span" style="white-space:pre"><span class="Apple-style-span" style="background-color: rgb(255, 153, 0);">        </span></span><span class="Apple-style-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 class="Apple-style-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 class="Apple-style-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>