From 785e992028e545bb3a0811be7af7f4853b1137ff Mon Sep 17 00:00:00 2001
From: Simon Brandhof <simon.brandhof@sonarsource.com>
Date: Thu, 25 Aug 2016 16:28:33 +0200
Subject: [PATCH] Allow try-with-resources with SqlStatement in DB migrations

---
 .../src/main/java/org/sonar/db/version/BaseSqlStatement.java | 3 +--
 .../src/main/java/org/sonar/db/version/SqlStatement.java     | 5 +++--
 2 files changed, 4 insertions(+), 4 deletions(-)

diff --git a/sonar-db/src/main/java/org/sonar/db/version/BaseSqlStatement.java b/sonar-db/src/main/java/org/sonar/db/version/BaseSqlStatement.java
index 27e12563132..6b465a78952 100644
--- a/sonar-db/src/main/java/org/sonar/db/version/BaseSqlStatement.java
+++ b/sonar-db/src/main/java/org/sonar/db/version/BaseSqlStatement.java
@@ -35,10 +35,9 @@ class BaseSqlStatement<CHILD extends SqlStatement> implements SqlStatement<CHILD
   }
 
   @Override
-  public CHILD close() {
+  public void close() {
     DbUtils.closeQuietly(pstmt);
     pstmt = null;
-    return (CHILD) this;
   }
 
   @Override
diff --git a/sonar-db/src/main/java/org/sonar/db/version/SqlStatement.java b/sonar-db/src/main/java/org/sonar/db/version/SqlStatement.java
index 28924c538a1..4158aee2b77 100644
--- a/sonar-db/src/main/java/org/sonar/db/version/SqlStatement.java
+++ b/sonar-db/src/main/java/org/sonar/db/version/SqlStatement.java
@@ -23,7 +23,7 @@ import java.sql.SQLException;
 import java.util.Date;
 import javax.annotation.Nullable;
 
-public interface SqlStatement<CHILD extends SqlStatement> {
+public interface SqlStatement<CHILD extends SqlStatement> extends AutoCloseable {
   CHILD setBoolean(int columnIndex, @Nullable Boolean value) throws SQLException;
 
   CHILD setDate(int columnIndex, @Nullable Date value) throws SQLException;
@@ -38,5 +38,6 @@ public interface SqlStatement<CHILD extends SqlStatement> {
 
   CHILD setBytes(int columnIndex, @Nullable byte[] data) throws SQLException;
 
-  CHILD close();
+  @Override
+  void close();
 }
-- 
2.39.5