当前位置:编程学习 > JAVA >>

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 开发
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,