You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Brandon Goodin (JIRA)" <ib...@incubator.apache.org> on 2005/07/07 01:44:11 UTC
[jira] Closed: (IBATIS-113) i want.. to rollback entire operations
[ http://issues.apache.org/jira/browse/IBATIS-113?page=all ]
Brandon Goodin closed IBATIS-113:
---------------------------------
Resolution: Won't Fix
Closed at submitters request. Driver problem... not related to iBatis code.
> 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