From 8b84563a0452b7ec0d83a11a8a1c75b822a110cc Mon Sep 17 00:00:00 2001
From: Simon Brandhof <simon.brandhof@gmail.com>
Date: Thu, 2 Feb 2012 11:38:41 +0100
Subject: [PATCH] Experimental fix for purges on Oracle

---
 .../src/main/java/org/sonar/core/persistence/BatchSession.java  | 2 +-
 .../src/main/resources/org/sonar/core/purge/PurgeMapper.xml     | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/sonar-core/src/main/java/org/sonar/core/persistence/BatchSession.java b/sonar-core/src/main/java/org/sonar/core/persistence/BatchSession.java
index 4413fff3aee..da48c5f6c76 100644
--- a/sonar-core/src/main/java/org/sonar/core/persistence/BatchSession.java
+++ b/sonar-core/src/main/java/org/sonar/core/persistence/BatchSession.java
@@ -31,7 +31,7 @@ import java.util.Map;
 
 public final class BatchSession implements SqlSession {
 
-  public static final int MAX_BATCH_SIZE = 1000;
+  public static final int MAX_BATCH_SIZE = 250;
 
   private final SqlSession session;
   private final int batchSize;
diff --git a/sonar-core/src/main/resources/org/sonar/core/purge/PurgeMapper.xml b/sonar-core/src/main/resources/org/sonar/core/purge/PurgeMapper.xml
index ac1b2288f93..b1144d9a6da 100644
--- a/sonar-core/src/main/resources/org/sonar/core/purge/PurgeMapper.xml
+++ b/sonar-core/src/main/resources/org/sonar/core/purge/PurgeMapper.xml
@@ -3,7 +3,7 @@
 
 <mapper namespace="org.sonar.core.purge.PurgeMapper">
 
-  <select id="selectSnapshotIds" parameterType="map" resultType="long" resultSetType="SCROLL_INSENSITIVE">
+  <select id="selectSnapshotIds" parameterType="map" resultType="long" >
     select s.id from snapshots s
     <where>
       <if test="islast != null">
-- 
2.39.5