[
https://issues.apache.org/jira/browse/ODE-1073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16394839#comment-16394839
]
Sathwik Bantwal Premakumar commented on ODE-1073:
-------------------------------------------------
Workaround: Disable Streaming Resultsets for Mysql.
Add this property in ode-axis2.properties file
openjpa.FetchBatchSize=-1
> 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."
> OpenJPA DAO
> 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)
