[
https://issues.apache.org/jira/browse/FINERACT-1625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17540624#comment-17540624
]
Francis Guchie commented on FINERACT-1625:
------------------------------------------
[~rrpawar] at a second look i notice that is the preparing of the statement
that breaks the code see below
Query being executed when exception was thrown:
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 ' true ' [see this
issue|https://issues.apache.org/jira/browse/FINERACT-1343]*
AND s.is_active = 1
AND o.hierarchy like '.%' order by s.lastname
> 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.7#820007)
