[
https://issues.apache.org/jira/browse/FLINK-23437?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17384298#comment-17384298
]
Roman Khachatryan commented on FLINK-23437:
-------------------------------------------
Flink creates a new connection for a XID which can exceed DoP and probably
connection limit (for Oracle it should be disabled I think, but there is no
such option currently).
What are the the degree of parallelism (for sink), connection limit, and the
actual number of connections if you know it?
> Connection leak in XaFacadePoolingImpl
> --------------------------------------
>
> Key: FLINK-23437
> URL: https://issues.apache.org/jira/browse/FLINK-23437
> Project: Flink
> Issue Type: Bug
> Components: Connectors / JDBC
> Affects Versions: 1.13.1
> Reporter: Maciej Bryński
> Priority: Major
>
> Hi,
> I'm using JDBC XA connector to put data into Oracle database.
> I'm facing issue with too many concurrent connection to database.
> I changed this method to return XaFacadeImpl instead of XaFacadePoolingImpl
> and problem was solved.
> {code:java}
> static XaFacade fromXaDataSourceSupplier(
> Supplier<XADataSource> dataSourceSupplier, Integer timeoutSec) {
> return new XaFacadePoolingImpl(() -> new XaFacadeImpl(dataSourceSupplier,
> timeoutSec));
> }
> {code}
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
