svn commit: r1195857 [2/2] - in /incubator/sqoop/trunk/src/java: com/cloudera/sqoop/metastore/ com/cloudera/sqoop/metastore/hsqldb/ org/apache/sqoop/metastore/ org/apache/sqoop/metastore/hsqldb/

[bl...@apache.org]

Added: incubator/sqoop/trunk/src/java/org/apache/sqoop/metastore/hsqldb/HsqldbMetaStore.java
URL: http://svn.apache.org/viewvc/incubator/sqoop/trunk/src/java/org/apache/sqoop/metastore/hsqldb/HsqldbMetaStore.java?rev=1195857&view=auto
==============================================================================
--- incubator/sqoop/trunk/src/java/org/apache/sqoop/metastore/hsqldb/HsqldbMetaStore.java (added)
+++ incubator/sqoop/trunk/src/java/org/apache/sqoop/metastore/hsqldb/HsqldbMetaStore.java Tue Nov  1 07:39:43 2011
@@ -0,0 +1,180 @@
+/**
+ * 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);
+      }
+    }
+  }
+}
+

Propchange: incubator/sqoop/trunk/src/java/org/apache/sqoop/metastore/hsqldb/HsqldbMetaStore.java
------------------------------------------------------------------------------
    svn:mime-type = text/plain