Uploaded image for project: 'Apache Fineract'
  1. Apache Fineract
  2. FINERACT-1061

Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY in ProductMixReadPlatformServiceImpl.retrieveAllProductMixes()

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.4.0
    • Component/s: None
    • Labels:

      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)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                ptuomola Petri Tuomola
                Reporter:
                vorburger Michael Vorburger
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: