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

Question

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

Answer 1

https://blog.csdn.net/tuntunwang/article/details/21741345