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

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&gt; 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&gt; 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