Hi,
I am trying to get Taverna to store my workflow inputs and outputs into
a MySQL database. For the Commandline Tool 2.2, I followed the
instructions at
http://www.taverna.org.uk/documentation/taverna-2-x/command-line-tool/,
but it does not work properly. In Taverna Workbench 2.2.0, I get the
same behavior (However, Taverna Workbench 2.1.2 works fine).
My database Version 5.1 runs on a Windows XP machine. The user has all
privileges granted. I create a database named T2Provenance manually and
run a workflow. The connection to the database works fine, since 13
tables are created, some of them with content. Specifically, the table
inlinestringreference contains the input values of the executed
workflow. In the terminal, I get the following error:
ERROR 2010-08-25 12:28:17,594
(net.sf.taverna.t2.provenance.connector.MySQLProvenanceConnector:167) -
There was a problem creating the Provenance database database:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key
was too long; max key length is 1000 bytes
I investigated a little and found out that it might have something to do
with primary keys which are encoded as utf8. In the class
MySQLProvenanceConnector the line 151 is:
String engineAndCharset = " ENGINE=MyISAM DEFAULT
CHARSET=utf8";
That string is appended to each CREATE TABLE statement later on. Could
this be a problem? I have also read somewhere that the table definitions
were changed in version 2.2.0 of Taverna.
In the terminal, there is another error message, which seems to be a
follow-up error:
ERROR 2010-08-25 12:28:17,623
(net.sf.taverna.t2.provenance.connector.ProvenanceConnector:312) -
Problem with provenance initialisation:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
't2provenance.workflowrun' doesn't exist
My guess is that the table "workflowrun" cannot be created because of
the max key length problem.
I also tried the last taverna2.3 nightly build with the same results.
Can anybody help me out?
Regards
Dennis
------------------------------------------------------------------------------
Sell apps to millions through the Intel(R) Atom(Tm) Developer Program
Be part of this innovative community and reach millions of netbook users
worldwide. Take advantage of special opportunities to increase revenue and
speed time-to-market. Join now, and jumpstart your future.
http://p.sf.net/sfu/intel-atom-d2d
_______________________________________________
taverna-hackers mailing list
[email protected]
Web site: http://www.taverna.org.uk
Mailing lists: http://www.taverna.org.uk/about/contact-us/
Developers Guide: http://www.taverna.org.uk/developers/
