You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@fineract.apache.org by "Francis Guchie (Jira)" <ji...@apache.org> on 2022/07/08 09:53:00 UTC
[jira] [Commented] (FINERACT-1625) Slow Query Error(s) - PreparedStatementCallback; bad SQL grammar
[ https://issues.apache.org/jira/browse/FINERACT-1625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17564205#comment-17564205 ]
Francis Guchie commented on FINERACT-1625:
------------------------------------------
[~josemakara]
i think the prepared statements are causing an issue coming from this [PULL REQUEST 1687|https://github.com/apache/fineract/pull/1687]
> Slow Query Error(s) - PreparedStatementCallback; bad SQL grammar
> -----------------------------------------------------------------
>
> Key: FINERACT-1625
> URL: https://issues.apache.org/jira/browse/FINERACT-1625
> Project: Apache Fineract
> Issue Type: Bug
> Reporter: Francis Guchie
> Assignee: Rahul Pawar
> Priority: Major
>
> This is one of the Slow query errors i have noticed in the logs
> bad SQL grammar [select s.id as id,s.office_id as officeId, o.name as officeName, s.firstname as firstname, s.lastname as lastname, s.display_name as displayName, s.is_loan_officer as isLoanOfficer, s.external_id as externalId, s.mobile_no as mobileNo, s.is_active as isActive, s.joining_date as joiningDate from m_staff s join m_office o on o.id = s.office_id WHERE s.is_loan_officer is ? AND s.is_active = ? AND o.hierarchy like ? order by s.lastname ]; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' true ' AND s.is_active = 1 AND o.hierarchy like '.%' order by s.lastname' at line 1
--
This message was sent by Atlassian Jira
(v8.20.10#820010)