Thank. I was able to get this to work with one slight change. This change is probably obvious to most of you but I'll specify it here for completeness. I am not very familiar with mysql nor the connector.I am using Tomcat under Linux.
Replace this >> >> jdbc:mysql://localhost/myDatabase?user=monty&password=greatsqldb"); >> >> With this ( Note I added the create step which may not always be required, but I used it and it did create the tables for me. ) > jdbc:mysql://localhost/myDatabase?user=monty&password=greatsqldb&create=true;" Thanks, --jeff Stian Soiland-Reyes wrote: > 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. > -- ****************************************** Jeffrey L. Tilson, Ph.D. Senior Research Scientist Renaissance Computing Institute (RENCI) Campus Box 3455 University of North Carolina Chapel Hill, NC 27599-3455 919.445.9657 (o) 919.962.1380 (f) ***************************************** ------------------------------------------------------------------------------ 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
