[
https://issues.apache.org/jira/browse/FINERACT-1089?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Petri Tuomola reassigned FINERACT-1089:
---------------------------------------
Assignee: Petri Tuomola (was: Benura Abeywardena)
> 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: Petri Tuomola
> Priority: Blocker
> Fix For: 1.6.0
>
>
> 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.20.1#820001)
