6:52 a.m.
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(a)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(a)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