[FINERACT-1061] Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY in ProductMixReadPlatformServiceImpl.retrieveAllProductMixes()

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Fix Version/s: 1.4.0
• Labels: beginner
• Assignee: Petri Tuomola
• Reporter: Michael Vorburger
• Created: 29/Jun/20 20:51
• Updated: 01/Jul/20 20:31
• Resolved: 01/Jul/20 20:31

Description

See FINERACT-932 for general background, and fix this problem:

org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [Select pm.product_id as productId, lp.name as name from m_product_mix pm join m_product_loan lp on lp.id=pm.product_id group by pm.product_id]; Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY.; nested exception is java.sql.SQLException: Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY.

        at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate (SQLStateSQLExceptionTranslator.java:110)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate (AbstractFallbackSQLExceptionTranslator.java:72)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate (AbstractFallbackSQLExceptionTranslator.java:81)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate (AbstractFallbackSQLExceptionTranslator.java:81)
        at org.springframework.jdbc.core.JdbcTemplate.translateException (JdbcTemplate.java:1443)
        at org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:633)
        at org.springframework.jdbc.core.JdbcTemplate.query (JdbcTemplate.java:669)
        at org.springframework.jdbc.core.JdbcTemplate.query (JdbcTemplate.java:700)
        at org.springframework.jdbc.core.JdbcTemplate.query (JdbcTemplate.java:718)
        at org.apache.fineract.portfolio.loanproduct.productmix.service.ProductMixReadPlatformServiceImpl.retrieveAllProductMixes (ProductMixReadPlatformServiceImpl.java:82)

Issue Links

• blocks: FINERACT-932 Parent Issue for Error Logs seeing during "normal" usage (e.g. on fineract.dev)
• links to: GitHub Pull Request #1128