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.e...@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.e...@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.e...@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
_______________________________________________ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users