[ http://issues.apache.org/jira/browse/IBATIS-261?page=comments#action_12367105 ]
Sven Boden commented on IBATIS-261: ----------------------------------- Can you also attach the SqlMaps you use (e.g. from the insertBatchError). From experience I know that Oracle places some very heavy restrictions on the return code of an update in a batch. You will very likely hit the restrictions: PreparedStatements, PL-SQL, ... If this is the case it's not an iBATIS but an Oracle problem. Attach the SqlMaps and I will search a bit in the Oracle documentation. > CLONE -The method executor.executeBatch() always returns 0. > ----------------------------------------------------------- > > Key: IBATIS-261 > URL: http://issues.apache.org/jira/browse/IBATIS-261 > Project: iBatis for Java > Type: Bug > Components: SQL Maps > Versions: 2.1.0 > Environment: SUN JVM 1.4.2 On Windows > Reporter: Arne Burmeister > > I am using Sql Maps 2.1.5 with Spring 1.2.4. > I have a method as following. > I want to get the number of rows updated in the batch . > But it always returns 0. > public int insertBatchError(final List batchErrorList) { > Integer count = (Integer) getSqlMapClientTemplate().execute(new > SqlMapClientCallback() { > public Object doInSqlMapClient(SqlMapExecutor executor) throws > SQLException { > executor.startBatch(); > for (int i = 0; i < batchErrorList.size(); i++) { > BatchErrorDTO batchErrorDto = (BatchErrorDTO) > batchErrorList.get(i); > executor.update("insertBatchError", batchErrorDto); > } > int count = executor.executeBatch(); > return new Integer(count); > } > }); > > return count.intValue(); > } -- 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
