/** * */ package testsuite.simple; import java.sql.CallableStatement; import java.sql.Connection; import java.util.Properties; import testsuite.BaseTestCase; public class TestBug30464 extends BaseTestCase { public TestBug30464(String name) { super(name); // TODO Auto-generated constructor stub } public void testBug30464() throws Exception { try { createTable("`bug30464`", "(err VARCHAR(250), role INTEGER, rating DOUBLE, stat INTEGER, poscomment TEXT, negcomment TEXT, subjcomment TEXT);");// ENGINE=InnoDB;"); createProcedure("addRoleAssessment3", "(in err varchar(250), in role integer," + "in rating double, in stat integer," + "in poscomment text, in negcomment text, in subjcomment text)" + "\nBEGIN\nINSERT INTO bug30464 VALUES (err, role, rating, stat, poscomment, negcomment, subjcomment);\nEND"); Properties props = new Properties(); props.setProperty("noAccessToProcedureBodies", "true"); props.setProperty("profileSQL", "true"); Connection profiledConn = getConnectionWithProps(props); CallableStatement cStmt = profiledConn.prepareCall("{call addRoleAssessment3(?,?,?,?,?,?,?)}"); cStmt.setString(1, null);//"abc"); cStmt.setInt(2, 1); cStmt.setDouble(3, 2.0D); cStmt.setInt(4, 4); cStmt.setString(5, "Bad"); cStmt.setString(6, null);//"Good"); cStmt.setString(7, "Ugly"); cStmt.execute(); } finally { closeMemberJDBCResources(); } } /** * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub junit.textui.TestRunner.run(TestBug30464.class); } }