[ http://issues.apache.org/jira/browse/IBATIS-303?page=comments#action_12415157 ]
Sven Boden commented on IBATIS-303: ----------------------------------- I would suggest to take this to the iBATIS development list, this is more a support problem not an iBATIS issue. I will close this JIRA shortly as "invalid". You've answered you're own problem... use transactions. Something as: try { sqlMaps.startTransaction(); sqlMap.startBatch(); // map stuff Map args = CollectionUtil.createMap(2); for(int i=0;i<p_resultList.size();i++) { AdvancedSearchResultData resultData = (AdvancedSearchResultData)p_resultList.get(i); args.put("RESULT_DATA", resultData); args.put("UserIdentifier", p_userID); sqlMap.insert("insertIntoTempTable", args); } sqlMap.executeBatch(); sqlMap.commitTransaction(); } finally { sqlMap.endTransaction(); } Regards, Sven > SqlMapExecutor.executeBatch() returns 0 > --------------------------------------- > > Key: IBATIS-303 > URL: http://issues.apache.org/jira/browse/IBATIS-303 > Project: iBatis for Java > Type: Bug > Components: SQL Maps > Versions: 2.1.7 > Environment: Oracle 9, OCI driver > Reporter: george apostolov > > SqlMapExecutor.executeBatch() returns 0 on Oracle 9 using the oci jdbc driver. > I saw someone had the same issue before but this still seems to be a problem > Thanks, > George -- 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