/**
 * 
 */
package testsuite.simple;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.util.Properties;

import testsuite.BaseTestCase;

public class TestBug42183 extends BaseTestCase {

	public TestBug42183(String name) {
		super(name);
		// TODO Auto-generated constructor stub
	}
	public void testBug42183() throws Exception {
	    	try {
	    		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"));

	    		createTable("`bug42183`", "(err VARCHAR(250) NOT NULL PRIMARY KEY, role INTEGER, rating DOUBLE, stat INTEGER, poscomment TEXT, negcomment TEXT, subjcomment TEXT);");// ENGINE=InnoDB;");
	    		createProcedure("procbug42183", "(IN in_err varchar(250))"
		 				   + "\nBEGIN\nSELECT * FROM bug42183 WHERE bug42183.err <> in_err;\nEND");
	    		this.stmt.executeUpdate("insert into bug42183 (err, role) VALUES ('aaa', 5)");
	    		
				Properties props = new Properties();
				props.setProperty("noAccessToProcedureBodies", "true");
				props.setProperty("emulateUnsupportedPstmts", "true");
				props.setProperty("useServerPrepStmts", "false");
				props.setProperty("jdbcCompliantTruncation", "false");
				props.setProperty("cacheCallableStmts", "false");
				props.setProperty("elideSetAutoCommits", "true");
				props.setProperty("cachePrepStmts", "true");
				props.setProperty("cacheResultSetMetadata", "true");
				props.setProperty("zeroDateTimeBehavior", "convertToNull");
				//props.setProperty("profileSQL", "true");

				Connection profiledConn = getConnectionWithProps(props);
	    		CallableStatement cStmt = profiledConn.prepareCall("{call procbug42183(?)}");
	    		cStmt.setString(1, "bbb");
	    		cStmt.execute();
	    	}
	    	finally {
	    		closeMemberJDBCResources();
		}
	}

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

}