OK, some progress, i found out that the versioning section was casuing the problem, so i changed <param name="schemaObjectPrefix" value="${wsp.name}_"/> to <param name="schemaObjectPrefix" value="version_"/> now i get an exception about not finding the jdbc driver. Caused by: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver 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. is there another jar i should use for this driver? attached is the new stacktrace.. thanks, Eyal. On Wed, May 5, 2010 at 2:08 PM, eyal edri <eyal.edri(a)gmail.com&gt; wrote: > Hi, > > I'm a drools newbie, and i'm trying to connect GUVNOR to MSSQL. > I've followed the guide and changed repository.xml as follows (the rest i > left unchanged from the default repository.xml): > > <Workspace name="${wsp.name}"> > <FileSystem > class="org.apache.jackrabbit.core.fs.local.LocalFileSystem"> > <param name="path" value="${wsp.home}"/> > <PersistenceManager > class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager"> > <param name="driver" > value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/> > <param name="url" > value="jdbc:microsoft:sqlserver://my-sql:1433;;DatabaseName=Drools;SelectMethod=Cursor;"/> > <param name="schema" value="mssql"/> > <param name="user" value="sa"/> > <param name="password" value="xxx"/> > <param name="schemaObjectPrefix" value="${wsp.name}_"/> > <param name="externalBLOBs" value="false"/> > </PersistenceManager> > .... > > </Workspace> > > and versioning also: > > <Versioning rootPath="${rep.home}/version"> > > <PersistenceManager > class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager"> > <param name="driver" > value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/> > <param name="url" > value="jdbc:microsoft:sqlserver://my-sql:1433;;DatabaseName=Drools;SelectMethod=Cursor;"/> > <param name="schema" value="mssql"/> > <param name="user" value="sa"/> > <param name="password" value="xxx"/> > <param name="schemaObjectPrefix" value="${wsp.name}_"/> > <param name="externalBLOBs" value="false"/> > </PersistenceManager> > </Versioning> > > > > - i'm running a standalone GUVNOR package. > - i created an empty Drools db in my server: my-sql > - I deleted all the repository dir content > - i'm getting a few exceptions: > > ERROR [[/drools-guvnor]] Exception sending context initialized event to > listener instance of class org.jboss.seam.servlet.SeamListener > org.jboss.seam.InstantiationException: Could not instantiate Seam > component: repositoryConfiguration > > (attached is the full stacktrace) > > can anyone help? > > > -- > Eyal Edri > -- Eyal Edri