[
https://issues.apache.org/jira/browse/ODE-1073?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sathwik Bantwal Premakumar updated ODE-1073:
--------------------------------------------
Description:
<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
was:
<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."
> 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
> Fix For: 1.3.8
>
>
> <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
(v7.6.3#76005)
