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@gmail.com> 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