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

["Michael Vorburger (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/FINERACT-1061?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17148130#comment-17148130 ] 

Michael Vorburger commented on FINERACT-1061:
---------------------------------------------

This is, of course, FINERACT-995 "again"... it took me a moment to realize that I had mixed up 2 separate issues back in FINERACT-995 - and [~ptuomola] fixed only 1 of them under that issue - perhaps someone would like to fix the other one under this?

[~xurror] or [~awasum] or anyone else interesting in contributing, do you want to pick this up?

> Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY in ProductMixReadPlatformServiceImpl.retrieveAllProductMixes()
> -----------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: FINERACT-1061
>                 URL: https://issues.apache.org/jira/browse/FINERACT-1061
>             Project: Apache Fineract
>          Issue Type: Bug
>            Reporter: Michael Vorburger
>            Priority: Blocker
>
> See FINERACT-932 for general background, and fix this problem:
> {code}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){code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)