原因很可能是sql语句中换行时没有空格,导致第一行和第二行成为一个字符串
例如:
错误写法:
String sql = "select department_id departmentId,department_name departmentName" +
"from departments d where d.location_id = ?";
报错信息如下:
java.sql.SQLException: ORA-00923: 未找到要求的 FROM 关键字
Query: select department_id departmentId,department_name departmentNamefrom departments d where d.location_id = ? Parameters: [1200]
String sql = "select department_id departmentId,department_name departmentName " +
"from departments d where d.location_id = ?";
切记:在sql语句中换行时要记得用空格隔开!