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

Gordon_Ye — Tue, 29 Oct 2024 09:12:44 GMT

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

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

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