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!
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
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
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
-- Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.