On Tue, Mar 3, 2009 at 13:59, Jeffrey L. Tilson <[email protected]> wrote:
> Hello All,
> I am currently using v0.5.0+ of the REE. Generally it works well. I want
> to replace the derby embedded database with something abit more
> production oriented like mysql. Can someone point me to any
> documentation or tips on how to do that?
The remote execution service is using the official Java Persistance
API (JPA) and Hibernate.
You can change the configuration of this in the file
./WEB-INF/classes/META-INF/persistence.xml inside your unzipped .war
file.
These are the properties you would need to change:
<property name="hibernate.connection.driver_class"
value="org.apache.derby.jdbc.EmbeddedDriver" />
<property name="hibernate.connection.url"
value="jdbc:derby:/tmp/remoteTavernaDB;create=true"
/>
<property name="hibernate.dialect"
value="org.hibernate.dialect.DerbyDialect" />
You would need to download the mysql driver JAR (which due to GPL we
can't distribute together with the remote execution service) and place
it in WEB-INF/lib - see http://dev.mysql.com/downloads/connector/j/ -
I'm uncertain if you should use a 5.x version or 3.x version - again I
guess it depends on what version of the mySQL database you're
connecting to.
As the driver_class, try com.mysql.jdbc.Driver
For the connection URL, try something like:
jdbc:mysql://localhost/myDatabase?user=monty&password=greatsqldb");
For the dialect I believe org.hibernate.dialect.MySQLDialect should
work, otherwise try any of the other MySQL ones at
http://www.hibernate.org/hib_docs/v3/api/org/hibernate/dialect/package-summary.html
If you are changing these directly in remotetaverna/WEB-INF unzipped
by Tomcat, you just need to restart Taverna. Otherwise, zip together
again the .war to include your changed settings and redeploy to your
Tomcat.
--
Stian Soiland-Reyes, myGrid team
School of Computer Science
The University of Manchester
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
taverna-hackers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/taverna-hackers
Developers Guide: http://www.mygrid.org.uk/usermanual1.7/dev_guide.html
FAQ: http://www.mygrid.org.uk/wiki/Mygrid/TavernaFaq
