spring update语句

[bridgemiao]

spring dao mycombtis都配置好了为什么update 不成功

Dao
public int getPgyjUpdate(@Param("YZ")String YZ,@Param("FIELDNAME")String FIELDNAME)

SQL
<!--暴雨启动条件更改 -->
<update id="getPgyjUpdate" parameterType="java.lang.String">
<![CDATA[
update NUIST_ESTIMATE_STARTER t set
t.YZ = #{YZ}
where t.FIELDNAME = #{FIELDNAME}
]]>
</update>

DEBUG [org.springframework.jdbc.datasource.DataSourceUtils doGetConnection] - Fetching JDBC Connection from DataSource
2015-05-11 20:57:15.858 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils doGetConnection] - Registering transaction synchronization for JDBC Connection
2015-05-11 20:57:15.858 DEBUG [org.apache.ibatis.logging.slf4j.Slf4jImpl debug] - Creating SqlSession from SqlSessionFactory
2015-05-11 20:57:15.858 DEBUG [org.apache.ibatis.logging.slf4j.Slf4jImpl debug] - ooo Connection Opened
2015-05-11 20:57:15.859 DEBUG [org.apache.ibatis.logging.slf4j.Slf4jImpl debug] - Registering transaction synchronization for SqlSession
2015-05-11 20:57:15.872 DEBUG [org.apache.ibatis.logging.slf4j.Slf4jImpl debug] - ==> Executing: update NUIST_ESTIMATE_STARTER t set t.YZ = ? where t.FIELDNAME = ?
2015-05-11 20:57:15.873 DEBUG [org.apache.ibatis.logging.slf4j.Slf4jImpl debug] - ==> Parameters: 30,20,30,40,20(String), PRE(String)
DEBUG [org.springframework.jdbc.datasource.DataSourceUtils doReleaseConnection] - Returning JDBC Connection to DataSource
2015-05-11 20:57:19.091 DEBUG [org.apache.ibatis.logging.slf4j.Slf4jImpl debug] - Transaction synchronization closed SqlSession

[bridgemiao]

之前的update语句执行都是可以的 执行代码 为什么新的不能创建spring事物 DEBUG [com.opensymphony.xwork2.util.logging.commons.CommonsLogger debug] - Executing action method = updatezbdj 2015-05-11 20:58:16.814 DEBUG [org.springframework.transaction.support.AbstractPlatformTransactionManager getTransaction] - Creating new transaction with name [com.msis.service.PgyjQueryServiceImpl.updatezbdj]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT,-java.lang.Exception 2015-05-11 20:58:17.293 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager doBegin] - Acquired Connection [jdbc:oracle:thin:@172.16.105.242:1521:orcl, UserName=SCOTT, Oracle JDBC driver] for JDBC transaction 2015-05-11 20:58:17.294 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager doBegin] - Switching JDBC Connection [jdbc:oracle:thin:@172.16.105.242:1521:orcl, UserName=SCOTT, Oracle JDBC driver] to manual commit 2015-05-11 20:58:17.295 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils doGetConnection] - Fetching JDBC Connection from DataSource 2015-05-11 20:58:17.295 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils doGetConnection] - Registering transaction synchronization for JDBC Connection 2015-05-11 20:58:17.295 DEBUG [org.apache.ibatis.logging.slf4j.Slf4jImpl debug] - Creating SqlSession from SqlSessionFactory 2015-05-11 20:58:17.296 DEBUG [org.apache.ibatis.logging.slf4j.Slf4jImpl debug] - ooo Connection Opened 2015-05-11 20:58:17.305 DEBUG [org.apache.ibatis.logging.slf4j.Slf4jImpl debug] - Registering transaction synchronization for SqlSession 2015-05-11 20:58:17.318 DEBUG [org.apache.ibatis.logging.slf4j.Slf4jImpl debug] - ==> Executing: update EVALUATIONSYSTEM set weather = ?, disastertype= ?, industry=?, disasterlevel = ?, threshold = ?, description=? where weather =? and disastertype=? and industry=? and disasterlevel=? and threshold=? and description =? 2015-05-11 20:58:17.318 DEBUG [org.apache.ibatis.logging.slf4j.Slf4jImpl debug] - ==> Parameters: 暴雨(String), 农田渍涝(String), 设施农业(String), 1(String), 10(String), 部分排水不良设施农业出现损失，影响较小(String), 暴雨(String), 农田渍涝(String), 设施农业(String), 1(String), 11(String), 部分排水不良设施农业出现损失，影响较小(String) 2015-05-11 20:58:17.389 DEBUG [org.springframework.transaction.support.AbstractPlatformTransactionManager processCommit] - Initiating transaction commit 2015-05-11 20:58:17.390 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager doCommit] - Committing JDBC transaction on Connection [jdbc:oracle:thin:@172.16.105.242:1521:orcl, UserName=SCOTT, Oracle JDBC driver] 2015-05-11 20:58:17.411 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils doReleaseConnection] - Returning JDBC Connection to DataSource 2015-05-11 20:58:17.411 DEBUG [org.apache.ibatis.logging.slf4j.Slf4jImpl debug] - Transaction synchronization committed SqlSession 2015-05-11 20:58:17.412 DEBUG [org.apache.ibatis.logging.slf4j.Slf4jImpl debug] - xxx Connection Closed