ode-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sathwik Bantwal Premakumar (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (ODE-1073) Error mysql streaming resultset is still active
Date Mon, 12 Mar 2018 06:12:00 GMT

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

Sathwik Bantwal Premakumar resolved ODE-1073.
    Resolution: Workaround

> Error mysql streaming resultset is still active
> -----------------------------------------------
>                 Key: ODE-1073
>                 URL: https://issues.apache.org/jira/browse/ODE-1073
>             Project: ODE
>          Issue Type: Bug
>          Components: BPEL Runtime
>    Affects Versions: 1.3.7, 1.3.8
>            Reporter: Sathwik Bantwal Premakumar
>            Assignee: Sathwik Bantwal Premakumar
>            Priority: Minor
> <openjpa-2.4.2-r422266:1777108 nonfatal general error> org.apache.openjpa.persistence.PersistenceException:
Streaming result set com.mysql.jdbc.RowDataDynamic@735a8840 is still active. No statements
may be issued when any streaming result sets are open and in use on a given connection. Ensure
that you have called .close() on any active streaming result sets before attempting more queries.
> [http://openjpa.apache.org/builds/2.4.2/apache-openjpa/docs/dbsupport_mysql.html]
> "When using large result sets with MySQL there are a number of documented limitations.
Please read the section titled "ResultSet" in the "MySQL JDBC API Implementation Notes". The
net effect of these limitations is that you will have to read all of the rows of a result
set (or close the connection) before you can issue any other queries on the connection, or
an exception will be thrown. Setting openjpa.FetchBatchSize to any value greater than zero
will enable streaming result sets."
> Mysql Server: 5.7.21
> JDBC Driver: mysql-connector-java-5.1.45-bin

This message was sent by Atlassian JIRA

View raw message