MySql Connection Manager with AllowPublicKeyRetrieval False

gistfile1.txt

package com.learned;

import java.sql.Connection;
import java.sql.SQLException;

import com.mysql.cj.jdbc.MysqlDataSource;

public class ConnectionManager {
	
	public static final String serverTimeZone = "UTC";
    public static final String serverName = "localhost";
    public static final String databaseName ="hive";
    public static final int portNumber = 3306;
    public static final String user = "raja";
    public static final String password = "raja";

    public static Connection getConnection() throws SQLException {

        MysqlDataSource dataSource = new MysqlDataSource();

        dataSource.setUseSSL( false );
        dataSource.setServerTimezone( serverTimeZone );
        dataSource.setServerName( serverName );
        dataSource.setDatabaseName( databaseName );
        dataSource.setPortNumber( portNumber );
        dataSource.setUser( user );
        dataSource.setPassword( password );
        dataSource.setAllowPublicKeyRetrieval(true);

        return dataSource.getConnection();
    }

	public static void main(String[] args) {
		try {
			Connection connection = getConnection();
			
			System.out.println("connection : "+connection);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

}