<font color='black' size='2' face='arial'><font size="2"><font face="Arial, Helvetica, sans-serif">Hi all,<br>
<br>
I am trying to configure Guvnor to persist data in MySQL, I am running mysql 5.1-45 (windows 7) under Tomcat 6<br>
<br>
The steps that I did:<br>
<br>
1) Create empty database "drools" in Mysql<br>
<br>
2) Configure Tomcat data source<br>
<Resource name="jdbc/drools" type="javax.sql.DataSource"<br>
username="root" password="" driverClassName="com.mysql.jdbc.Driver"<br>
url="jdbc:mysql://localhost:3306/drools" maxActive="8" maxIdle="4" /><br>
<br>
3) Edit generated repository.xml<br>
<br>
<!--<br>
<FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem"><br>
<param name="path" value="${rep.home}/repository"/><br>
</FileSystem><br>
--><br>
<br>
<!-- tested with both param values --> <br>
<FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem"><br>
<param name="driver" value="javax.naming.InitialContext"/><br>
<!--<param name="url" value="java:comp/env/jdbc/drools"/>--><br>
<param name="url" value="jdbc/drools"/><br>
</FileSystem><br>
<br>
<DataStore class="org.apache.jackrabbit.core.data.db.DbDataStore"><br>
<param name="driver" value="javax.naming.InitialContext"/><br>
<!--<param name="url" value="java:comp/env/jdbc/drools"/>--><br>
<param name="url" value="jdbc/drools"/><br>
<param name="databaseType" value="mysql"/><br>
</DataStore><br>
<br>
<!-- same lines added for workspace and versioning --><br>
<PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager"><br>
<param name="driver" value="com.mysql.jdbc.Driver" /><br>
<param name="url" value="jdbc:mysql://localhost:3306/drools" /><br>
<param name="schema" value="drools" /><br>
<param name="user" value="root" /><br>
<param name="password" value="" /><br>
<param name="schemaObjectPrefix" value="${wsp.name}_"/><br>
<param name="externalBLOBs" value="false" /><br>
</PersistenceManager><br>
<br>
I used the links below to try those steps<br>
<br>
</font></font><h4 class="title"><a id="d0e131">1.2.2.2. Configuring Guvnor to use an
external RDBMS<font size="2"><font face="Arial, Helvetica, sans-serif"><br>
</font></font></a></h4><br>
http://downloads.jboss.com/drools/docs/5.0.1.26597.FINAL/drools-guvnor/html_single/index.html<font size="2"><font face="Arial, Helvetica, sans-serif"><br>
<br>
http://wiki.apache.org/jackrabbit/UsingJNDIDataSource<br>
<br>
Unfortunately I am getting the exception below<br>
<br>
Caused by: org.drools.repository.RulesRepositoryException: javax.jcr.RepositoryException: Invalid repository configuration: repository.xml: Configuration element FileSystem not found in Versioning.: Configuration element FileSystem not found in Versioning.<br>
at org.drools.guvnor.server.repository.BRMSRepositoryConfiguration.newSession(BRMSRepositoryConfiguration.java:116)<br>
at org.drools.guvnor.server.repository.BRMSRepositoryConfiguration.create(BRMSRepositoryConfiguration.java:56)<br>
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br>
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)<br>
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<br>
---------<br>
Caused by: javax.jcr.RepositoryException: Invalid repository configuration: repository.xml: Configuration element FileSystem not found in Versioning.: Configuration element FileSystem not found in Versioning.<br>
at org.apache.jackrabbit.core.TransientRepository$2.getRepository(TransientRepository.java:250)<br>
at org.apache.jackrabbit.core.TransientRepository.startRepository(TransientRepository.java:265)<br>
at org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:333)<br>
at org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:363)<br>
at org.drools.guvnor.server.repository.BRMSRepositoryConfiguration.newSession(BRMSRepositoryConfiguration.java:112)<br>
... 62 more<br>
<br>
Could you please assist? <br>
<br>
Thanks in Advance<br>
</font></font></font>