/**
 * 
 */
package testsuite.simple;

import java.io.BufferedInputStream;
import java.io.File;
import java.io.FileInputStream;
import java.sql.ResultSet;
import java.sql.Statement;

import testsuite.BaseTestCase;

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

	/**
	 * @param name
	 */
	public TestBug53002(String name) {
		super(name);
		// TODO Auto-generated constructor stub
	}
	public void testBug53002() 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"));
		if (versionMeetsMinimum(5, 0, 7)) {
			try {
				createTable("bug53002", "(`Rec` bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,`Date` datetime DEFAULT NULL,`Set_Test` set('A','B','C') DEFAULT NULL,`Enum_Test` enum('a','b','c') DEFAULT NULL,`Small_Text` varchar(10) DEFAULT NULL,`Text` varchar(120) DEFAULT NULL,`big_blob` longblob,`big_text` longtext,`var_text` varchar(145) DEFAULT NULL)ENGINE=InnoDB DEFAULT CHARSET=latin1");
				int i = this.stmt.executeUpdate("INSERT INTO `test`.`bug53002`(Rec, big_blob) VALUES(NULL, '')");
				assertEquals(1, i);
				
				Statement stmt2 = this.conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
				ResultSet rs2 = stmt2.executeQuery("SELECT * FROM `test`.`bug53002`");
				System.out.println(rs2);
				rs2.next();
				
				int blobFileSize = 104800; //my max_allowed_packet is 1048576
				File blobFile = newTempBinaryFile("bug53002", blobFileSize);
				
				FileInputStream fileIn=new FileInputStream(blobFile);
			    BufferedInputStream bufIn=new BufferedInputStream(fileIn);
			    rs2.updateBinaryStream("big_blob",bufIn,blobFileSize);
			    rs2.updateRow();
			    bufIn.close();
			    fileIn.close();

			
			
			} finally {
				closeMemberJDBCResources();
			}
		}					
	} 

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

}