Raoul JP Bonnal wrote: > Hello, first post Hello,
> Is it possible to execute SQL queries in T2 ? If yes how ? > I can't see (T2) the Local Java widgets -> jdbc -> Execute SQL query > which is present in T1.7 . Currently no. There is an issue with the beanshell not picking up dependencies, and another issue with the licensing applied to mysql etc. The dependencies issue should be fixed in Taverna 2.1 - I'll chase up what is happening with the licensing issue. > Other question, how can I pass to a SQL query more than 1 parameter ? In Taverna 1.7.1, you can pass a list of parameters to the params ports of the Execute_SQL_Query local java widget. Within your query, the first parameter will be bound to the first element of the params list, the second parameter to the second and so on. You will get an error if the number of parameters in the query and the number of elements in the list do not match. Alan ------------------------------------------------------------------------------ _______________________________________________ taverna-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/taverna-users Documentation: http://www.mygrid.org.uk/usermanual1.7/ FAQ: http://www.mygrid.org.uk/wiki/Mygrid/TavernaFaq Biological Services: http://www.mygrid.org.uk/wiki/Mygrid/BiologicalWebServices
