Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

This service carries out an SQL update on a database and returns "update successful" if the update worked.

Input ports

  • driver - The name of the driver to be used to access the database, For example foo.bah.Driver. This parameter is mandatory.The library containing the driver must be visible to Taverna e.g. in Taverna's lib directory. The jar must be added as a dependency of the service and the Classloader persistence must be set to "System classloader".
  • params - A list of parameters to be passed to the SQL Query. If the SQL Query does not have parameters, then the list may be empty or not specified.
  • password - The password to be used to access the database for the specified user. If access is not limited to specific users, or if the user does not have a password, then the parameter can be empty or not specified.
  • sql - The SQL for the update. This parameter is mandatory.
  • url - The url of the database. This parameter is mandatory.
  • userid - The user name to be used to access the database. If access is not restricted, then the userid can be left empty or not specified.

Output ports

  • resultList - The string "update successful" if the update worked.