@Test
  public void testStoredProcSaveAndRetrieve() throws Exception {
    objectStore.createDatabase(new DatabaseBuilder()
            .setName(DB1)
            .setDescription("description")
            .setLocation("locationurl")
            .build(conf));

    StoredProcedure input = new StoredProcedure();
    input.setSource("print 'Hello world'");
    input.setCatName("hive");
    input.setOwnerName("user1");
    input.setName("greetings");
    input.setDbName(DB1);

    objectStore.createOrUpdateStoredProcedure(input);
    StoredProcedure retrieved = objectStore.getStoredProcedure("hive", DB1, "greetings");

    Assert.assertEquals(input, retrieved);
  }
Helper method for setting and checking the SSL configuration parameters.
@param useSSL whether or not SSL is enabled
@param trustStorePath truststore path, corresponding to the value for {@link MetastoreConf.ConfVars#DBACCESS_SSL_TRUSTSTORE_PATH}
@param trustStorePassword truststore password, corresponding to the value for {@link MetastoreConf.ConfVars#DBACCESS_SSL_TRUSTSTORE_PASSWORD}
@param trustStoreType truststore type, corresponding to the value for {@link MetastoreConf.ConfVars#DBACCESS_SSL_TRUSTSTORE_TYPE}
standalone-metastore/metastore-server/src/test/java/org/apache/hadoop/hive/metastore/TestObjectStore.java