resultsettypestests.java

Java Database connection pool

package poolman.tests.basic;

import java.util.*;
import java.sql.*;
import javax.sql.*;
import javax.naming.*;
import javax.transaction.*;
import java.rmi.RemoteException;
import java.rmi.RMISecurityManager;

import junit.framework.*;

import com.codestudio.sql.*;
import com.codestudio.util.JDBCPool;

public class ResultSetTypesTests extends TestCase {


    public ResultSetTypesTests(String name) {
	super(name);
    }

    public static Test suite() {
	return new TestSuite(ResultSetTypesTests.class);
    }

    private Connection getConnection() 
	throws SQLException {
	// load the PoolMan JDBC Driver
	try {
	    Class.forName("com.codestudio.sql.PoolMan").newInstance();
	} catch (Exception ex) {
	    System.out.println("Could Not Find the PoolMan Driver. " +
			       "Is PoolMan.jar in your CLASSPATH?");
	    System.exit(0);
	}
	return DriverManager.getConnection("jdbc:poolman://testdb");
    }
    
    public void testGetFloat() {

	return;
	/*
	String sql = "select float from poolman_type_tests";
	float expectedValue = (new Float(1.012)).floatValue();

	Connection con = null;
	Statement stm = null;
	ResultSet res = null;
	try {
	    con = getConnection();
	    stm = con.createStatement();
	    res = stm.executeQuery(sql);
	    assert(res.getFloat(1) == expectedValue);
	} catch (Exception e) {
	    fail();
	    e.printStackTrace();
	}
	finally {
	    try {
		JDBCPool.closeResources(stm, res);
		con.close();
	    } catch (Exception ee) {}
	}
	*/
    }

}