topic Re: [resolved] Use Connection Pool with Oracle? in Talend Studio

[resolved] Use Connection Pool with Oracle?

Anonymous — Sat, 16 Nov 2024 11:34:51 GMT

Hi,
Is there any support for connection pool usage with tOracleConnection? In the User Guidie, it reads:
Specify a data source alias -
Select this check box and specify the alias of a data source created on
the Talend Runtime side to use the shared connection pool defined
in the data source configuration. This option works only when you
deploy and run your Job in Talend Runtime.

But this is very vague for me because currently I export my job as autonomous job and not using Talend Runtime at all in the deployment.
Do we have any workaround to use the connection pool? And if there's any example?
Thanks in advance!

Re: [resolved] Use Connection Pool with Oracle?

Anonymous — Fri, 18 Jul 2014 04:35:43 GMT

Hi,
Is this forum https://community.talend.com/t5/Design-and-Development/How-do-I-use-connection-pooling-with-tjdbcConnection/td-p/80145 helpful for your use case?
Best regards
Sabrina

Re: [resolved] Use Connection Pool with Oracle?

Anonymous — Fri, 18 Jul 2014 07:34:56 GMT

Thanks Sabrina. But that solution seems to work with a runtime container. What if I just want to run the job in autonomous job mode?

Re: [resolved] Use Connection Pool with Oracle?

Anonymous — Fri, 18 Jul 2014 07:41:59 GMT

Plus, that one is for Talend ESB, not talend DI, right?

Re: [resolved] Use Connection Pool with Oracle?

Anonymous — Fri, 18 Jul 2014 08:52:05 GMT

Hi,
Indeed, data source option only applies when deploying and running in the Talend Runtime.
What's your current job situation? Your job contains different tOracleConnection?
Best regards
Sabrina

Re: [resolved] Use Connection Pool with Oracle?

Anonymous — Mon, 21 Jul 2014 03:54:13 GMT

Yes, it contains two tOracleConnections.
The problem I have is that when one of the connections go idle for some time, it will go 'connection reset' when it is used afterwards. That's why I'm now thinking of using connection pools.
The exception I run into is:
origin:tOracleInput_4 message:java.sql.SQLRecoverableException:Io exception: Connection reset

Any thougts?

Re: [resolved] Use Connection Pool with Oracle?

Anonymous — Mon, 21 Jul 2014 04:01:28 GMT

Hi,
Would you mind uploading your job design screenshots into forum? Have you checked "Muti thread execution" feature to see if it satisfying your job requirment?
Best regards
Sabrina

Re: [resolved] Use Connection Pool with Oracle?

Anonymous — Tue, 22 Jul 2014 07:08:49 GMT

I was able to fix the connection reset problem by setting
SQLNET.EXPIRE_TIME=10
on Oracle side.
The connection reset problem itself is not due to Talend. And no, I'm not using multi thread feature.
My original question was whether we can have connection pool feature using tOracleConnection in Talend Enterprise DI. And I certaninly don't have a snapshot for that yet

Re: [resolved] Use Connection Pool with Oracle?

Anonymous — Tue, 22 Jul 2014 07:33:23 GMT

Hi,
For connection pool feature, it is not possible currently.
tXXConnection components allow you to open only one connection.
These connections can also be shared to "son" jobs.(Use or register a shared DB connection)
If you are usig the TIS version , you can also enable parallel execution in iterate.

Best regards
Sabrina

Re: [resolved] Use Connection Pool with Oracle?

Anonymous — Tue, 22 Jul 2014 10:38:46 GMT

Thanks Sabrina.
Hope to see connection pool being added in the future

Re: [resolved] Use Connection Pool with Oracle?

Anonymous — Tue, 22 Jul 2014 10:51:15 GMT

Hi,
Have you checked document about https://help.talend.com/search/all?query=How+to+share+a+database+connection&content-lang=en ?
Is "Use or register a shared DB connection" helpful for your current use case?
Best regards
Sabrina