com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in ../classes/cn/cucsi/xml/H1DataDeal.xml.
--- The error occurred while applying a parameter map.
--- Check the cfupdate-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: ORA-00900: invalid SQL statement
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:107)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExecutorDelegate.java:457)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.update(SqlMapSessionImpl.java:90)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.update(SqlMapSessionImpl.java:94)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.update(SqlMapClientImpl.java:70)
at cn.cucsi.dao.IndexTaskDAO.cfupdate(IndexTaskDAO.java:450)
at cn.cucsi.timer.Cuofan.work(Cuofan.java:57)
at cn.cucsi.action.IndexTask.exe(IndexTask.java:53)
at cn.cucsi.action.IndexTask.executeInternal(IndexTask.java:30)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: java.sql.SQLException: ORA-00900: invalid SQL statement
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1983)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1141)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2149)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2032)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2894)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:684)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedStatementLogProxy.java:62)
at $Proxy150.execute(Unknown Source)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:80)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteUpdate(MappedStatement.java:216)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:94)
... 11 more
提示是无效的SQL语句，看看xml文件中id为cfupdate的语句，是SQL写错了，或者是对应的resultMap有问题。追问
sql没问题。输出后放在PLSQL中执行正常，那个resultMap怎么看是什么问题或者怎么解决呢？
追答你看看你在resultMap中的字段是不是在查询语句中都有查询到。使用resultMap的时候，查询语句的字段可以比resultMap映射的多，但是resultMap映射不能比查询的字段多。
像下面这种情况就会出错。
select id,name
from table1
我这个是update的sql，select的没问题。
<![CDATA[
$sql$
]]>
</statement>
像你这种语句，就不能这么写了吧。
你试试上面那么写好使不。
我们项目里是用的statement语句是好使的。
