Michael Vorburger created FINERACT-1089:
-------------------------------------------
Summary: 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
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)
