/**
 * 
 */
package testsuite.simple;

import testsuite.BaseTestCase;
import com.mysql.jdbc.Driver;
import com.sun.rowset.CachedRowSetImpl;

import java.sql.DriverManager;
import java.util.Properties;

/**
 * @author Tonci
 * -Xmx512M -XX:+UseParallelGC -Dcom.mysql.jdbc.java6.javac=C:\jvms\jdk1.6.0\bin\javac.exe -Dcom.mysql.jdbc.java6.rtjar=C:\jvms\jdk1.6.0\jre\lib\rt.jar -Dcom.mysql.jdbc.testsuite.url.default=jdbc:mysql://opensol:3306/test?user=root&password=**&autoReconnect=false&connectTimeout=5000&socketTimeout=30000&useUnicode=true&characterSetResults=utf8&useInformationSchema=true&useServerPrepStmts=true&cacheResultSetMetadata=true&useAffectedRows=false&traceProtocol=true&useColumnNamesInFindColumn=true
 */
public class TestBug48820 extends BaseTestCase {

	/**
	 * @param name
	 */
	public TestBug48820(String name) {
		super(name);
		// TODO Auto-generated constructor stub
	}
	public void testBug48820() throws Exception {
		System.out.println("java.vm.version         : " + System.getProperty("java.vm.version"));
		System.out.println("java.vm.vendor          : " + System.getProperty("java.vm.vendor"));
		System.out.println("java.runtime.version    : " + System.getProperty("java.runtime.version"));
		System.out.println("os.name                 : " + System.getProperty("os.name"));
		System.out.println("os.version              : " + System.getProperty("os.version "));
		System.out.println("sun.management.compiler : " + System.getProperty("sun.management.compiler"));
    	try {
    		CachedRowSetImpl crs;

    		this.rs = this.stmt.executeQuery("SELECT PASSWORD ('SOMETHING')");
    		this.rs.first();
    		assertEquals("*7AFEFD08B6B720E781FB000CAA418F54FA662626", this.rs.getString(1));
    	
    		java.sql.ResultSetMetaData tblMD = this.rs.getMetaData();
	    	
    		for (int i=1; i<tblMD.getColumnCount()+1; i++)
    		{	
    			System.out.println(i + " " + tblMD.getColumnName(i) + " " +
    					tblMD.getColumnClassName(i) + " " + tblMD.getColumnTypeName(i) + " " +
    					new Integer(tblMD.getColumnDisplaySize(i)));
    		}    		

    		crs = new CachedRowSetImpl();
    		crs.populate(this.rs);
    		crs.first();
    		java.sql.ResultSetMetaData crsMD = crs.getMetaData();
    		for (int i=1; i<crsMD.getColumnCount()+1; i++)
    		{	
    			System.out.println(i + " " + crsMD.getColumnName(i) + " " +
    					crsMD.getColumnClassName(i) + " " + crsMD.getColumnTypeName(i) + " " +
    					new Integer(crsMD.getColumnDisplaySize(i)));
    		}    		
    		
    		assertEquals("*7AFEFD08B6B720E781FB000CAA418F54FA662626", crs.getString(1));
    		
    	} finally {
			closeMemberJDBCResources();
		}
	}

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		junit.textui.TestRunner.run(TestBug48820.class);
	}

}