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