Example of Execute_SQL_Query with parameters

Created: 2012-03-16 14:12:35      Last updated: 2012-03-16 14:16:18

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.

Information Preview

Information Run

Run this Workflow in the Taverna Workbench...

Option 1:

Copy and paste this link into File > 'Open workflow location...'
https://myexperiment.org/workflows/2828/download?version=1
[ More InfoExpand ]


Information Workflow Components

Information Authors (1)
Information Titles (1)
Information Descriptions (1)
Information Dependencies (0)
Inputs (2)
Processors (7)
Beanshells (1)
Outputs (2)
Datalinks (10)
Coordinations (0)

Information Workflow Type

Taverna 2

Information Uploader

Information License

All versions of this Workflow are licensed under:

Information Version 1 (of 1)

Information Credits (1)

(People/Groups)

Information Attributions (0)

(Workflows/Files)

None

Information Tags (9)

Log in to add Tags

Information Shared with Groups (0)

None

Information Featured In Packs (0)

None

Log in to add to one of your Packs

Information Attributed By (0)

(Workflows/Files)

None

Information Favourited By (1)

Information Statistics

 

Citations (0)

None


Version History

In chronological order:



Reviews Reviews (0)

No reviews yet

Be the first to review!



Comments Comments (0)

No comments yet

Log in to make a comment




Workflow Other workflows that use similar services (0)

There are no workflows in myExperiment that use similar services to this Workflow.