| /** |
| * 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.sqoop.metastore.hsqldb; |
| |
| import java.io.File; |
| |
| import java.sql.Connection; |
| import java.sql.SQLException; |
| import java.sql.Statement; |
| |
| import org.apache.commons.logging.Log; |
| import org.apache.commons.logging.LogFactory; |
| import org.apache.hadoop.conf.Configuration; |
| |
| import org.apache.hadoop.util.StringUtils; |
| |
| import org.hsqldb.Server; |
| import org.hsqldb.ServerConstants; |
| |
| import com.cloudera.sqoop.SqoopOptions; |
| |
| import com.cloudera.sqoop.manager.HsqldbManager; |
| |
| /** |
| * Container for an HSQLDB-backed metastore. |
| */ |
| public class HsqldbMetaStore { |
| |
| public static final Log LOG = LogFactory.getLog( |
| HsqldbMetaStore.class.getName()); |
| |
| /** Where on the local fs does the metastore put files? */ |
| public static final String META_STORAGE_LOCATION_KEY = |
| "sqoop.metastore.server.location"; |
| |
| /** |
| * What port does the metastore listen on? |
| */ |
| public static final String META_SERVER_PORT_KEY = |
| "sqoop.metastore.server.port"; |
| |
| /** Default to this port if unset. */ |
| public static final int DEFAULT_PORT = 16000; |
| |
| private int port; |
| private String fileLocation; |
| private Server server; |
| private Configuration conf; |
| |
| public HsqldbMetaStore(Configuration config) { |
| this.conf = config; |
| init(); |
| } |
| |
| /** |
| * Determine the user's home directory and return a file path |
| * under this root where the shared metastore can be placed. |
| */ |
| private String getHomeDirFilePath() { |
| String homeDir = System.getProperty("user.home"); |
| |
| File homeDirObj = new File(homeDir); |
| File sqoopDataDirObj = new File(homeDirObj, ".sqoop"); |
| File databaseFileObj = new File(sqoopDataDirObj, "shared-metastore.db"); |
| |
| return databaseFileObj.toString(); |
| } |
| |
| private void init() { |
| if (null != server) { |
| LOG.debug("init(): server already exists."); |
| return; |
| } |
| |
| fileLocation = conf.get(META_STORAGE_LOCATION_KEY, null); |
| if (null == fileLocation) { |
| fileLocation = getHomeDirFilePath(); |
| LOG.warn("The location for metastore data has not been explicitly set. " |
| + "Placing shared metastore files in " + fileLocation); |
| } |
| |
| this.port = conf.getInt(META_SERVER_PORT_KEY, DEFAULT_PORT); |
| } |
| |
| |
| public void start() { |
| try { |
| if (server != null) { |
| server.checkRunning(false); |
| } |
| } catch (RuntimeException re) { |
| LOG.info("Server is already started."); |
| return; |
| } |
| |
| server = new Server(); |
| server.setDatabasePath(0, "file:" + fileLocation); |
| server.setDatabaseName(0, "sqoop"); |
| server.putPropertiesFromString("hsqldb.write_delay=false"); |
| server.setPort(port); |
| server.setSilent(true); |
| server.setNoSystemExit(true); |
| |
| server.start(); |
| LOG.info("Server started on port " + port + " with protocol " |
| + server.getProtocol()); |
| } |
| |
| /** |
| * Blocks the current thread until the server is shut down. |
| */ |
| public void waitForServer() { |
| while (true) { |
| int curState = server.getState(); |
| if (curState == ServerConstants.SERVER_STATE_SHUTDOWN) { |
| LOG.info("Got shutdown notification"); |
| break; |
| } |
| |
| try { |
| Thread.sleep(100); |
| } catch (InterruptedException ie) { |
| LOG.info("Interrupted while blocking for server:" |
| + StringUtils.stringifyException(ie)); |
| } |
| } |
| } |
| |
| /** |
| * Connects to the server and instructs it to shutdown. |
| */ |
| public void shutdown() { |
| // Send the SHUTDOWN command to the server via SQL. |
| SqoopOptions options = new SqoopOptions(conf); |
| options.setConnectString("jdbc:hsqldb:hsql://localhost:" |
| + port + "/sqoop"); |
| options.setUsername("SA"); |
| options.setPassword(""); |
| HsqldbManager manager = new HsqldbManager(options); |
| Statement s = null; |
| try { |
| Connection c = manager.getConnection(); |
| s = c.createStatement(); |
| s.execute("SHUTDOWN"); |
| } catch (SQLException sqlE) { |
| LOG.warn("Exception shutting down database: " |
| + StringUtils.stringifyException(sqlE)); |
| } finally { |
| if (null != s) { |
| try { |
| s.close(); |
| } catch (SQLException sqlE) { |
| LOG.warn("Error closing statement: " + sqlE); |
| } |
| } |
| |
| try { |
| manager.close(); |
| } catch (SQLException sqlE) { |
| LOG.warn("Error closing manager: " + sqlE); |
| } |
| } |
| } |
| } |
| |