Example usage for org.apache.hadoop.mapred.lib.db DBConfiguration USERNAME_PROPERTY

Introduction

In this page you can find the example usage for org.apache.hadoop.mapred.lib.db DBConfiguration USERNAME_PROPERTY.

Prototype

String USERNAME_PROPERTY

To view the source code for org.apache.hadoop.mapred.lib.db DBConfiguration USERNAME_PROPERTY.

Click Source Link

Document

User name to access the database

Usage

From source file:infinidb.hadoop.db.InfiniDBConfiguration.java

License:Apache License

/**
 * Sets the DB access related fields in the JobConf.  
 * @param job the job//w w w  .j av a 2s.co m
 * @param driverClass JDBC Driver class name
 * @param dbUrl JDBC DB access URL. 
 * @param userName DB access username 
 * @param passwd DB access passwd
 */
public static void configureDB(JobConf job, String driverClass, String dbUrl, String userName, String passwd) {

    job.set(DBConfiguration.DRIVER_CLASS_PROPERTY, driverClass);
    job.set(DBConfiguration.URL_PROPERTY, dbUrl);
    if (userName != null)
        job.set(DBConfiguration.USERNAME_PROPERTY, userName);
    if (passwd != null)
        job.set(DBConfiguration.PASSWORD_PROPERTY, passwd);
}

---

From source file:infinidb.hadoop.db.InfiniDBConfiguration.java

License:Apache License

/** Returns a connection object o the DB 
 * @throws ClassNotFoundException //w  w  w. ja  va 2 s .com
 * @throws SQLException
 */
Connection getConnection() throws IOException {
    try {
        Class.forName(job.get(DBConfiguration.DRIVER_CLASS_PROPERTY));
    } catch (ClassNotFoundException exception) {
        throw new IOException("Conection driver can not be loaded", exception);
    }

    try {
        if (job.get(DBConfiguration.USERNAME_PROPERTY) == null) {
            return DriverManager.getConnection(job.get(DBConfiguration.URL_PROPERTY));
        } else {
            return DriverManager.getConnection(job.get(DBConfiguration.URL_PROPERTY),
                    job.get(DBConfiguration.USERNAME_PROPERTY), job.get(DBConfiguration.PASSWORD_PROPERTY));
        }
    } catch (SQLException exception) {
        throw new IOException("Conection can not be established", exception);
    }
}

---