content: /*
   * Licensed to the Apache Software Foundation (ASF) under one or more
   * contributor license agreements. See the NOTICE file distributed with
   * this work for additional information regarding copyright ownership.
   * The ASF licenses this file to You 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.
   */
  package org.apache.activemq.artemis.tests.util;
  
  import java.lang.invoke.MethodHandles;
  import java.sql.DriverManager;
  import java.sql.SQLException;
  
  import org.slf4j.Logger;
  import org.slf4j.LoggerFactory;
  
  public class DBSupportUtil {
     private static Logger logger = LoggerFactory.getLogger(MethodHandles.lookup().lookupClass());
  
     public static final String EXPECTED_DERBY_DROP_STATE = "08006";
     public static final String EXPECTED_DERBY_SHUTDOWN_STATE = "XJ015";
  
     public static void dropDerbyDatabase(String user, String password, String databaseName) throws SQLException {
        try {
           if (user == null) {
              DriverManager.getConnection("jdbc:derby:" + databaseName + ";drop=true");
           } else {
              DriverManager.getConnection("jdbc:derby:" + databaseName + ";drop=true", user, password);
           }
        } catch (SQLException sqlE) {
           if (!sqlE.getSQLState().equals(EXPECTED_DERBY_DROP_STATE)) {
              logger.warn("{} / {}", sqlE.getMessage(), sqlE.getSQLState());
              throw sqlE;
           } else {
              logger.info("{} / {}", sqlE.getMessage(), sqlE.getSQLState());
           }
        }
     }
  
     public static void shutdownDerby(String user, String password) throws SQLException {
        try {
           if (user == null) {
              DriverManager.getConnection("jdbc:derby:;shutdown=true;deregister=false");
           } else {
              DriverManager.getConnection("jdbc:derby:;shutdown=true;deregister=false", user, password);
           }
        } catch (SQLException sqlE) {
           logger.debug("{} / {}", sqlE.getMessage(), sqlE.getSQLState());
           if (!sqlE.getSQLState().equals(EXPECTED_DERBY_SHUTDOWN_STATE)) {
              throw sqlE;
           }
        }
     }
  
  }
  