OracleConnection

/**
 * @author Sajmon
 */

package example;

import java.sql.Connection;
import java.sql.SQLException;
import oracle.jdbc.pool.OracleDataSource;

public class ConnectionManager {

    private OracleDataSource ds;
    private final String SERVER_NAME = "neco.vsb.cz";
    private final String DATABASE_NAME = "databaseName";
    private final String USERNAME = "foo";
    private final String PASSWORD = "pass";

    public Connection getConnection() throws SQLException {
        ds = new OracleDataSource();
        ds.setPortNumber(3306); // neviem ci to je spravny port
        ds.setServerName(SERVER_NAME);
        ds.setDatabaseName(DATABASE_NAME);
        ds.setUser(USERNAME);
        ds.setPassword(PASSWORD);
        return ds.getConnection();
    }
}