cancel
Showing results for 
Search instead for 
Did you mean: 

Streaming result set com.mysql.cj.protocol.a.result.ResultsetRowsStreaming@4d221f7a is still active

Gordon_Ye
Champ in-the-making
Champ in-the-making
Alfresco Content Services Edition: Enterprise
Alfresco Content Services Version: 7.0.1
db: mysql

use cmis to search data we encountered this issue  ,error message below

"message": "{\"error\":{\"errorKey\":\"framework.exception.ApiDefault\",\"statusCode\":500,\"briefSummary\":\"nested exception is org.apache.ibatis.exceptions.PersistenceException: \\n### Error querying database.  Cause: org.springframework.dao.TransientDataAccessResourceException: \\n### Error querying database.  Cause: java.sql.SQLException: Streaming result set com.mysql.cj.protocol.a.result.ResultsetRowsStreaming@4d221f7a 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.\\n### The error may exist in alfresco/ibatis/#resource.dialect#/permissions-common-SqlMap.xml\\n### The error may involve alfresco.permissions.parameter_IdMap\\n### The error occurred while setting parameters\\n### SQL: select             *         from             alf_access_control_list         where             id = ?\\n### Cause: java.sql.SQLException: Streaming result set com.mysql.cj.protocol.a.result.ResultsetRowsStreaming@4d221f7a 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.\\n; Streaming result set com.mysql.cj.protocol.a.result.ResultsetRowsStreaming@4d221f7a 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.; nested exception is java.sql.SQLException: Streaming result set com.mysql.cj.protocol.a.result.ResultsetRowsStreaming@4d221f7a 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.\\n### Cause: org.springframework.dao.TransientDataAccessResourceException: \\n### Error querying database.  Cause: java.sql.SQLException: Streaming result set com.mysql.cj.protocol.a.result.ResultsetRowsStreaming@4d221f7a 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.\\n### The error may exist in alfresco/ibatis/#resource.dialect#/permissions-common-SqlMap.xml\\n### The error may involve alfresco.permissions.parameter_IdMap\\n### The error occurred while setting parameters\\n### SQL: select             *         from             alf_access_control_list         where             id = ?\\n### Cause: java.sql.SQLException: Streaming result set com.mysql.cj.protocol.a.result.ResultsetRowsStreaming@4d221f7a 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.\\n; Streaming result set com.mysql.cj.protocol.a.result.ResultsetRowsStreaming@4d221f7a 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.; nested exception is java.sql.SQLException: Streaming result set com.mysql.cj.protocol.a.result.ResultsetRowsStreaming@4d221f7a 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.\",\"stackTrace\":\"For security reasons the stack trace is no longer displayed, but the property is kept for previous versions\",\"descriptionURL

0 REPLIES 0