[ODE-1073] Error mysql streaming resultset is still active

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Workaround
• Affects Version/s: 1.3.7, 1.3.8
• Component/s: BPEL Runtime
• Assignee: Sathwik
• Reporter: Sathwik
• Created: 12/Mar/18 05:55
• Updated: 12/Mar/18 06:12
• Resolved: 12/Mar/18 06:11

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."

OpenJPA DAO

Mysql Server: 5.7.21

JDBC Driver: mysql-connector-java-5.1.45-bin