[jira] [Commented] (ODE-1073) Error mysql streaming resultset is still active

["Sathwik Bantwal Premakumar (JIRA)" <ji...@apache.org>]

    [ 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)