如何解决执行SQL查询时出现的‘FROM keyword not found where expected’错误？

Let's get this sorted out—this error almost always boils down to missing spaces in your string-concatenated SQL that's causing keywords to merge with adjacent text, making the database unable to parse the query correctly.

What's Causing the Issue? #

Looking at your query string, there are multiple spots where you're joining string fragments without adding spaces, which leads to invalid syntax. For example:

• "branch_id" + "from" becomes branch_idfrom (the database sees this as a single invalid identifier instead of recognizing FROM as a keyword)
• "b.session_id" + "and" becomes b.session_idand (merging a column name with the AND keyword)
• "?" + "and" becomes ?and (binding parameter glued to the next keyword)

Step-by-Step Fix #

First, add spaces where needed in your string concatenation to separate keywords, column names, and parameters. Here's the corrected version of your query:

String query = "select bc.institution_code, bc.branch_code, tmp.order_channel, tmp.order_root_div, " 
             + "count(ls.session_id) as tenlogincount "
             + "from branch bc, login_session ls, "
             + "(select a.session_id, a.branch_id, b.order_channel, c.order_root_div "
             + "from (select session_id, property_value as branch_id "
             + "from login_session_property where property_name = 'branchID') a, "
             + "(select session_id, property_value as order_channel "
             + "from login_session_property where property_name = 'orderChannel') b, "
             + "(select session_id, property_value as order_root_div "
             + "from login_session_property where property_name = 'orderRootDiv') c "
             + "where a.session_id = b.session_id and b.session_id = c.session_id) tmp "
             + "where to_char(ls.creation_date, 'YYYY-MM-DD') = ? "
             + "and ls.type_id in (select type_id from login_type where type_name like '%customer_login_type%') "
             + "and ls.session_id = tmp.session_id and bc.branch_id = tmp.branch_id "
             + "and ((to_char(ls.creation_date,'HH24MI') <= ? and to_char(ls.last_update,'HH24MI') >= ? "
             + "and ls.validity <> 0) or (to_char(ls.creation_date,'HH24MI') <= ? "
             + "and to_char(ls.expiration_date,'HH24MI') >= ? and ls.validity = 0)) "
             + "group by bc.institution_code, bc.branch_code, tmp.order_channel, tmp.order_root_div";

Key changes made:

• Added spaces at the end/beginning of each string fragment to ensure keywords (like FROM, AND) and identifiers don't merge
• Formatted the query with line breaks for readability (this doesn't affect execution but makes it way easier to spot future issues)

Bonus: Improve Query Readability & Maintainability #

While fixing the spaces will resolve the error, I'd strongly recommend switching to explicit JOIN syntax instead of the old comma-separated table list. This makes your join logic clearer and reduces the chance of accidental syntax errors. Here's a snippet of how that would look for your subquery:

select a.session_id, a.branch_id, b.order_channel, c.order_root_div
from (select session_id, property_value as branch_id from login_session_property where property_name = 'branchID') a
join (select session_id, property_value as order_channel from login_session_property where property_name = 'orderChannel') b
  on a.session_id = b.session_id
join (select session_id, property_value as order_root_div from login_session_property where property_name = 'orderRootDiv') c
  on b.session_id = c.session_id

This is much easier to follow than mixing joins in the WHERE clause.

内容的提问来源于stack exchange，提问作者mhm1999