[
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
