[rules-users] configuring guvnor to use mySQL as its data store

[Darrin Mison]

Hi,  I'm trying to configure guvnor to use an external database  
(mySQL) as its datastore.  But I can't get it to work, it seems to  
ignore any change I make.

I followed the directions from the project docs.  Deployed guvnor (on  
JBoss SOA Platform 4.3) , and edited the repository.xml that got  
created in bin.  I commented out the existing PersistenceManager  
config from <workspace> and added this:

	<PersistenceManager  
class 
= 
"org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager">
             <param name="driver" value="com.mysql.jdbc.Driver"/>
             <param name="url" value="jdbc:mysql://localhost:3306/ 
brms"/>
             <param name="user" value="brms_user"/>
             <param name="password" value="brms_password"/>
             <param name="schemaObjectPrefix" value="${wsp.name}_"/>
             <param name="schema" value="mysql"/>
         </PersistenceManager>

I've added the mysql jdbc jar to the server config lib directory,  
created an empty database and have granted all rights to the specified  
database user.  I made all these changes after halting the server.

But after starting it up again it just seems to ignore all of that and  
continue using the previous derby config.

Anyone got any ideas ?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20090402/19431f78/attachment.html