SONAR-5755 fix cursor mode on PostgresSQL

2 files changed, 16 insertions, 17 deletions

diff --git a/sonar-core/src/main/java/org/sonar/core/persistence/migration/v50/Migration50Mapper.java b/sonar-core/src/main/java/org/sonar/core/persistence/migration/v50/Migration50Mapper.java
index 61c1c43fb91..8fa97afee1e 100644
--- a/sonar-core/src/main/java/org/sonar/core/persistence/migration/v50/Migration50Mapper.java
+++ b/sonar-core/src/main/java/org/sonar/core/persistence/migration/v50/Migration50Mapper.java
@@ -21,8 +21,6 @@
 package org.sonar.core.persistence.migration.v50;
 
 import org.apache.ibatis.annotations.*;
-import org.apache.ibatis.mapping.ResultSetType;
-import org.apache.ibatis.mapping.StatementType;
 
 import java.util.List;
 
@@ -31,21 +29,6 @@ public interface Migration50Mapper {
   /**
    * Return root projects (Views and Developers are NOT returned)
    */
-  @Select("SELECT " +
-    "  p.id AS \"id\", " +
-    "  p.uuid AS \"uuid\", " +
-    "  p.project_uuid AS \"projectUuid\", " +
-    "  s.root_project_id AS \"projectId\", " +
-    "  s.id AS \"snapshotId\", " +
-    "  s.path AS \"snapshotPath\", " +
-    "  p.scope AS \"scope\" " +
-    "FROM projects p " +
-    "  LEFT OUTER JOIN snapshots s ON s.project_id = p.id AND s.islast = ${_true} " +
-    "  WHERE " +
-    "   p.scope = 'PRJ' " +
-    "   AND p.root_id IS NULL ")
-  @Result(javaType = Component.class)
-  @Options(statementType = StatementType.PREPARED, resultSetType = ResultSetType.FORWARD_ONLY, fetchSize = 200)
   List<Component> selectRootProjects();
 
   @Select("SELECT " +
diff --git a/sonar-core/src/main/resources/org/sonar/core/persistence/migration/v50/Migration50Mapper.xml b/sonar-core/src/main/resources/org/sonar/core/persistence/migration/v50/Migration50Mapper.xml
index 1db97943867..5d69ead06e5 100644
--- a/sonar-core/src/main/resources/org/sonar/core/persistence/migration/v50/Migration50Mapper.xml
+++ b/sonar-core/src/main/resources/org/sonar/core/persistence/migration/v50/Migration50Mapper.xml
@@ -3,5 +3,21 @@
 
 <mapper namespace="org.sonar.core.persistence.migration.v50.Migration50Mapper">
 
+  <select id="selectRootProjects" resultType="org.sonar.core.persistence.migration.v50.Component" fetchSize="200" resultSetType="FORWARD_ONLY">
+    SELECT
+    p.id AS "id",
+    p.uuid AS "uuid",
+    p.project_uuid AS "projectUuid",
+    s.root_project_id AS "projectId",
+    s.id AS "snapshotId",
+    s.path AS "snapshotPath",
+    p.scope AS "scope"
+    FROM projects p
+    LEFT OUTER JOIN snapshots s ON s.project_id = p.id AND s.islast = ${_true}
+    WHERE
+    p.scope = 'PRJ'
+    AND p.root_id IS NULL
+  </select>
+
 </mapper>