Java开发日常

日常"/>

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