com.digitalpebble.stormcrawler.sql.SQLUtil Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of storm-crawler-sql Show documentation
Show all versions of storm-crawler-sql Show documentation
SQL-based resources for StormCrawler
/**
* Licensed to DigitalPebble Ltd under one or more
* contributor license agreements. See the NOTICE file distributed with
* this work for additional information regarding copyright ownership.
* DigitalPebble 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 com.digitalpebble.stormcrawler.sql;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;
import java.util.Map.Entry;
import java.util.Properties;
public class SQLUtil {
private SQLUtil() {
}
@SuppressWarnings({ "rawtypes", "unchecked" })
public static Connection getConnection(Map stormConf) throws SQLException {
// SQL connection details
Map sqlConf = (Map) stormConf.get("sql.connection");
if (sqlConf == null) {
throw new RuntimeException(
"Missing SQL connection config, add a section 'sql.connection' to the configuration");
}
String url = sqlConf.get("url");
if (url == null) {
throw new RuntimeException(
"Missing SQL url, add an entry 'url' to the section 'sql.connection' of the configuration");
}
Properties props = new Properties();
for (Entry entry : sqlConf.entrySet()) {
props.setProperty(entry.getKey(), entry.getValue());
}
return DriverManager.getConnection(url, props);
}
}
© 2015 - 2024 Weber Informatics LLC | Privacy Policy