Getting there..

I've manged to make drools find the jdbc.jar and even start successfully!! :)

so it auto-created some VERSION_x tables in the Drools DB.

the conf i'm using is: (diff driver + url)

<PersistenceManager class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">

               <param name="driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>

               <param name="url" value="jdbc:sqlserver://my-sql:1433;databaseName=Drools;"/>

               <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>

now, when i tell him to create a new sample project it fails with:

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

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.

ideas?

On Wed, May 5, 2010 at 2:32 PM, eyal edri <eyal.edri@gmail.com> wrote:

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

--
Eyal Edri