JdbcLdapBrowser.java

/* **************************************************************************
*
* Copyright (C) 2002-2005 Octet String, Inc. All Rights Reserved.
*
* THIS WORK IS SUBJECT TO U.S. AND INTERNATIONAL COPYRIGHT LAWS AND
* TREATIES. USE, MODIFICATION, AND REDISTRIBUTION OF THIS WORK IS SUBJECT
* TO VERSION 2.0.1 OF THE OPENLDAP PUBLIC LICENSE, A COPY OF WHICH IS
* AVAILABLE AT HTTP://WWW.OPENLDAP.ORG/LICENSE.HTML OR IN THE FILE "LICENSE"
* IN THE TOP-LEVEL DIRECTORY OF THE DISTRIBUTION. ANY USE OR EXPLOITATION
* OF THIS WORK OTHER THAN AS AUTHORIZED IN VERSION 2.0.1 OF THE OPENLDAP
* PUBLIC LICENSE, OR OTHER PRIOR WRITTEN CONSENT FROM OCTET STRING, INC., 
* COULD SUBJECT THE PERPETRATOR TO CRIMINAL AND CIVIL LIABILITY.
******************************************************************************/
package com.octetstring.jdbcLdap.browser;
import org.eclipse.jface.viewers.*;
import org.eclipse.jface.window.*;
import org.eclipse.swt.*;
import org.eclipse.swt.custom.*;
import org.eclipse.swt.layout.*;
import org.eclipse.swt.graphics.*;
import org.eclipse.swt.widgets.*;
import org.eclipse.swt.widgets.List;
import org.eclipse.swt.events.*;
import org.eclipse.swt.graphics.*;
import org.eclipse.swt.dnd.*;

import java.io.File;
import java.lang.reflect.Constructor;
import java.lang.reflect.InvocationTargetException;
import java.net.MalformedURLException;
import java.net.URL;
import java.net.URLClassLoader;
import java.sql.*;

import org.eclipse.jface.dialogs.MessageDialog;
import java.util.*;
import java.util.prefs.Preferences;

import com.novell.ldap.LDAPUrl;
import com.novell.ldap.util.Base64;
import com.octetstring.jdbcLdap.jndi.*;


/**
 * @author Marc Boorshtein
 *
 */

public class JdbcLdapBrowser {
	CTabFolder tabs;
	Font tabFont;
	JndiLdapConnection con;
	String url,server,port,base,user,pass;
	boolean followReferrals,isDsml;
	String lastSQL;
	ArrayList reffedCons;
	Text SQL;
	
	ResultLoader results;
	Clipboard clipboard;
	TreeViewer tv;
	String baseDN;
	private boolean isSSL;
	protected ExecuteSQLPressed executeSQL;
	protected Button executeButton;
	boolean isSpml;
	URLClassLoader driverLoader;
	Connection jdbcCon;
	List history;
	
	boolean isDB;
	private String jdbcDriver;
	String jdbcUrl;
	String name;
	private String extraUrl;
	
	
	
	
	public JdbcLdapBrowser(
		String server,
		String port,
		String base,
		String user,
		String pass,
		boolean followRefferals,boolean isDsml,boolean isSSL,boolean isSpml,String extraUrl)
		throws Exception {
		this.clipboard = new Clipboard(Display.getCurrent());
		ConnectionStore conStore = new ConnectionStore();
		conStore.server = server;
		conStore.port = port;
		conStore.base = base;
		conStore.user = user;
		conStore.pass = pass;
		conStore.followReferrals = followRefferals;
		conStore.isDsml = isDsml;
		conStore.isSSL = isSSL;
		conStore.isSpml = isSpml;
		
		this.base = base;
		this.user = user;
		this.pass = pass;
		this.isDsml = isDsml;
		this.isSSL = isSSL;
		this.isSpml = isSpml;
		this.extraUrl = extraUrl;
		con = createConnection(server, port, base, user, pass,followRefferals,isDsml,isSSL,isSpml,extraUrl);
		this.baseDN = conStore.base;
		if (! isDsml) {
			url = "jdbc:ldap://"
			+ server
			+ ":"
			+ port
			+ "/"
			+ base
			+ "?EXP_ROWS:=true&secure:=" + (isSSL ? "true" : "false");
		}
		else {
			url = "jdbc:dsml:" + server + "?EXP_ROWS:=true";
		}
		conStore.con = con;
		this.reffedCons = new ArrayList();
		this.reffedCons.add(conStore);
		results = new ResultLoader(this);
		
		lastSQL = null;
		
		this.isDB = false;
		
		
		
	}
	
	public JdbcLdapBrowser(String driver,String url,String user,String pass) {
		this.isDB = true;
		
		this.jdbcDriver = driver;
		this.jdbcUrl = url;
		this.user = user;
		this.pass = pass;
		this.clipboard = new Clipboard(Display.getCurrent());
		File dir = new File(JdbcLdapBrowserApp.app.driversDir);
		if (dir.isDirectory() && dir.exists()) {
			File[] children = dir.listFiles();
			URL[] urls = new URL[children.length];
			
			for (int i=0;i<children.length;i++) {
				try {
					urls[i] = children[i].toURI().toURL();
				} catch (MalformedURLException e2) {
					MessageDialog.openError(Display.getCurrent().getActiveShell(),"Could not load drivers",e2.toString());
				}
			}
			
			this.driverLoader = new URLClassLoader(urls);
			
		} else {
			this.driverLoader = new URLClassLoader(new URL[0]);
		}
		
		try {
			this.jdbcCon = getJdbcConnection();
		} catch (Exception e) {
			MessageDialog.openError(Display.getCurrent().getActiveShell(),"Could not load JDBC Driver",e.toString());
		}
		
		try {
			results = new ResultLoader(this);
		} catch (SQLException e1) {
			MessageDialog.openError(Display.getCurrent().getActiveShell(),"Could not create result loader",e1.toString());
		}
	}
	
	/**
	 * @return
	 * @throws SQLException
	 * @throws ClassNotFoundException
	 * @throws NoSuchMethodException
	 * @throws SecurityException
	 * @throws InstantiationException
	 * @throws IllegalAccessException
	 * @throws InvocationTargetException
	 * @throws IllegalArgumentException
	 */
	private Connection getJdbcConnection() throws SQLException, SecurityException, NoSuchMethodException, ClassNotFoundException, IllegalArgumentException, InstantiationException, IllegalAccessException, InvocationTargetException {
		
		
		Driver driverImpl = (Driver) this.driverLoader.loadClass(this.jdbcDriver).newInstance();
		
		Properties props = new Properties();
		props.put("user",this.user);
		props.put("password",this.pass);
		
		return driverImpl.connect(this.jdbcUrl,props);
		
		/*Class.forName(this.jdbcDriver).newInstance();
		
		
		return DriverManager.getConnection(this.jdbcUrl,this.user,this.pass);*/