[rules-users] Changing Guvnor PresistantManager to MSSQL

[eyal edri]

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 at 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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20100505/eaf437cb/attachment.html