We trying to use a number of different graphs on the same datasource (a database). We have different queries we want to run on the database and so we use different graphs.
Connecting and disconnecting every time we run a graph (which is frequently) is time-consuming and resource consuming. Is there any way we can share a DBConnection between these graphs? (We’re loading them from XML)
Thanks for that - we’ll do the injection in the meantime.
Currently, there is now possibility to preserve existing DB connection between graph’s executions - as when the execution is finished, all objects (including DB connections) are destroyed.
This would require a modification to the DBConnection object and in a first step change the way transformation graph is executed.
If you run your transformation graphs from within another Java program, you could create your own connection pool and then modify TransformationGraph class a bit to “inject” objects from this connection pool to the graph upon load from XML.
Anyway, we will log this as a feature request to the future.