To turn on streaming at the statement level you need to use a set of common JDBC settings that, when used together, inform the driver to stream. When you create or prepare a statement you must define how the result will be used and what is the fetch size. For example,
Statement statement = connection.createStatement(and
PreparedStatement statement = connection.prepareStatement(For more information see section Result Set in JDBC API Implementation Notes. DataSource Level
"select ... from ... where ...",
To turn on streaming at the statement level you need to add a property to the JDBC uri. For example, Integer. MIN_VALUE is -2^31 and so use
jdbc:mysql://localhost/?defaultFetchSize=-2147483648For more information see Driver/Datasource Class Names, URL Syntax and Configuration Properties for Connector/J.  I could not use the MySql tools for dumping and loading the table data because I used an auto_increment column in one of the related tables, the target database was active with data, and so could not reset the target's auto_increment column to an appropriate value.