From aff59ce2552d4a9071f7bd9d08f1fb4365843b05 Mon Sep 17 00:00:00 2001
From: =?utf8?q?S=C3=A9bastien=20Lesaint?=
 <sebastien.lesaint@sonarsource.com>
Date: Mon, 28 May 2018 11:37:25 +0200
Subject: [PATCH] SONAR-10430 add missing jdbc types

---
 .../org/sonar/db/source/FileSourceMapper.xml  | 20 +++++++++++--------
 1 file changed, 12 insertions(+), 8 deletions(-)

diff --git a/server/sonar-db-dao/src/main/resources/org/sonar/db/source/FileSourceMapper.xml b/server/sonar-db-dao/src/main/resources/org/sonar/db/source/FileSourceMapper.xml
index 64f804a97c6..1fdac6a2b7f 100644
--- a/server/sonar-db-dao/src/main/resources/org/sonar/db/source/FileSourceMapper.xml
+++ b/server/sonar-db-dao/src/main/resources/org/sonar/db/source/FileSourceMapper.xml
@@ -23,8 +23,8 @@
     from
       file_sources
     where
-      file_uuid = #{fileUuid}
-      and data_type = #{dataType}
+      file_uuid = #{fileUuid,jdbcType=VARCHAR}
+      and data_type = #{dataType,jdbcType=VARCHAR}
   </select>
 
   <select id="selectHashesForProject" parameterType="map" resultType="org.sonar.db.source.FileSourceDto">
@@ -38,8 +38,8 @@
     from
       file_sources
     where
-      project_uuid = #{projectUuid}
-      and data_type=#{dataType}
+      project_uuid = #{projectUuid,jdbcType=VARCHAR}
+      and data_type = #{dataType,jdbcType=VARCHAR}
   </select>
 
   <select id="scrollLineHashes" parameterType="map" resultType="org.sonar.db.source.LineHashesWithKeyDto" fetchSize="${_scrollFetchSize}" resultSetType="FORWARD_ONLY">
@@ -60,9 +60,13 @@
   </select>
 
   <select id="selectLineHashesVersion" parameterType="map" resultType="Integer">
-    SELECT line_hashes_version
-    FROM file_sources
-    WHERE file_uuid = #{fileUuid,jdbcType=VARCHAR} and data_type=#{dataType,jdbcType=VARCHAR}
+    SELECT
+      line_hashes_version
+    FROM
+      file_sources
+    WHERE
+      file_uuid = #{fileUuid,jdbcType=VARCHAR}
+      and data_type=#{dataType,jdbcType=VARCHAR}
   </select>
 
   <insert id="insert" parameterType="org.sonar.db.source.FileSourceDto" useGeneratedKeys="false">
@@ -111,7 +115,7 @@
       src_hash = #{srcHash,jdbcType=VARCHAR},
       revision = #{revision,jdbcType=VARCHAR}
     where
-      id = #{id}
+      id = #{id,jdbcType=INTEGER}
   </update>
 
 </mapper>
-- 
2.39.5