spring transaction
ooo Using Connection [JeusConnection@1f681f68[PHY_ID=jdbc/aof-19,actual=oracle.jdbc.driver.LogicalConnection@1f3c1f3c]]11:45:35,640 DEBUG [insert] ==> Preparing: /* MemberMapper.insert */ INSERT INTO cs_member ( cs_member_seq ,cs_member_id ,cs_member_name ,cs_nickname ,cs_status_cd ,cs_password ,cs_addr_seq ,cs_phone_seq ,cs_photo_seq ,cs_reg_member_seq ,cs_reg_dtime ,cs_upd_member_seq ,cs_upd_dtime ,cx_member_gender ,cx_member_birthday ,cx_member_email ,cx_addition_seq ) VALUES ( ? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,FN_NOW_TO_CHAR() ,? ,FN_NOW_TO_CHAR() ,? ,? ,? ,? )
11:45:35,641 DEBUG [insert] ==> Parameters: 16(Long), test22(String), test22(String), null, approval(String), 8e59a08ba401da8aedd958b3a65c2d8e70dc8da2(String), null, 14(Long), null, 1(Long), 1(Long), M(String), 1980.01.01(String), test22@test22.com(String), null
11:45:35,646 DEBUG [countMemberSeq] ooo Using Connection [JeusConnection@1f681f68[PHY_ID=jdbc/aof-19,actual=oracle.jdbc.driver.LogicalConnection@1f3c1f3c]]
11:45:35,647 DEBUG [countMemberSeq] ==> Preparing: /* RolegroupMemberMapper.countMemberSeq */ SELECT COUNT(*) FROM cs_rolegroup_member WHERE cs_rolegroup_seq = ? AND cs_member_seq = ?
11:45:35,648 DEBUG [countMemberSeq] ==> Parameters: 2(Long), 16(Long)
11:45:35,650 DEBUG [insert] ooo Using Connection [JeusConnection@1f681f68[PHY_ID=jdbc/aof-19,actual=oracle.jdbc.driver.LogicalConnection@1f3c1f3c]]
11:45:35,650 DEBUG [insert] ==> Preparing: /* RolegroupMemberMapper.insert */ INSERT INTO cs_rolegroup_member ( cs_rolegroup_seq ,cs_member_seq ,cs_reg_member_seq ,cs_reg_dtime ,cs_upd_member_seq ,cs_upd_dtime ) VALUES ( ? ,? ,? ,FN_NOW_TO_CHAR() ,? ,FN_NOW_TO_CHAR() )
11:45:35,669 DEBUG [insert] ==> Parameters: 2(Long), 16(Long), 1(Long), 1(Long)
11:45:35,720 INFO [SQLErrorCodesFactory] SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
11:45:35,720 DEBUG [SQLErrorCodesFactory] Looking up default SQLErrorCodes for DataSource [jdbc/aof;shareable=true]
11:45:35,724 DEBUG [SQLErrorCodesFactory] Database product name cached for DataSource [jeus.jdbc.connectionpool.DataSourceWrapper@60386038]: name is 'Oracle'
11:45:35,724 DEBUG [SQLErrorCodesFactory] SQL error codes for 'Oracle' found
11:45:35,725 DEBUG [SQLErrorCodeSQLExceptionTranslator] Unable to translate SQLException with Error code '17090', will now try the fallback translator
11:45:35,725 DEBUG [SQLStateSQLExceptionTranslator] Extracted SQL state class '99' from value '99999'
11:45:35,728 DEBUG [DataSourceTransactionManager] Initiating transaction rollback
spring mybatis oracle11g Erro 单个insert没有问题,当一次插入多个时 会出现 transaction rollback 但是如上所显示先 insert cs_member 然后生成的cs_member_seq(sequences生成) insert到 cs_rolegroup_member中,sql运行很顺利但是 transaction commit不了
当重复插入cs_member_seq(已存在的时候) 就可以insert transaction commit正常
但是cs_member_seq 是主键且由sequences生成不能重复,这种情况很奇怪以前从来没见过,折腾的几天没解决,恳请大家帮过忙 找出什么问题 spring mybatis oracle
补充:Java , Web 开发