[kepler-dev] valueChanged in Provenance module

[Daniel Crawl]

Hi Donghoon,

The ProvenanceRecorder class captures provenance information
from workflow events, but Recording classes are responsible
for writing this to a specific type of output such as a database.
(i.e., there's no database connections in ProvenanceRecorder.)

The default provenance settings use SQLRecordingV8.java. If you
want to perform a query after the workflow finishes execution,
you can add the query to executionStop() in this class.

   --dan

On 11/19/14 5:07 PM, DONGHOON KIM wrote:
> Dear Kepler folks and Daniel,
>
> I have a question for DB connection when the value of an actor (constant
> actor) is changed.
> Suppose that a user changes a value of an each after executing a workflow.
> I checked the source code with debugging mode.
> But I can not find where DB is reconnected (see attached)
>
> Actually, I am trying to extract some data after finishing the recording in
> wrapup() in ProvenanceRecorder class.
>
> How do I add SQL query like below in ProvenanceRecorder with DB connection?
> =====
>    ResultSet result = null;
>              try
>              {
>                  result = _psWorkflows.executeQuery();
>                  while(result.next())
>                  {
>                      if(result.getString("name").equals(workflow))
>                      {
>                          retval = result.getInt("id");
>                          break;
>                      }
>                  }
>              }
> ====
>
> Please, let me know if you need more information.
>
> Thank you~
>
> -Donghoon
>
>
>