[ http://issues.apache.org/jira/browse/IBATIS-113?page=comments#action_12315190 ]
DongGuk Lee commented on IBATIS-113: ------------------------------------ Because My JDBC Driver problem.. sorry.. !! close this issue. > i want.. to rollback entire operations > -------------------------------------- > > Key: IBATIS-113 > URL: http://issues.apache.org/jira/browse/IBATIS-113 > Project: iBatis for Java > Type: Wish > Components: SQL Maps > Versions: 2.0.9 > Reporter: DongGuk Lee > > >> SQL Map config file(SqlMapConfig.xml) > <?xml version="1.0" encoding="UTF-8" ?> > <!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN" > "http://www.ibatis.com/dtd/sql-map-config-2.dtd"> > <sqlMapConfig> > <properties resource="kr/or/openframework/SqlMapConfig.properties" /> > <settings cacheModelsEnabled="true" enhancementEnabled="true" > lazyLoadingEnabled="true" maxRequests="32" maxSessions="10" > maxTransactions="5" useStatementNamespaces="false" /> > <typeAlias alias="guest" type="kr.or.openframework.guestboard.vo.Guest" > /> > > <transactionManager type="JDBC" commitRequired="true"> > <dataSource type="DBCP"> > <property name="JDBC.Driver" value="${driver}" /> > <property name="JDBC.ConnectionURL" value="${url}" /> > <property name="JDBC.Username" value="${username}" /> > <property name="JDBC.Password" value="${password}" /> > <property name="JDBC.DefaultAutoCommit" value="false" /> > <property name="Pool.MaximumActiveConnections" > value="10" /> > <property name="Pool.MaximumIdleConnections" value="5" > /> > <property name="Pool.MaximumCheckoutTime" > value="120000" /> > <property name="Pool.TimeToWait" value="500" /> > </dataSource> > </transactionManager> > <sqlMap resource="kr/or/openframework/guestboard/Guest.xml" /> > </sqlMapConfig> > >> SQL Map XML file > ..... > <insert id="insertGuest" parameterMap="guestParam"> > insert into guestboard(NUM, TITLE, CONTENT, WRITER, PASSWD, WRITEDAY) > values(?,?,?,?,?,?) > </insert> > ..... > >> java source code > .... > public int insertGuest(Guest guest) throws Exception { > SqlMapClient sqlMap = null; > Guest resultguest = null; > try { > sqlMap = getSqlMapConfig(); > sqlMap.startTransaction(); > > guest.setWriteday(CommonUtil.getCurrentDate()); > resultguest = (Guest) sqlMap.insert("insertGuest", guest); > resultguest = (Guest) sqlMap.insert("insertGuest", guest); > sqlMap.commitTransaction(); > return 1; > } catch (Exception e) { > logger.fatal(e.toString()); > throw e; > } finally { > sqlMap.endTransaction(); > } > } > .... > my source code has two insert operations. > my application throw SQLException(duplicate key value) because first insert > operation and second insert operation has same data. > operation result is .. > first operation has committed and second operation has rollback. > i want to rollback first operation and second operation > how can i process..? -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira