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 ?
Show replies by date