日常"/>
Java开发日常
文章目录
- 报错SQL
- 异常
- 解决
报错SQL
select b.TYPE_NAME SBIGTYPE_NAME, b.TYPE IBIGTYPE_TYPE, a.ID SSMALLTYPE_ID, a.SSMALLTYPE_NAME, a.DPLAN_AMOUNTALL FSMALLTYPE_PALN_AMOUNT, d.actual_amountall FSMALLTYPE_ACTUAL_AMOUNT
from HY_PROJECT_CAPITAL_SMALLTYPES a
left join HY_PROJECT_CAPITAL_BIGTYPE b on a.SBIGTYPE_ID = b.ID
left join (select c.SSMALL_TYPEID, sum(c.DACTUAL_AMOUNT) actual_amountall from HY_PROJECT_CAPITAL_DETAIL c where c.SPROJECT_ID = #{projectId,jdbcType=VARCHAR} group by c.SSMALL_TYPEID) d on d.SSMALL_TYPEID = a.ID
order by a.TADD_TIME asc;
异常
### Cause: java.sql.SQLSyntaxErrorException: ORA-00911: 无效字符; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00911: 无效字符
解决
异常信息其实说得很清楚,【;】错误的SQL语法。删除SQL语句结尾的【;】即可。
更多推荐
Java开发日常
发布评论