org.openrdf.sail.rdbms.mysql.MySqlStore.java Source code

Introduction

Here is the source code for org.openrdf.sail.rdbms.mysql.MySqlStore.java

Source

/* 
 * Licensed to Aduna under one or more contributor license agreements.  
 * See the NOTICE.txt file distributed with this work for additional 
 * information regarding copyright ownership. 
 *
 * Aduna licenses this file to you under the terms of the Aduna BSD 
 * License (the "License"); you may not use this file except in compliance 
 * with the License. See the LICENSE.txt file distributed with this work 
 * for the full License.
 *
 * 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.openrdf.sail.rdbms.mysql;

import java.io.UnsupportedEncodingException;
import java.net.URLEncoder;
import java.util.Collections;
import java.util.HashMap;
import java.util.Map;
import java.util.Map.Entry;

import org.apache.commons.dbcp.BasicDataSource;

import org.openrdf.sail.SailException;
import org.openrdf.sail.rdbms.RdbmsStore;
import org.openrdf.sail.rdbms.exceptions.RdbmsException;

/**
 * A convenient way to initialise a MySql RDF store.
 * 
 * @author James Leigh
 * @deprecated the MySQL RDF store is no longer supported and will be removed in
 *             a future Sesame release. Consider switching to a different SAIL
 *             backend.
 */
@Deprecated
public class MySqlStore extends RdbmsStore {

    private String serverName = "localhost";

    private String databaseName;

    private int portNumber;

    private Map<String, String> properties = Collections.emptyMap();

    private String user;

    private String password;

    public MySqlStore() {
        super();
    }

    public MySqlStore(String databaseName) {
        setDatabaseName(databaseName);
    }

    public String getServerName() {
        return serverName;
    }

    public void setServerName(String serverName) {
        this.serverName = serverName;
    }

    public String getDatabaseName() {
        return databaseName;
    }

    public void setDatabaseName(String databaseName) {
        this.databaseName = databaseName;
    }

    public int getPortNumber() {
        return portNumber;
    }

    public void setPortNumber(int portNumber) {
        this.portNumber = portNumber;
    }

    public Map<String, String> getProperties() {
        return Collections.unmodifiableMap(properties);
    }

    public void setProperties(Map<String, String> properties) {
        this.properties = new HashMap<String, String>(properties);
    }

    public String getUser() {
        return user;
    }

    public void setUser(String user) {
        this.user = user;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    @Override
    public void initialize() throws SailException {
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            throw new RdbmsException(e.toString(), e);
        }
        StringBuilder url = new StringBuilder();
        url.append("jdbc:mysql:");
        if (serverName != null) {
            url.append("//").append(serverName);
            if (portNumber > 0) {
                url.append(":").append(portNumber);
            }
            url.append("/");
        }
        url.append(databaseName);
        url.append("?useUnicode=yes&characterEncoding=UTF-8");
        for (Entry<String, String> e : getProperties().entrySet()) {
            url.append("&");
            url.append(enc(e.getKey()));
            url.append("=");
            url.append(enc(e.getValue()));
        }
        BasicDataSource ds = new BasicDataSource();
        ds.setUrl(url.toString());
        if (user != null) {
            ds.setUsername(user);
        } else {
            ds.setUsername(System.getProperty("user.name"));
        }
        if (password != null) {
            ds.setPassword(password);
        }
        MySqlConnectionFactory factory = new MySqlConnectionFactory();
        factory.setSail(this);
        factory.setDataSource(ds);
        setBasicDataSource(ds);
        setConnectionFactory(factory);
        super.initialize();
    }

    private String enc(String text) {
        try {
            return URLEncoder.encode(text, "UTF-8");
        } catch (UnsupportedEncodingException e) {
            throw new AssertionError(e);
        }
    }
}