private void close(Connection conn) {
   try {
     if (conn != null) {
       conn.close();
     }
   } catch (SQLException e) {
     LOGGER.error("error during closing:" + e.getMessage(), e);
   }
 }