<font color='black' size='2' face='arial'>
<div> <br>
</div>
<div> <font size="2"><font face="Arial, Helvetica, sans-serif">Hi,<br>
<br>
I have changed the repository.xml to NOT use JNDI and its working now.<br>
<br>
<FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem"><br>
<param name="driver" value="com.mysql.jdbc.jdbc2.optional.MysqlDataSource"/><br>
<param name="url" value="jdbc:mysql://localhost:3306/drools" /><br>
<param name="user" value="root" /><br>
<param name="password" value="" /><br>
<param name="schema" value="mysql"/><br>
<param name="schemaObjectPrefix" value="J_V_FS_"/><br>
</FileSystem><br>
<PersistenceManager class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager"><br>
<param name="driver" value="com.mysql.jdbc.jdbc2.optional.MysqlDataSource"/><br>
<param name="url" value="jdbc:mysql://localhost:3306/drools" /><br>
<param name="user" value="root" /><br>
<param name="password" value="" /><br>
<param name="schema" value="mysql" /><br>
<param name="schemaObjectPrefix" value="J_V_PM_" /><br>
<param name="externalBLOBs" value="false" /><br>
</PersistenceManager><br>
<br>
Could someone give me an example of a configuration using JNDI ?<br>
<br>
Thanks a lot!<br>
</font></font></div>
<div style="clear: both;"></div>
<div> <br>
</div>
<div> <br>
</div>
<div style="font-family: arial,helvetica; font-size: 10pt; color: black;">-----Original Message-----<br>
From: andre.fonseca@mail.com<br>
To: rules-users@lists.jboss.org<br>
Sent: Mon, Apr 26, 2010 2:09 pm<br>
Subject: [rules-users] Guvnor - Persist data in MySQL<br>
<br>
<div id="AOLMsgPart_3_52da061f-308f-4c9a-8bee-60bf76df09b2">
<font color="black" face="arial" size="2"><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>
<a href="http://downloads.jboss.com/drools/docs/5.0.1.26597.FINAL/drools-guvnor/html_single/index.html" target="_blank">http://downloads.jboss.com/drools/docs/5.0.1.26597.FINAL/drools-guvnor/html_single/index.html</a><font size="2"><font face="Arial, Helvetica, sans-serif"><br>
<br>
<a href="http://wiki.apache.org/jackrabbit/UsingJNDIDataSource" target="_blank">http://wiki.apache.org/jackrabbit/UsingJNDIDataSource</a><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>
</div>
<!-- end of AOLMsgPart_3_52da061f-308f-4c9a-8bee-60bf76df09b2 -->
<div id="AOLMsgPart_4_52da061f-308f-4c9a-8bee-60bf76df09b2" style="margin: 0px; font-family: Tahoma,Verdana,Arial,Sans-Serif; font-size: 12px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
<pre style="font-size: 9pt;"><tt>_______________________________________________<br>
rules-users mailing list<br>
<a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
</tt></pre>
</div>
<!-- end of AOLMsgPart_4_52da061f-308f-4c9a-8bee-60bf76df09b2 -->
</div>
</font>