Mailing-List: contact dev-help@flink.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@flink.apache.org
Date: Tue, 29 Aug 2017 16:57:00 +0000 (UTC)
From: "Nycholas de Oliveira e Oliveira (JIRA)" <jira@apache.org>
To: dev@flink.apache.org
Message-ID: <JIRA.13098326.1504025819000.149211.1504025820543@Atlassian.JIRA>
In-Reply-To: <JIRA.13098326.1504025819000@Atlassian.JIRA>
References: <JIRA.13098326.1504025819000@Atlassian.JIRA> <JIRA.13098326.1504025819225@jira-lw-us.apache.org>
Subject: [jira] [Created] (FLINK-7556) Fix fetch size configurable in
 JDBCInputFormat for MySQL Driver
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Tue, 29 Aug 2017 16:57:11 -0000

Nycholas de Oliveira e Oliveira created FLINK-7556:
------------------------------------------------------

             Summary: Fix fetch size configurable in JDBCInputFormat for MySQL Driver
                 Key: FLINK-7556
                 URL: https://issues.apache.org/jira/browse/FLINK-7556
             Project: Flink
          Issue Type: Bug
          Components: Batch Connectors and Input/Output Formats
    Affects Versions: 1.3.2
            Reporter: Nycholas de Oliveira e Oliveira
            Priority: Trivial


According to the MySQL documentation[1], it follows:

* ResultSet

??By default, ResultSets are completely retrieved and stored in memory. In most cases this is the most efficient way to operate and, due to the design of the MySQL network protocol, is easier to implement. If you are working with ResultSets that have a large number of rows or large values and cannot allocate heap space in your JVM for the memory required, you can tell the driver to stream the results back one row at a time.

To enable this functionality, create a Statement instance in the following manner:??

{code:java}
stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY,
              java.sql.ResultSet.CONCUR_READ_ONLY);
stmt.setFetchSize(Integer.MIN_VALUE);
{code}

??The combination of a forward-only, read-only result set, with a fetch size of Integer.MIN_VALUE serves as a signal to the driver to stream result sets row-by-row. After this, any result sets created with the statement will be retrieved row-by-row.
??

Allow the *Integer.MIN_VALUE* to be accepted as a parameter for _setFetchSize_.


[1] - https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-implementation-notes.html


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