You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "xiaodao (Jira)" <ji...@apache.org> on 2020/10/09 12:50:00 UTC
[jira] [Commented] (FLINK-19435) jdbc JDBCOutputFormat open
function invoke Class.forName(drivername)
[ https://issues.apache.org/jira/browse/FLINK-19435?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17210907#comment-17210907 ]
xiaodao commented on FLINK-19435:
---------------------------------
[~jark] yes.
this is my test program.
!image-2020-10-09-20-48-48-261.png|width=1015,height=392!
and this is jstack info:
!image-2020-10-09-20-49-23-644.png!
> jdbc JDBCOutputFormat open function invoke Class.forName(drivername)
> --------------------------------------------------------------------
>
> Key: FLINK-19435
> URL: https://issues.apache.org/jira/browse/FLINK-19435
> Project: Flink
> Issue Type: Improvement
> Components: Connectors / JDBC
> Affects Versions: 1.10.2
> Reporter: xiaodao
> Priority: Major
> Fix For: 1.10.3
>
> Attachments: image-2020-10-09-20-48-48-261.png, image-2020-10-09-20-49-23-644.png
>
>
> when we sink data to multi jdbc outputformat ,
> ```
> protected void establishConnection() throws SQLException, ClassNotFoundException {
> Class.forName(drivername);
> if (username == null) {
> connection = DriverManager.getConnection(dbURL);
> } else {
> connection = DriverManager.getConnection(dbURL, username, password);
> }
> }
> ```
> may cause jdbc driver deadlock. it need to change to synchronized function.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)