1 files changed, 114 insertions, 0 deletions
diff --git a/bpmn/MSOCoreBPMN/src/test/java/org/openecomp/mso/bpmn/core/utils/CamundaDBSetup.java b/bpmn/MSOCoreBPMN/src/test/java/org/openecomp/mso/bpmn/core/utils/CamundaDBSetup.java
new file mode 100644
index 0000000000..f29ccc75e0
--- /dev/null
+++ b/bpmn/MSOCoreBPMN/src/test/java/org/openecomp/mso/bpmn/core/utils/CamundaDBSetup.java
@@ -0,0 +1,114 @@
+/*-
+ * ============LICENSE_START=======================================================
+ * ONAP - SO
+ * ================================================================================
+ * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.
+ * ================================================================================
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ *      http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ * ============LICENSE_END=========================================================
+ */
+
+package org.openecomp.mso.bpmn.core.utils;
+
+import java.sql.Connection;
+import java.sql.DriverManager;
+import java.sql.PreparedStatement;
+import java.sql.SQLException;
+
+import org.openecomp.mso.logger.MsoLogger;
+
+/**
+ * Sets up the unit test (H2) database for Camunda.
+ */
+public class CamundaDBSetup {
+	private static boolean isDBConfigured = false;
+	private static final MsoLogger LOGGER = MsoLogger.getMsoLogger(MsoLogger.Catalog.BPEL);
+	
+	private CamundaDBSetup() {
+	}
+	
+	public static synchronized void configure() throws SQLException {
+		if (isDBConfigured) {
+			return;
+		}
+
+		LOGGER.debug ("Configuring the Camunda H2 database for MSO");
+
+		Connection connection = null;
+		PreparedStatement stmt = null;
+
+		try {
+			connection = DriverManager.getConnection(
+				"jdbc:h2:mem:camunda;DB_CLOSE_DELAY=-1", "sa", "");
+
+			stmt = connection.prepareStatement("delete from ACT_HI_VARINST");
+			stmt.executeUpdate();
+			stmt.close();
+			stmt = null;
+
+			stmt = connection.prepareStatement("ALTER TABLE ACT_HI_VARINST alter column TEXT_ clob");
+			stmt.executeUpdate();
+			stmt.close();
+			stmt = null;
+			
+//			stmt = connection.prepareStatement("ALTER TABLE ACT_HI_VARINST alter column NAME_ clob");
+//			stmt.executeUpdate();
+//			stmt.close();
+//			stmt = null;
+
+			stmt = connection.prepareStatement("delete from ACT_HI_DETAIL");
+			stmt.executeUpdate();
+			stmt.close();
+			stmt = null;
+
+			stmt = connection.prepareStatement("ALTER TABLE ACT_HI_DETAIL alter column TEXT_ clob");
+			stmt.executeUpdate();
+			stmt.close();
+			stmt = null;
+
+//			stmt = connection.prepareStatement("ALTER TABLE ACT_HI_DETAIL alter column NAME_ clob");
+//			stmt.executeUpdate();
+//			stmt.close();
+//			stmt = null;
+
+			stmt = connection.prepareStatement("ALTER TABLE ACT_RU_VARIABLE alter column TEXT_ clob");
+			stmt.executeUpdate();
+			stmt.close();
+			stmt = null;
+
+			connection.close();
+			connection = null;
+
+			isDBConfigured = true;
+		} catch (SQLException e) {
+		    LOGGER.debug ("CamundaDBSetup caught " + e.getClass().getSimpleName());
+			LOGGER.debug("SQLException :",e);
+		} finally {
+			if (stmt != null) {
+				try {
+					stmt.close();
+				} catch (Exception e) {
+					LOGGER.debug("Exception :",e);
+				}
+			}
+
+			if (connection != null) {
+				try {
+					connection.close();
+				} catch (Exception e) {
+					LOGGER.debug("Exception :",e);
+				}
+			}
+		}
+	}
+}
+\ No newline at end of file