Uploaded image for project: 'Apache Fineract'
  1. Apache Fineract
  2. FINERACT-1089

Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY in InterestRateChartReadPlatformServiceImpl

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: In Progress
    • Priority: Blocker
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: 1.5.0
    • Component/s: None
    • Labels:
      None

      Description

      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:

      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)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                BLasan Benura Abeywardena
                Reporter:
                vorburger Michael Vorburger
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated: