Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Can I close an Oracle connection without using tOracleClose?

I want to create a joblet that will close my Oracle connections but can accept the name of the connections dynamically. As far as I can tell, I can't do this dynamically with the tOracleClose component, so is there a Java command I can issue? (Or a similar solution?)
Labels (2)
2 Replies
Anonymous
Not applicable
Author

Hi
If the connection is created on the DB component such as tOracleInput, tOracleOutput, the connection will be closed by the component itself, if the connection is created on tOracleConnection, it can be closed by tOracleClose or tOracleCommit, do you create the DB connection in joblet or parent job? A screenshot of your job will help us more to understand your problem.
Shong
Anonymous
Not applicable
Author

This question actually stems from this post:
https://community.talend.com/t5/Data-Quality-Preparation-and/Pass-context-variable-values-to-joblet-...
I haven't received any responses to that one yet, but it contains the screenshot and more information if you wouldn't mind checking it out.