From 02b862efc6d1684853a8860cab477a8782efadae Mon Sep 17 00:00:00 2001
From: Tim Otten <totten@civicrm.org>
Date: Fri, 22 Jan 2016 17:41:50 -0800
Subject: [PATCH] CRM-17860 - loadCaseSampleData - Don't muck with
 connections/transactions

---
 CRM/Admin/Form/Setting/Component.php | 8 +++-----
 CRM/Case/Info.php                    | 3 +--
 2 files changed, 4 insertions(+), 7 deletions(-)

diff --git a/CRM/Admin/Form/Setting/Component.php b/CRM/Admin/Form/Setting/Component.php
index cdcf59be82..092a86c523 100644
--- a/CRM/Admin/Form/Setting/Component.php
+++ b/CRM/Admin/Form/Setting/Component.php
@@ -119,11 +119,9 @@ class CRM_Admin_Form_Setting_Component extends CRM_Admin_Form_Setting {
    * @param string $fileName
    * @param bool $lineMode
    */
-  public static function loadCaseSampleData($dsn, $fileName, $lineMode = FALSE) {
-    $db = &DB::connect($dsn);
-    if (PEAR::isError($db)) {
-      die("Cannot open $dsn: " . $db->getMessage());
-    }
+  public static function loadCaseSampleData($fileName, $lineMode = FALSE) {
+    $dao = new CRM_Core_DAO();
+    $db = $dao->getDatabaseConnection();
 
     $domain = new CRM_Core_DAO_Domain();
     $domain->find(TRUE);
diff --git a/CRM/Case/Info.php b/CRM/Case/Info.php
index 6117e85a18..89669c2cb6 100644
--- a/CRM/Case/Info.php
+++ b/CRM/Case/Info.php
@@ -249,8 +249,7 @@ class CRM_Case_Info extends CRM_Core_Component_Info {
       (!$oldValue || !in_array('CiviCase', $oldValue))
     ) {
       $pathToCaseSampleTpl = __DIR__ . '/xml/configuration.sample/';
-      $config = CRM_Core_Config::singleton();
-      CRM_Admin_Form_Setting_Component::loadCaseSampleData($config->dsn, $pathToCaseSampleTpl . 'case_sample.mysql.tpl');
+      CRM_Admin_Form_Setting_Component::loadCaseSampleData($pathToCaseSampleTpl . 'case_sample.mysql.tpl');
       if (!CRM_Case_BAO_Case::createCaseViews()) {
         $msg = ts("Could not create the MySQL views for CiviCase. Your mysql user needs to have the 'CREATE VIEW' permission");
         CRM_Core_Error::fatal($msg);
-- 
2.25.1