[
https://issues.apache.org/jira/browse/FINERACT-1625?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Francis Guchie reassigned FINERACT-1625:
----------------------------------------
Assignee: Francis Guchie
> 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: Francis Guchie
> 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.7#820007)
