Fix test on Postgres

1 files changed, 5 insertions, 1 deletions

diff --git a/sonar-core/src/test/java/org/sonar/core/rule/RuleDaoTest.java b/sonar-core/src/test/java/org/sonar/core/rule/RuleDaoTest.java
index 997f4a91f3f..4c661e119cb 100644
--- a/sonar-core/src/test/java/org/sonar/core/rule/RuleDaoTest.java
+++ b/sonar-core/src/test/java/org/sonar/core/rule/RuleDaoTest.java
@@ -20,6 +20,7 @@
 package org.sonar.core.rule;
 
 import com.google.common.collect.ImmutableList;
+import org.apache.ibatis.session.SqlSession;
 import org.junit.Before;
 import org.junit.Test;
 import org.sonar.api.rules.Rule;
@@ -83,7 +84,10 @@ public class RuleDaoTest extends AbstractDaoTestCase {
   @Test
   public void testSelectNonManual() throws Exception {
     setupData("selectNonManual");
-    List<RuleDto> ruleDtos = dao.selectNonManual(getMyBatis().openSession());
+    SqlSession session = getMyBatis().openSession();
+    List<RuleDto> ruleDtos = dao.selectNonManual(session);
+    session.commit();
+    session.close();
 
     assertThat(ruleDtos.size()).isEqualTo(1);
     RuleDto ruleDto = ruleDtos.get(0);