/**
 * 
 */
package testsuite.simple;

import java.sql.ResultSet;
import java.sql.Statement;

import testsuite.BaseTestCase;

/**
 * @author Tonci
 *
 */

public class TestBug44056 extends BaseTestCase {

	/**
	 * @param name
	 */
	public TestBug44056(String name) {
		super(name);
		// TODO Auto-generated constructor stub
	}

	public void testBug44056() 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 {
			createTable("bug44056", "(Id int not null auto_increment, entry varchar(10) not null, primary key (Id)) engine=innodb");
			this.conn.setAutoCommit(false);
			
			this.pstmt = this.conn.prepareStatement("insert into bug44056 (entry) values (?)",Statement.RETURN_GENERATED_KEYS);
            for (int i=0; i< 100000; i++) {
            	this.pstmt.setString(1, "test");
            	this.pstmt.executeUpdate();
            
            	this.rs = this.pstmt.getGeneratedKeys();
                while (this.rs.next()) {
                    System.out.println(this.rs.getInt(1));
                }
                this.rs.close();
            }
            this.pstmt.close();
            System.out.println("Something stupid");
    	} finally {
			closeMemberJDBCResources();
		}
	}

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

}