Example_of_Excecute_SQL_Query_with_parametersparams11 Dutch 2012-03-16 13:54:51.48 GMT rootpassword00Execute_SQL_Query_resultListxmlresultsExecute_SQL_Queryurl0userid0provideXml0sql0params1password0driver0resultList22xmlresults00net.sf.taverna.t2.activitieslocalworker-activity1.3net.sf.taverna.t2.activities.localworker.LocalworkerActivity driver 0 text/plain java.lang.String true password 0 text/plain java.lang.String true userid 0 text/plain java.lang.String true url 0 text/plain java.lang.String true provideXml 0 text/plain java.lang.String true sql 0 text/plain java.lang.String true params 1 text/plain java.lang.String true resultList 2 2 xmlresults 0 0 system net.sourceforge.taverna.scuflworkers.jdbc.SQLQueryWorker UserNameHere 2012-03-16 08:45:43.322 GMT net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Invokeurl_valuevalue00net.sf.taverna.t2.activitiesstringconstant-activity1.3net.sf.taverna.t2.activities.stringconstant.StringConstantActivity jdbc:mysql://localhost:3306/world net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Invokeuserid_valuevalue00net.sf.taverna.t2.activitiesstringconstant-activity1.3net.sf.taverna.t2.activities.stringconstant.StringConstantActivity root net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeprovideXml_valuevalue00net.sf.taverna.t2.activitiesstringconstant-activity1.3net.sf.taverna.t2.activities.stringconstant.StringConstantActivity true net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Invokesql_valuevalue00net.sf.taverna.t2.activitiesstringconstant-activity1.3net.sf.taverna.t2.activities.stringconstant.StringConstantActivity select country.Name, countrylanguage.language FROM country, countrylanguage WHERE country.code=countrylanguage.CountryCode AND countrylanguage.Language=?; net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokePutEachElementInAListinputlist1outputlist22net.sf.taverna.t2.activitiesbeanshell-activity1.3net.sf.taverna.t2.activities.beanshell.BeanshellActivity inputlist 1 text/plain java.lang.String true outputlist 2 2 workflow net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Invokedriver_valuevalue00net.sf.taverna.t2.activitiesstringconstant-activity1.3net.sf.taverna.t2.activities.stringconstant.StringConstantActivity com.mysql.jdbc.Driver net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeExecute_SQL_Queryurlurl_valuevalueExecute_SQL_Queryuseriduserid_valuevalueExecute_SQL_QueryprovideXmlprovideXml_valuevalueExecute_SQL_Querysqlsql_valuevalueExecute_SQL_QueryparamsPutEachElementInAListoutputlistExecute_SQL_QuerypasswordrootpasswordExecute_SQL_Querydriverdriver_valuevaluePutEachElementInAListinputlistparamsExecute_SQL_Query_resultListExecute_SQL_QueryresultListxmlresultsExecute_SQL_Queryxmlresults 61fa8d31-2a66-4aca-8703-1842c667828f 2012-03-16 08:51:50.838 GMT f078f72d-378b-4083-9ba2-a6f0bdcd2742 2012-03-16 13:06:21.844 GMT bd6c1688-96c5-46f6-bc35-5b36b77869e0 2012-03-16 12:50:07.455 GMT 234f560c-dd34-41c0-8314-fd34bca546d0 2012-03-16 12:51:26.796 GMT 5748aec2-ead9-43d5-9dca-7a7694dd80c0 2012-03-16 13:27:43.193 GMT 79081019-335c-476d-8377-4ebf030f809b 2012-03-16 08:54:34.202 GMT adcd0adc-9936-47b5-aa6a-92edce477941 2012-03-16 13:15:59.386 GMT 8d38d0ff-5611-4524-bc13-45c587cd2a94 2012-03-16 13:55:29.877 GMT 5c38aaa3-6d83-48b0-88f3-be4969a8f408 2012-03-16 12:38:55.191 GMT 59b55ddb-7bef-4da0-b600-9e40c0f8024a 2012-03-16 08:55:00.770 GMT 9da76d27-3768-4945-b00a-06dabc369183 2012-03-16 13:19:11.39 GMT 583d38aa-2f92-4f7e-832c-3a5c0a5af9ba 2012-03-16 13:54:34.372 GMT a69f4467-b6f3-4b65-920d-bcd478e3171d 2012-03-16 14:00:29.788 GMT 5927dc44-c3e2-45fb-bb42-6c26763d9fde 2012-03-16 13:59:07.171 GMT 3d962de2-527f-48c4-b987-b9278df71712 2012-03-16 13:03:21.182 GMT 4e564d7c-0f03-440f-a16f-9bde2f8bd8ad 2012-03-16 08:42:00.303 GMT Helen Hulme 2012-03-16 08:52:35.268 GMT a5a241ef-2a02-48fd-97a3-ff70f0d9a569 2012-03-16 13:21:38.460 GMT Example of Excecute_SQL_Query with parameters 2012-03-16 13:37:26.445 GMT e5f7fb30-4983-409a-a13e-4094b8c551f9 2012-03-16 09:16:07.643 GMT 7af43f4a-8649-4309-987a-37012a9b767b 2012-03-16 13:22:56.321 GMT 882a9608-99c9-4f66-82cb-e404e29cabe1 2012-03-16 08:46:02.120 GMT 1fd48e73-34ca-4cbb-b028-248d76cd4eb6 2012-03-16 08:50:49.544 GMT a724c7a3-d478-4238-977f-8f9825567a5f 2012-03-16 08:56:12.706 GMT d4a6de8c-9a70-49f1-a69e-a3bbee74c484 2012-03-16 09:09:18.999 GMT This workflow connects to a mysql on localhost, queries the "world" database which is one of the test databases on MySQL 5.5, queries it about which countries have Dutch as a language, and emits answers in both Lists and in xml. This workflow is intended as an example to help you see the syntax for the various inputs to this local service beanshell. see: http://www.mygrid.org.uk/dev/wiki/display/taverna/Execute+SQL+Query for instructions on jars, dependencies etc. The jar used here is: mysql-connector-java-5.1.18-bin.jar To run this workflow example, you'll also need * to have root access to a mysql database server on your machine on the default port. If your database is elsewhere or on another port, edit the url_value accordingly. * Have a database on there called "world" - this is one of the test databases which comes bundled with MySQL 5.5. By default, it has access by root user. Note that the beanshell PutEachElementInAList is not necessary for the workflow to run with a single input value (say "Dutch". But if you want to add more languages to the list of queries (Say, "Dutch", "Japanese", then it is necessary, because each set of parameters needs to be in its own list. 2012-03-16 13:59:58.229 GMT 04d4d541-386a-4e79-904b-afc3439eeb3d 2012-03-16 09:08:44.242 GMT 13395058-23e3-4aa7-b697-41575615d32d 2012-03-16 13:17:02.538 GMT