Hi Richard, Thank you for surfacing this issue, Could you please create a bug ticket here https://issues.apache.org/jira/projects/FINERACT/issues/FINERACT-852?filter=allopenissues
It would be really helpful if you could provide the reproducible steps as well while describing the issue PS: Iooping in the Fineract community dev list as well as this ticket is related to fineract issue Regards, Bharath Lead Implementation Analyst | Mifos Initiative Skype: live:cbharath4| Mobile: +91.7019635592 http://mifos.org <http://facebook.com/mifos> <http://www.twitter.com/mifos> On Fri, Jan 27, 2023 at 3:56 PM Richard Matovu <rmatovu...@gmail.com> wrote: > Hello, > > I am using postgres database, and when I create more than one tax > components, and I try to fetch them, I get this error message: > > 2023-01-27 12:36:18.466 -ERROR 29508 --- [io2-8443-exec-5] > .a.c.c.C.[.[.[.[.a.f.i.c.c.JerseyConfig] : Servlet.service() for servlet > [org.apache.fineract.infrastructure.core.config.JerseyConfig] in context > with path [/fineract-provider] threw exception > [org.springframework.jdbc.UncategorizedSQLException: StatementCallback; > uncategorized SQLException for SQL [select tc.id as id, tc.name as > name,tc.percentage as percentage, tc.start_date as > startDate,tc.debit_account_type_enum as debitAccountTypeEnum,dgl.id as > debitAccountId, dgl.name as debitAccountName, dgl.gl_code as > debitAccountGlCode,tc.credit_account_type_enum as creditAccountTypeEnum, > cgl.id as creditAccountId, cgl.name as creditAccountName, cgl.gl_code as > creditAccountGlCode,history.percentage as historyPercentage, > history.start_date as historyStartDate,history.end_date as historyEndDate > from m_tax_component tc left join acc_gl_account dgl on dgl.id = > tc.debit_account_id left join acc_gl_account cgl on cgl.id = > tc.credit_account_id left join m_tax_component_history history on > history.tax_component_id = tc.id]; SQL state [24000]; error code [0]; > Operation requires a scrollable ResultSet, but this ResultSet is > FORWARD_ONLY.; nested exception is org.postgresql.util.PSQLException: > Operation requires a scrollable ResultSet, but this ResultSet is > FORWARD_ONLY.] with root cause > > org.postgresql.util.PSQLException: Operation requires a scrollable > ResultSet, but this ResultSet is FORWARD_ONLY. > at > org.postgresql.jdbc.PgResultSet.checkScrollable(PgResultSet.java:316) > at org.postgresql.jdbc.PgResultSet.previous(PgResultSet.java:993) > at > com.zaxxer.hikari.pool.HikariProxyResultSet.previous(HikariProxyResultSet.java) > at > org.apache.fineract.portfolio.tax.service.TaxReadPlatformServiceImpl$TaxComponentMapper.mapRow(TaxReadPlatformServiceImpl.java:173) > at > org.apache.fineract.portfolio.tax.service.TaxReadPlatformServiceImpl$TaxComponentMapper.mapRow(TaxReadPlatformServiceImpl.java:112) > at > org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:94) > at > org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:61) > at > org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:453) > at > org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381) > at > org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:465) > at > org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:475) > at > org.apache.fineract.portfolio.tax.service.TaxReadPlatformServiceImpl.retrieveAllTaxComponents(TaxReadPlatformServiceImpl.java:62) > at > org.apache.fineract.portfolio.tax.api.TaxComponentApiResource.retrieveAllTaxComponents(TaxComponentApiResource.java:92) > at > java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) > at > java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) > at > java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > > What could be the issue? > > > -- > Thank you and regards. > > Matovu Fulugensio Richard > +256 754 279198 > +256 778 393611 > Mifos-developer mailing list > mifos-develo...@lists.sourceforge.net > Unsubscribe or change settings at: > https://lists.sourceforge.net/lists/listinfo/mifos-developer
