prepStmt Test StartsexecuteUpdate() without parametersUpdate count is: 0executeUpdate() with parametersUpdate count is: 1execute() with parameters, no result set returnedUpdate count is: 2executQuery() without parametersgot row:  99 5 9got row:  2 6 10got row:  7 5 8end of rowsexecutQuery() with parametersgot row:  99 5 9got row:  7 5 8end of rowsexecute() with parameters with result set returnedgot row:  99 5 9got row:  7 5 8end of rowstest different data types for input parameters of a Prepared StatementUpdate count is: 0Update count is: 1test setObject on different data types for input  parameters of a Prepared StatementUpdate count is: 1test setNull on different data types for input  parameters of a Prepared StatementUpdate count is: 1got row:  1 2 3 4.0 5.0 6.0 77.77 8.100 column9string        column10vcstring column11lvcstring 0123456789abcdef10111213202020 0123456789abcdef10111213 0123456789abcdef10111213 xxxxxxFILTERED-TIMESTAMPxxxxx-04-12 11:44:30.0Timestamp match!got row:  1 2 3 4.0 5.0 6.0 77.77 8.100 column11string       column10vcstring column11lvcstring 0123456789abcdef10111213202020 0123456789abcdef10111213 0123456789abcdef10111213 xxxxxxFILTERED-TIMESTAMPxxxxx-04-12 11:44:30.0Timestamp match!got row:  0 0 0 0.0 0.0 0.0 null null null null null null null null null null xxxxxxFILTERED-TIMESTAMPxxxxxAfter first Timestamp!end of rowsSQLState: 07000 message: At least one parameter to the current statement is uninitialized.SQLState: 07000 message: At least one parameter to the current statement is uninitialized.insertTab ( bigtab,50)insertTab ( bigtab,200)insertTab ( bigtab,300)insertTab ( bigtab,500)insertTab ( bigtab,1000)select * from bigtabCol # 500 = null  Col 1000 = nullCol # 500 = null  Col 1000 = nullCol # 500 = null  Col 1000 = nullCol # 500 = 500  Col 1000 = nullCol # 500 = 500  Col 1000 = 1000Insert wrong column nameinsertTab ( bigtab,1001)SQLState: 42X14 message: 'C1001' is not a column in table or VTI 'APP.BIGTAB'.Expected Syntax error insertTab ( bigtab,0)SQLState: 42X01 message: Syntax error: Encountered "<EOF>" at line 1, column 29.Expected Table does not exist insertTab ( wrongtab,1000)SQLState: 42X05 message: Table 'WRONGTAB' does not exist.CREATE TABLE doubletab (i int, doubleVal DOUBLE)testBigDecimalToDoubleConversion(). Check that values are preserved when BigDecimal  values which have more than 31 digits are converted  to Double with setObjectPASS: Actual value 1.0E-130 matches expected value: 1.0E-130PASS: Actual value 1.0E125 matches expected value: 1.0E125PASS: Actual value -1.0E124 matches expected value: -1.0E124PASS: Actual value 1.2345678901234567E31 matches expected value: 1.2345678901234567E31PASS: Actual value 1.2345678901234567 matches expected value: 1.2345678901234567testBigDecimalSetObjectWithScale(). Pass scale parameter of setObjectPASS: Actual value 2.330000 matches expected value: 2.33Minimum BigDecimal Value: 1E-15Prepared Statement String: update Numeric_Tab set NULL_VAL=?Select NULL_VAL from Numeric_TabReturned BigDecimal Value after Updation: 1E-15Value returned from stmt: 1E-15setObject Method sets the designated parameter with the ObjectNegative test setString with Invalid Timestamp:20SQLState: 22007 message: The syntax of the string representation of a datetime value is incorrect.Test jira614 completed successfully -- no Distributed Protocol Exception occurredJira170: caught expected table not foundIteration 1 successful: 555 parameter markers successfully prepared and executed.Test jira125 successful: 557 parameter markers successfully prepared and executed.JIRA-1454 repro with c2 len=12748Fetched a row, c2.length=12748JIRA-1454 repro with c2 len=12750Fetched a row, c2.length=12750JIRA-1454 repro with c2 len=12749Fetched a row, c2.length=12749prepStmt Test Ends