You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Flavio Pompermaier (JIRA)" <ji...@apache.org> on 2017/09/08 12:05:00 UTC

[jira] [Updated] (FLINK-7605) JDBCOutputFormat autoCommit

     [ https://issues.apache.org/jira/browse/FLINK-7605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Flavio Pompermaier updated FLINK-7605:
--------------------------------------
    Description: 
Currently, if a connection is not created with autoCommit = true by default (e.g. Apache Phoenix), no data is written into the database.

So, in the JDBCOutputFormat.open() autoCommit should be forced on the created Connection, i.e.:

{
if (!conn.getAutoCommit()) {
  conn.setAutoCommit(true);
}
}

This should be well documented also..

  was:
Currently, if a connection is not created with autoCommit = true by default (e.g. Apache Phoenix), no data is written into the database.

So, in the JDBCOutputFormat.open() autoCommit should be forced on the created Connection, i.e.:

{{
if (!conn.getAutoCommit()) {
  conn.setAutoCommit(true);
}
}}

This should be well documented also..


> JDBCOutputFormat autoCommit
> ---------------------------
>
>                 Key: FLINK-7605
>                 URL: https://issues.apache.org/jira/browse/FLINK-7605
>             Project: Flink
>          Issue Type: Improvement
>          Components: Batch Connectors and Input/Output Formats
>    Affects Versions: 1.3.2
>            Reporter: Flavio Pompermaier
>            Priority: Minor
>
> Currently, if a connection is not created with autoCommit = true by default (e.g. Apache Phoenix), no data is written into the database.
> So, in the JDBCOutputFormat.open() autoCommit should be forced on the created Connection, i.e.:
> {
> if (!conn.getAutoCommit()) {
>   conn.setAutoCommit(true);
> }
> }
> This should be well documented also..



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)