[rules-users] FIXED: Changing Guvnor PresistantManager to MSSQL

[eyal edri]

OK,

after changing the default workspace.xml file PersistantManager to also
MSSQL settings,

things look a lot better... (created another tables on Drools db).

thanks :)

Eyal.

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

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



-- 
Eyal Edri
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20100505/abeb788e/attachment.html