[
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)
