import testsuite.BaseTestCase;
import java.sql.ResultSet;
import java.sql.DatabaseMetaData;

public class bug63947 extends BaseTestCase {
	
	public bug63947(String name) {
		super(name);
	}

	public static void main(String[] args) {
		junit.textui.TestRunner.run(bug63947.class);
	}

	public void testBug63947() throws Exception {
		try {
			this.stmt.execute("create or replace view test(a, b) as select 0, 1 union all select 1, 0");
			this.conn.setAutoCommit(false);
			
			StringBuilder qb = new StringBuilder("select * from ");
  
			int rc = 15;
			
			for (int i = 1; i <= rc; i++) {
				qb.append("test r");
				qb.append(i);
				
				if (i < rc) {
					qb.append(", ");
				}
			}
			
			this.stmt.execute(qb.toString());
			this.conn.rollback();
			
			assertFalse("Connection should be opened", this.conn.isClosed());
		} finally {
//	    	closeMemberJDBCResources();
		}
	}
}