[
https://issues.apache.org/jira/browse/FINERACT-1061?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17148133#comment-17148133
]
Michael Vorburger commented on FINERACT-1061:
---------------------------------------------
The problem here actually isn't in
{{ProductMixReadPlatformServiceImpl.retrieveAllProductMixes}} but probably that
{{rs.beforeFirst();}} inside
{{org.apache.fineract.portfolio.loanproduct.productmix.service.ProductMixReadPlatformServiceImpl.ProductMixDataExtractor.extractData(ResultSet)}}
... but I don't understand why that code is "jumping backwards" like that -
from a quick first look, that doesn't make any sense, to me.
> 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
> Labels: beginner
> Fix For: 1.4.0
>
>
> 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)
