[ https://issues.apache.org/jira/browse/FINERACT-1089?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17159335#comment-17159335 ]
Percy Ashu commented on FINERACT-1089: -------------------------------------- Thanks for the pointer [~ptuomola] will look into it an send a PR > Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY in > InterestRateChartReadPlatformServiceImpl > ---------------------------------------------------------------------------------------------------------------------- > > Key: FINERACT-1089 > URL: https://issues.apache.org/jira/browse/FINERACT-1089 > Project: Apache Fineract > Issue Type: Bug > Reporter: Michael Vorburger > Assignee: Percy Ashu > Priority: Blocker > > See FINERACT-932 for general background; I've found this in logs of > https://www.fineract.dev, this seems to be a similar problem to that was > previously fixed in FINERACT-995 and FINERACT-1061: > {noformat} > org.springframework.dao.TransientDataAccessResourceException: > PreparedStatementCallback; SQL [select irc.id as ircId, irc.name as ircName, > irc.description as ircDescription,irc.from_date as ircFromDate, irc.end_date > as ircEndDate, irc.is_primary_grouping_by_amount as > isPrimaryGroupingByAmount, ircd.id as ircdId, ircd.description as > ircdDescription, ircd.period_type_enum ircdPeriodTypeId, ircd.from_period as > ircdFromPeriod, ircd.to_period as ircdToPeriod, ircd.amount_range_from as > ircdAmountRangeFrom, ircd.amount_range_to as ircdAmountRangeTo, > ircd.annual_interest_rate as ircdAnnualInterestRate, curr.code as > currencyCode, curr.name as currencyName, curr.internationalized_name_code as > currencyNameCode, curr.display_symbol as currencyDisplaySymbol, > curr.decimal_places as currencyDigits, curr.currency_multiplesof as > inMultiplesOf, sp.id as savingsProductId, sp.name as savingsProductName, > iri.id as iriId, iri.entiry_type as entityType, iri.attribute_name as > attributeName , iri.condition_type as conditionType, iri.attribute_value as > attributeValue, iri.incentive_type as incentiveType, iri.amount as amount, > code.code_value as attributeValueDesc from m_interest_rate_chart irc left > join m_interest_rate_slab ircd on irc.id=ircd.interest_rate_chart_id left > join m_interest_incentives iri on iri.interest_rate_slab_id = ircd.id left > join m_code_value code on code.id = iri.attribute_value left join m_currency > curr on ircd.currency_code= curr.code left join > m_deposit_product_interest_rate_chart dpirc on > irc.id=dpirc.interest_rate_chart_id left join m_savings_product sp on > sp.id=dpirc.deposit_product_id where sp.id = ? order by irc.id, CASE WHEN > isPrimaryGroupingByAmount then ircd.amount_range_from WHEN > isPrimaryGroupingByAmount then ircd.amount_range_to END,ircd.from_period, > ircd.to_period,CASE WHEN !isPrimaryGroupingByAmount then > ircd.amount_range_from WHEN !isPrimaryGroupingByAmount then > ircd.amount_range_to END]; 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.interestratechart.service.InterestRateChartReadPlatformServiceImpl.retrieveAllWithSlabs > (InterestRateChartReadPlatformServiceImpl.java:102) > Caused by: java.sql.SQLException: Operation not allowed for a result set of > type ResultSet.TYPE_FORWARD_ONLY. > at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException > (SQLError.java:129) > at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException > (SQLError.java:97) > at > com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException > (SQLExceptionsMapping.java:122) > at com.mysql.cj.jdbc.result.ResultSetImpl.previous > (ResultSetImpl.java:1806) > at com.zaxxer.hikari.pool.HikariProxyResultSet.previous > (HikariProxyResultSet.java){noformat} -- This message was sent by Atlassian Jira (v8.3.4#803005)