package managers;

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

import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

public final class DatabaseConnection {
	private static DataSource dataSource;

	public DatabaseConnection() {
        try {
            dataSource = (DataSource) new InitialContext().lookup("jdbc/MySQLDataSource");
            System.out.println("Connection is established!");
        } catch (NamingException e) {
            throw new ExceptionInInitializerError(e);
        }
    }

    public Connection getConnection() throws SQLException {
    	return dataSource.getConnection();
    }
}



--------------------------------------------------------------------------------------------


Exception in thread "main" java.lang.ExceptionInInitializerError
	at managers.DatabaseConnection.<init>(DatabaseConnection.java:18)
	at managers.Main.main(Main.java:9)
Caused by: javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file:  java.naming.factory.initial
	at javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:662)
	at javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:307)
	at javax.naming.InitialContext.getURLOrDefaultInitCtx(InitialContext.java:344)
	at javax.naming.InitialContext.lookup(InitialContext.java:411)
	at managers.DatabaseConnection.<init>(DatabaseConnection.java:15)
	... 1 more