/**
 * 
 */
package testsuite.simple;

import java.sql.CallableStatement;

import testsuite.BaseTestCase;

/**
 * @author Administrator
 *
 */
public class TestBug46015 extends BaseTestCase {

	/**
	 * @param name
	 */
	public TestBug46015(String name) {
		super(name);
		// TODO Auto-generated constructor stub
	}
	public void testBug46015() 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                      : " + System.getProperty("os.name") + ", " + System.getProperty("os.version") + ", " + System.getProperty("os.arch"));
		System.out.println("sun.management.compiler : " + System.getProperty("sun.management.compiler"));
		System.out.println("-------------------------------------------------");

		if (versionMeetsMinimum(5, 0)) {
	
			this.stmt.executeUpdate("DROP PROCEDURE IF EXISTS testBug46015");
			this.stmt.executeUpdate("CREATE PROCEDURE testBug46015()"
					+ "BEGIN"
					+ " SELECT SLEEP(50);"
					+ "\nEND");
		
			try {
			    CallableStatement cstmt = this.conn.prepareCall("{call testBug46015()}");
			    cstmt.setQueryTimeout(10);
			    this.rs = cstmt.executeQuery();
			} finally {
				closeMemberJDBCResources();
			}
		}
	}
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		junit.textui.TestRunner.run(TestBug46015.class);
	}

}