Java开发日常-Mybatis报错：java.sql.SQLSyntaxErrorException: ORA-00911: 无效字符

报错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语句结尾的【;】即可。