A_eleven 2019-07-10 16:10 采纳率: 0%
浏览 2001
已结题

一个事务里面执行两个insert 语句 只有后面一个insert 被commit,请问大神怎么回事?

org.mybatis.spring.SqlSessionUtils 97 getSqlSession - Creating a new SqlSession
org.mybatis.spring.SqlSessionUtils 128 registerSessionHolder - Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7387309a]
org.mybatis.spring.transaction.SpringManagedTransaction 87 openConnection - JDBC Connection [1784195322, URL=jdbc:sqlserver://192.168.11.2:11433;authentication=NotSpecified;authenticationScheme=nativeAuthentication;xopenStates=false;sendTimeAsDatetime=true;trustServerCertificate=false;TransparentNetworkIPResolution=true;serverNameAsACE=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;packetSize=8000;multiSubnetFailover=false;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=zyscm;columnEncryptionSetting=Disabled;applicationName=Microsoft JDBC Driver for SQL Server;applicationIntent=readwrite;, UserName=sa, Microsoft JDBC Driver 6.0 for SQL Server] will be managed by Spring
org.apache.ibatis.logging.jdbc.BaseJdbcLogger 159 debug - ==> Preparing: {call P_SYS_GET_FNO (?,?)}
org.apache.ibatis.logging.jdbc.BaseJdbcLogger 159 debug - ==> Parameters: PI(String)
org.mybatis.spring.SqlSessionUtils 186 closeSqlSession - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7387309a]
org.mybatis.spring.SqlSessionUtils 163 sessionHolder - Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7387309a] from current transaction
org.mybatis.spring.SqlSessionUtils 186 closeSqlSession - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7387309a]
org.mybatis.spring.SqlSessionUtils 163 sessionHolder - Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7387309a] from current transaction
org.apache.ibatis.logging.jdbc.BaseJdbcLogger 159 debug - ==> Preparing: {call P_SYS_GET_FID (?)}
org.apache.ibatis.logging.jdbc.BaseJdbcLogger 159 debug - ==> Parameters:
org.mybatis.spring.SqlSessionUtils 186 closeSqlSession - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7387309a]
org.mybatis.spring.SqlSessionUtils 163 sessionHolder - Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7387309a] from current transaction
org.apache.ibatis.logging.jdbc.BaseJdbcLogger 159 debug - ==> Preparing: INSERT INTO T_IM_PURINMT(FID,FNUMBER,FDATE,FSALEMANID,FSTATUS,FREMARK,FCREATEUSERID,FLASTUPDATEUSERID) (SELECT ?,?,?,?,?,?,?,?)
org.apache.ibatis.logging.jdbc.BaseJdbcLogger 159 debug - ==> Parameters: 90000000000096(String), PI0000000095(String), 2019-07-10(String), U2NQUFIMMSK(String), 1(String), 4444(String), U2NQUFIMMSK(String), U2NQUFIMMSK(String)
org.apache.ibatis.logging.jdbc.BaseJdbcLogger 159 debug - <== Updates: 1
org.mybatis.spring.SqlSessionUtils 186 closeSqlSession - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7387309a]
org.mybatis.spring.SqlSessionUtils 163 sessionHolder - Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7387309a] from current transaction
org.mybatis.spring.SqlSessionUtils 186 closeSqlSession - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7387309a]
org.mybatis.spring.SqlSessionUtils 163 sessionHolder - Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7387309a] from current transaction
org.apache.ibatis.logging.jdbc.BaseJdbcLogger 159 debug - ==> Preparing: {call P_SYS_GET_FID (?)}
org.apache.ibatis.logging.jdbc.BaseJdbcLogger 159 debug - ==> Parameters:
org.mybatis.spring.SqlSessionUtils 186 closeSqlSession - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7387309a]
org.mybatis.spring.SqlSessionUtils 163 sessionHolder - Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7387309a] from current transaction
org.apache.ibatis.logging.jdbc.BaseJdbcLogger 159 debug - ==> Preparing: INSERT INTO T_IM_PURINDT(FID,FPARENTID,FPRODUCTID,FQTY,FPRICE,FREMARK) ( SELECT ?,?,?,?,?,? )
org.apache.ibatis.logging.jdbc.BaseJdbcLogger 159 debug - ==> Parameters: 90000000000097(String), 90000000000096(String), 90000000000045(String), 4444.00(BigDecimal), 4444.00(String), 4444(String)
org.apache.ibatis.logging.jdbc.BaseJdbcLogger 159 debug - <== Updates: 1
org.mybatis.spring.SqlSessionUtils 186 closeSqlSession - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7387309a]
org.mybatis.spring.SqlSessionUtils$SqlSessionSynchronization 284 beforeCommit - Transaction synchronization committing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7387309a]
org.mybatis.spring.SqlSessionUtils$SqlSessionSynchronization 310 beforeCompletion - Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7387309a]
org.mybatis.spring.SqlSessionUtils$SqlSessionSynchronization 315 beforeCompletion - Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@73873

  • 写回答

2条回答 默认 最新

  • 关注
    评论

报告相同问题?

悬赏问题

  • ¥15 孟德尔随机化结果不一致
  • ¥15 apm2.8飞控罗盘bad health,加速度计校准失败
  • ¥15 求解O-S方程的特征值问题给出边界层布拉休斯平行流的中性曲线
  • ¥15 谁有desed数据集呀
  • ¥20 手写数字识别运行c仿真时,程序报错错误代码sim211-100
  • ¥15 关于#hadoop#的问题
  • ¥15 (标签-Python|关键词-socket)
  • ¥15 keil里为什么main.c定义的函数在it.c调用不了
  • ¥50 切换TabTip键盘的输入法
  • ¥15 可否在不同线程中调用封装数据库操作的类