Can I close an Oracle connection without using tOracleClose?

One Star

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?)
Community Manager

Re: Can I close an Oracle connection without using tOracleClose?

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Can I close an Oracle connection without using tOracleClose?

This question actually stems from this post:
http://www.talendforge.org/forum/viewtopic.php?id=29923
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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read