Francis Guchie created FINERACT-1625:
----------------------------------------
Summary: 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
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)
