[jira] [Commented] (FINERACT-1089) Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY in InterestRateChartReadPlatformServiceImpl
[
https://issues.apache.org/jira/browse/FINERACT-1089?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17377716#comment-17377716
]
Petri Tuomola commented on FINERACT-1089:
-
Hi [~victorjo] - yes, that should work as well - thanks for the suggestion! Do
you want to submit a pull request that fixes this?
> 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: Benura Abeywardena
>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
>
[jira] [Comment Edited] (FINERACT-1089) Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY in InterestRateChartReadPlatformServiceImpl
[
https://issues.apache.org/jira/browse/FINERACT-1089?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17377267#comment-17377267
]
Victor Jo edited comment on FINERACT-1089 at 7/8/21, 9:50 AM:
--
Hi [~vorburger] ,
I added a different return statement on the {{{color:#172b4d}_public
Collection retrieveAllWithSlabs(Long productId)_
{color}}}method:
{code:java}
// return this.jdbcTemplate.query(sql.toString(), this.chartExtractor, new
Object[] {productId});
return this.jdbcTemplate.query(
con -> con.prepareStatement(sql.toString(),
ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE),
ps -> ps.setLong(1, productId),
this.chartExtractor
);{code}
Would this suffice as a fix ?
P.S I'm using the MYSQL Driver and running on mysql 8.0.23.
was (Author: victorjo):
Hi [~vorburger] ,
I added a different return statement on the {{{color:#172b4d}_public
Collection retrieveAllWithSlabs(Long productId)_
{color}}}method:
{code:java}
// return this.jdbcTemplate.query(sql.toString(), this.chartExtractor, new
Object[] {productId});
return this.jdbcTemplate.query(
con -> con.prepareStatement(sql.toString(),
ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE),
ps -> ps.setLong(1, productId),
this.chartExtractor
);{code}
Would this suffice as a fix ?
> 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: Benura Abeywardena
>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
>
[jira] [Commented] (FINERACT-1089) Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY in InterestRateChartReadPlatformServiceImpl
[
https://issues.apache.org/jira/browse/FINERACT-1089?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17377267#comment-17377267
]
Victor Jo commented on FINERACT-1089:
-
Hi [~vorburger] ,
I added a different return statement on the {{{color:#172b4d}_public
Collection retrieveAllWithSlabs(Long productId)_
{color}}}method:
{code:java}
// return this.jdbcTemplate.query(sql.toString(), this.chartExtractor, new
Object[] {productId});
return this.jdbcTemplate.query(
con -> con.prepareStatement(sql.toString(),
ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE),
ps -> ps.setLong(1, productId),
this.chartExtractor
);{code}
Would this suffice as a fix ?
> 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: Benura Abeywardena
>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
>
[jira] [Updated] (FINCN-328) Offline-first support in Teller functionalities
[ https://issues.apache.org/jira/browse/FINCN-328?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Varun Jain updated FINCN-328: - Labels: gsoc2021 pull-request-available (was: gsoc2021) > Offline-first support in Teller functionalities > > > Key: FINCN-328 > URL: https://issues.apache.org/jira/browse/FINCN-328 > Project: Fineract Cloud Native > Issue Type: Improvement > Components: fineract-cn-mobile > Environment: Android studio, ubuntu >Reporter: Varun Jain >Priority: Major > Labels: gsoc2021, pull-request-available > > The objective is to extend the offline-first approach in the Application by > replacing the currently implemented REST API Interaction with the > Couchbase-only interaction. > With Couchbase implementation, field officers will be able to update data > with the mobile application even when there is no network connectivity and > the data will be stored in the mobile database(Couchbase-lite database), > which will then be synced with the couchbase-server as soon as the network > connection is available, using sync-gateway, that has been implemented in the > PR. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (FINCN-334) Implement and integrate scoring with H2o.ai
Yemdjih Kaze Nasser created FINCN-334: - Summary: Implement and integrate scoring with H2o.ai Key: FINCN-334 URL: https://issues.apache.org/jira/browse/FINCN-334 Project: Fineract Cloud Native Issue Type: Sub-task Reporter: Yemdjih Kaze Nasser -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (FINCN-333) Create ML pipeline to auto-update ML scoring
Yemdjih Kaze Nasser created FINCN-333: - Summary: Create ML pipeline to auto-update ML scoring Key: FINCN-333 URL: https://issues.apache.org/jira/browse/FINCN-333 Project: Fineract Cloud Native Issue Type: Sub-task Reporter: Yemdjih Kaze Nasser Leverage airflow and airflow dags to build an ML pipeline to keep updating the ML models with time thus keeping it relevant. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (FINCN-332) Import Machine Learing scoring
Yemdjih Kaze Nasser created FINCN-332: - Summary: Import Machine Learing scoring Key: FINCN-332 URL: https://issues.apache.org/jira/browse/FINCN-332 Project: Fineract Cloud Native Issue Type: Sub-task Reporter: Yemdjih Kaze Nasser Import and implement and test machine learning scoring in the API module. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (FINCN-331) Import statistical scoring in the API
Yemdjih Kaze Nasser created FINCN-331: - Summary: Import statistical scoring in the API Key: FINCN-331 URL: https://issues.apache.org/jira/browse/FINCN-331 Project: Fineract Cloud Native Issue Type: Sub-task Reporter: Yemdjih Kaze Nasser Import and implement and test statistical scoring from last iteration. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (FINCN-330) Import rule based in the API.
Yemdjih Kaze Nasser created FINCN-330: - Summary: Import rule based in the API. Key: FINCN-330 URL: https://issues.apache.org/jira/browse/FINCN-330 Project: Fineract Cloud Native Issue Type: Sub-task Reporter: Yemdjih Kaze Nasser Import and implement and test rule based scoring in the API module -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (FINCN-329) Integrate scorecard configurations
Yemdjih Kaze Nasser created FINCN-329: - Summary: Integrate scorecard configurations Key: FINCN-329 URL: https://issues.apache.org/jira/browse/FINCN-329 Project: Fineract Cloud Native Issue Type: Sub-task Reporter: Yemdjih Kaze Nasser Migrate scorecard configurations from last years work into the new module -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (FINCN-328) Offline-first support in Teller functionalities
Varun Jain created FINCN-328: Summary: Offline-first support in Teller functionalities Key: FINCN-328 URL: https://issues.apache.org/jira/browse/FINCN-328 Project: Fineract Cloud Native Issue Type: Improvement Components: fineract-cn-mobile Environment: Android studio, ubuntu Reporter: Varun Jain The objective is to extend the offline-first approach in the Application by replacing the currently implemented REST API Interaction with the Couchbase-only interaction. With Couchbase implementation, field officers will be able to update data with the mobile application even when there is no network connectivity and the data will be stored in the mobile database(Couchbase-lite database), which will then be synced with the couchbase-server as soon as the network connection is available, using sync-gateway, that has been implemented in the PR. -- This message was sent by Atlassian Jira (v8.3.4#803005)
