[jira] [Commented] (FLINK-3228) Cannot submit multiple streaming involving JDBC drivers

["Gyula Fora (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/FLINK-3228?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15095729#comment-15095729 ] 

Gyula Fora commented on FLINK-3228:
-----------------------------------

I remember having similar issues. What worked for me is to explicitly call Class.forName(driverClass) before trying to create the connection with the DriverManager.

Could you please try this? 

> Cannot submit multiple streaming involving JDBC drivers
> -------------------------------------------------------
>
>                 Key: FLINK-3228
>                 URL: https://issues.apache.org/jira/browse/FLINK-3228
>             Project: Flink
>          Issue Type: Bug
>          Components: Streaming
>    Affects Versions: 0.10.1
>            Reporter: Nick Dimiduk
>
> I have a streaming pipeline that writes to JDBC in its SinkFunction. When testing in local mode, I cannot submit the same job multiple times without restarting flink. Failing to restart flink results in {{java.sql.SQLException: No suitable driver found}}. I think this has to do with how flink loads user classes and how the {{DriverManager}} resolves the JDBC Connection class.
> I'm not sure if this is only when running in local mode, or in general. I've been using YARN for cluster jobs, where I have 1:1 cluster to jobs. I suspect it will impact any cluster mode where processes are recycled between jobs.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)