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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-29-2024 05:12 AM
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
- Labels:
-
Alfresco Content Services
