Sathwik Bantwal Premakumar created ODE-1073:
-----------------------------------------------

             Summary: 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
            Reporter: Sathwik Bantwal Premakumar
            Assignee: Sathwik Bantwal Premakumar


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



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to