p6testdriver.java

一个跟踪调试jdbc的工具包。通过把jdbc做一个封装

/*
 *
 * ====================================================================
 *
 * The P6Spy Software License, Version 1.1
 *
 * This license is derived and fully compatible with the Apache Software
 * license, see http://www.apache.org/LICENSE.txt
 *
 * Copyright (c) 2001-2002 Andy Martin, Ph.D. and Jeff Goke
 * All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions
 * are met:
 *
 * 1. Redistributions of source code must retain the above copyright
 * notice, this list of conditions and the following disclaimer.
 *
 * 2. Redistributions in binary form must reproduce the above copyright
 * notice, this list of conditions and the following disclaimer in
 * the documentation and/or other materials provided with the
 * distribution.
 *
 * 3. The end-user documentation included with the redistribution, if
 * any, must include the following acknowlegement:
 * "The original concept and code base for P6Spy was conceived
 * and developed by Andy Martin, Ph.D. who generously contribued
 * the first complete release to the public under this license.
 * This product was due to the pioneering work of Andy
 * that began in December of 1995 developing applications that could
 * seamlessly be deployed with minimal effort but with dramatic results.
 * This code is maintained and extended by Jeff Goke and with the ideas
 * and contributions of other P6Spy contributors.
 * (http://www.p6spy.com)"
 * Alternately, this acknowlegement may appear in the software itself,
 * if and wherever such third-party acknowlegements normally appear.
 *
 * 4. The names "P6Spy", "Jeff Goke", and "Andy Martin" must not be used
 * to endorse or promote products derived from this software without
 * prior written permission. For written permission, please contact
 * [e-mail].
 *
 * 5. Products derived from this software may not be called "P6Spy"
 * nor may "P6Spy" appear in their names without prior written
 * permission of Jeff Goke and Andy Martin.
 *
 * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
 * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
 * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
 * DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR
 * ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
 * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
 * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
 * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
 * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
 * SUCH DAMAGE.
 */

package com.p6spy.engine.test;

import java.util.*;
import java.sql.*;
import com.p6spy.engine.spy.*;

public class P6TestDriver extends P6TestFramework {
    public P6TestDriver(String name) {
	super(name);
    }

    public void testMajorVersion() {
	try {
	    Properties props = P6TestUtil.loadProperties("P6Test.properties");
	    String url = props.getProperty("url");
	    
	    Driver driver = DriverManager.getDriver(url);

	    // make sure you have a p6 driver
	    if (! (driver instanceof P6SpyDriverCore)) {
		fail("Expected to get back a p6spy driver, got back a " + driver);
	    }

	    // but make sure it's bound to something
	    // these numbers will likely change over time :)
	    assertEquals(1, driver.getMajorVersion());
	    assertEquals(0, driver.getMinorVersion());

	} catch (Exception e) {
	    e.printStackTrace(System.out);
	    fail("unexpected exception: " + e);
	} finally {
	}
    }


    public void testGetJDBC() {
	try {
	    P6Connection p6con = (P6Connection) connection;
	    chkGetJDBC(p6con, p6con.getJDBC());

	    P6DatabaseMetaData p6md = (P6DatabaseMetaData) connection.getMetaData();
	    chkGetJDBC(p6md, p6md.getJDBC());

	    P6Statement p6stmt = (P6Statement) connection.createStatement();
	    chkGetJDBC(p6stmt, p6stmt.getJDBC());

	    P6CallableStatement p6cs = (P6CallableStatement) connection.prepareCall("select sysdate from dual");
	    chkGetJDBC(p6cs, p6cs.getJDBC());

	    P6PreparedStatement p6ps = (P6PreparedStatement) connection.prepareStatement("select 1 + 1 from dual");
	    chkGetJDBC(p6ps, p6ps.getJDBC());

	    P6ResultSet p6rs = (P6ResultSet) p6ps.executeQuery();
	    chkGetJDBC(p6rs, p6rs.getJDBC());

	    P6ResultSetMetaData p6rsmd = (P6ResultSetMetaData) p6rs.getMetaData();
	    chkGetJDBC(p6rsmd, p6rsmd.getJDBC());

	    // try to release everything
	    p6cs.close();
	    p6ps.close();
	    p6rs.close();
	    p6stmt.close();
	    p6con.close();
	    
	} catch (Exception e) {
	    e.printStackTrace(System.out);
	    fail("unexpected exception: " + e);
	}

    }

    protected void chkGetJDBC(P6Base p6object, Object jdbcObject) {
	String p6class = p6object.getClass().getName();
	String jdbcClass = jdbcObject.getClass().getName();

	/*
	System.out.println(p6class);
	System.out.println(jdbcClass);
	*/
	
	assertTrue("Class " + p6class + " is supposed to be a p6 class, but it is not", (p6class.indexOf("p6spy") != -1));
	assertTrue("Class " + jdbcClass + " is supposed to be a jdbc class, but it is not", (jdbcClass.indexOf("p6spy") == -1));
    }

    public void t1estDataSource() {
	Connection con = null;
	Statement st   = null;
	try {
            P6TestUtil.unloadDrivers();

	    // try to do a simple test using the datasourcey stuff
	    Properties props = P6TestUtil.loadProperties("P6Test.properties");
	    String user      = props.getProperty("user");
	    String password  = props.getProperty("password");
	    String url       = props.getProperty("url");
	    
	    P6DriverManagerDataSource ds = 
		new P6DriverManagerDataSource();	    

	    ds.setUrl(url);

	    con = ds.getConnection(user, password);
	    st  = con.createStatement();
	    st.execute("create table foo (col1 varchar2(255))");
	    st.execute("insert into table foo values ('1')");

	    ResultSet rs   = st.executeQuery("select count(*) from foo");
	    //assertTrue(rs.

	} catch (Exception e) {
	    e.printStackTrace(System.out);
	    fail("unexpected exception: " + e);
	} finally {

	}
    }

}