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

---
 .../src/main/resources/org/sonar/core/purge/PurgeMapper.xml     | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

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 28745b85272..ac1b2288f93 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">
+  <select id="selectSnapshotIds" parameterType="map" resultType="long" resultSetType="SCROLL_INSENSITIVE">
     select s.id from snapshots s
     <where>
       <if test="islast != null">
-- 
2.39.5