mysql查询报错2014_ssh项目里，关于mysql的date_add()函数查询报错，请大神看看

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

如题，我打断点拿到拼出来的语句，请大神帮忙看看这个函数为啥报错，谢了

update LmLoan l

set curGenOdIntDt=CONCAT(date_add( str_to_date(curGenOdIntDt,*%Y-%m-%d*),INTERVAL 1*paymFreqFreq MONTH))

where l.loanSts=*ACTV*

and curGenOdIntDt is not null

and loanDebtSts=*OVER*

and curGenOdIntDt

and paymFreqUnit=*M*。

项目之前用的oracle，现在换项目组，用的mysql，很多函数都是临时查的修改的，这个实在是不知道怎么解决了。

报错如下：

2014-08-07 17:17:05,579 ERROR org.hibernate.hql.PARSER - line 1:134: unexpected token: 1

2014-08-07 17:17:05,580 ERROR org.hibernate.hql.PARSER - line 1:149: unexpected token: MONTH

org.hibernate.hql.ast.QuerySyntaxException: unexpected token: 1 near line 1, column 134 [ update com.yuchengtech.ycloans.db.domain.LmLoan l set curGenOdIntDt=CONCAT(date_add( str_to_date(curGenOdIntDt,*%Y-%m-%d*),INTERVAL 1*paymFreqFreq MONTH)) where l.loanSts=*ACTV* and curGenOdIntDt is not null and loanDebtSts=*OVER* and curGenOdIntDt and paymFreqUnit=?]

at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:31)

at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:24)

at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59)

at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:258)

at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:157)

at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)

at org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:77)

at org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:56)