bpmn/MSOCoreBPMN/src/test/java/org/openecomp/mso/bpmn/core/utils/CamundaDBSetup.java

   1 /*-
   2  * ============LICENSE_START=======================================================
   3  * ONAP - SO
   4  * ================================================================================
   5  * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.
   6  * ================================================================================
   7  * Licensed under the Apache License, Version 2.0 (the "License");
   8  * you may not use this file except in compliance with the License.
   9  * You may obtain a copy of the License at
  10  *
  11  *      http://www.apache.org/licenses/LICENSE-2.0
  12  *
  13  * Unless required by applicable law or agreed to in writing, software
  14  * distributed under the License is distributed on an "AS IS" BASIS,
  15  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  16  * See the License for the specific language governing permissions and
  17  * limitations under the License.
  18  * ============LICENSE_END=========================================================
  19  */
  20
  21 package org.openecomp.mso.bpmn.core.utils;
  22
  23 import java.sql.Connection;
  24 import java.sql.DriverManager;
  25 import java.sql.PreparedStatement;
  26 import java.sql.SQLException;
  27
  28 import org.openecomp.mso.logger.MsoLogger;
  29
  30 /**
  31  * Sets up the unit test (H2) database for Camunda.
  32  */
  33 public class CamundaDBSetup {
  34         private static boolean isDBConfigured = false;
  35         private static final MsoLogger LOGGER = MsoLogger.getMsoLogger(MsoLogger.Catalog.BPEL);
  36
  37         private CamundaDBSetup() {
  38         }
  39
  40         public static synchronized void configure() throws SQLException {
  41                 if (isDBConfigured) {
  42                         return;
  43                 }
  44
  45                 LOGGER.debug ("Configuring the Camunda H2 database for MSO");
  46
  47                 Connection connection = null;
  48                 PreparedStatement stmt = null;
  49
  50                 try {
  51                         connection = DriverManager.getConnection(
  52                                 "jdbc:h2:mem:camunda;DB_CLOSE_DELAY=-1", "sa", "");
  53
  54                         stmt = connection.prepareStatement("delete from ACT_HI_VARINST");
  55                         stmt.executeUpdate();
  56                         stmt.close();
  57                         stmt = null;
  58
  59                         stmt = connection.prepareStatement("ALTER TABLE ACT_HI_VARINST alter column TEXT_ clob");
  60                         stmt.executeUpdate();
  61                         stmt.close();
  62                         stmt = null;
  63
  64 //                      stmt = connection.prepareStatement("ALTER TABLE ACT_HI_VARINST alter column NAME_ clob");
  65 //                      stmt.executeUpdate();
  66 //                      stmt.close();
  67 //                      stmt = null;
  68
  69                         stmt = connection.prepareStatement("delete from ACT_HI_DETAIL");
  70                         stmt.executeUpdate();
  71                         stmt.close();
  72                         stmt = null;
  73
  74                         stmt = connection.prepareStatement("ALTER TABLE ACT_HI_DETAIL alter column TEXT_ clob");
  75                         stmt.executeUpdate();
  76                         stmt.close();
  77                         stmt = null;
  78
  79 //                      stmt = connection.prepareStatement("ALTER TABLE ACT_HI_DETAIL alter column NAME_ clob");
  80 //                      stmt.executeUpdate();
  81 //                      stmt.close();
  82 //                      stmt = null;
  83
  84                         stmt = connection.prepareStatement("ALTER TABLE ACT_RU_VARIABLE alter column TEXT_ clob");
  85                         stmt.executeUpdate();
  86                         stmt.close();
  87                         stmt = null;
  88
  89                         connection.close();
  90                         connection = null;
  91
  92                         isDBConfigured = true;
  93                 } catch (SQLException e) {
  94                     LOGGER.debug ("CamundaDBSetup caught " + e.getClass().getSimpleName());
  95                         LOGGER.debug("SQLException :",e);
  96                 } finally {
  97                         if (stmt != null) {
  98                                 try {
  99                                         stmt.close();
 100                                 } catch (Exception e) {
 101                                         LOGGER.debug("Exception :",e);
 102                                 }
 103                         }
 104
 105                         if (connection != null) {
 106                                 try {
 107                                         connection.close();
 108                                 } catch (Exception e) {
 109                                         LOGGER.debug("Exception :",e);
 110                                 }
 111                         }
 112                 }
 113         }
 114 }