You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by dj...@apache.org on 2005/06/11 17:13:40 UTC

svn commit: r190127 [2/2] - in /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/DerbyNet/parameterMapping.out master/DerbyNetClient/parameterMapping.out master/j9_13/parameterMapping.out master/parameterMapping.out tests/jdbcapi/parameterMapping.java

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/parameterMapping.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/parameterMapping.out?rev=190127&r1=190126&r2=190127&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/parameterMapping.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/parameterMapping.out Sat Jun 11 08:13:39 2005
@@ -92,24 +92,39 @@
 setXXX() with all JDBC Types on SMALLINT
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getShort=98 was null false JDBC MATCH(OK)
+  setByte() as batch getShort=98 was null false JDBC MATCH(OK)
   setShort() getShort=98 was null false JDBC MATCH(OK)
+  setShort() as batch getShort=98 was null false JDBC MATCH(OK)
   setInt() getShort=98 was null false JDBC MATCH(OK)
+  setInt() as batch getShort=98 was null false JDBC MATCH(OK)
   setLong() getShort=98 was null false JDBC MATCH(OK)
+  setLong() as batch getShort=98 was null false JDBC MATCH(OK)
   setFloat() getShort=98 was null false JDBC MATCH(OK)
+  setFloat() as batch getShort=98 was null false JDBC MATCH(OK)
   setDouble() getShort=98 was null false JDBC MATCH(OK)
+  setDouble() as batch getShort=98 was null false JDBC MATCH(OK)
   setBigDecimal() getShort=99 was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getShort=99 was null false JDBC MATCH(OK)
   setBigDecimal(null) getShort=0 was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getShort=0 was null true JDBC MATCH(OK)
   setBoolean() getShort=1 was null false JDBC MATCH(OK)
+  setBoolean() as batch getShort=1 was null false JDBC MATCH(OK)
   setString() getShort=97 was null false JDBC MATCH(OK)
+  setString() as batch getShort=97 was null false JDBC MATCH(OK)
   setString(null) getShort=0 was null true JDBC MATCH(OK)
+  setString(null) as batch getShort=0 was null true JDBC MATCH(OK)
   setBytes() IC JDBC MATCH (INVALID)
   setBytes(null) IC JDBC MATCH (INVALID)
   setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
   setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
   setTime() IC JDBC MATCH (INVALID)
   setTime(null) IC JDBC MATCH (INVALID)
   setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
   setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
   setAsciiStream() IC JDBC MATCH (INVALID)
   setAsciiStream(null) IC JDBC MATCH (INVALID)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -288,24 +303,39 @@
 setXXX() with all JDBC Types on INTEGER
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getInt=98 was null false JDBC MATCH(OK)
+  setByte() as batch getInt=98 was null false JDBC MATCH(OK)
   setShort() getInt=98 was null false JDBC MATCH(OK)
+  setShort() as batch getInt=98 was null false JDBC MATCH(OK)
   setInt() getInt=98 was null false JDBC MATCH(OK)
+  setInt() as batch getInt=98 was null false JDBC MATCH(OK)
   setLong() getInt=98 was null false JDBC MATCH(OK)
+  setLong() as batch getInt=98 was null false JDBC MATCH(OK)
   setFloat() getInt=98 was null false JDBC MATCH(OK)
+  setFloat() as batch getInt=98 was null false JDBC MATCH(OK)
   setDouble() getInt=98 was null false JDBC MATCH(OK)
+  setDouble() as batch getInt=98 was null false JDBC MATCH(OK)
   setBigDecimal() getInt=99 was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getInt=99 was null false JDBC MATCH(OK)
   setBigDecimal(null) getInt=0 was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getInt=0 was null true JDBC MATCH(OK)
   setBoolean() getInt=1 was null false JDBC MATCH(OK)
+  setBoolean() as batch getInt=1 was null false JDBC MATCH(OK)
   setString() getInt=97 was null false JDBC MATCH(OK)
+  setString() as batch getInt=97 was null false JDBC MATCH(OK)
   setString(null) getInt=0 was null true JDBC MATCH(OK)
+  setString(null) as batch getInt=0 was null true JDBC MATCH(OK)
   setBytes() IC JDBC MATCH (INVALID)
   setBytes(null) IC JDBC MATCH (INVALID)
   setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
   setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
   setTime() IC JDBC MATCH (INVALID)
   setTime(null) IC JDBC MATCH (INVALID)
   setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
   setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
   setAsciiStream() IC JDBC MATCH (INVALID)
   setAsciiStream(null) IC JDBC MATCH (INVALID)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -484,24 +514,39 @@
 setXXX() with all JDBC Types on BIGINT
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getLong=98 was null false JDBC MATCH(OK)
+  setByte() as batch getLong=98 was null false JDBC MATCH(OK)
   setShort() getLong=98 was null false JDBC MATCH(OK)
+  setShort() as batch getLong=98 was null false JDBC MATCH(OK)
   setInt() getLong=98 was null false JDBC MATCH(OK)
+  setInt() as batch getLong=98 was null false JDBC MATCH(OK)
   setLong() getLong=98 was null false JDBC MATCH(OK)
+  setLong() as batch getLong=98 was null false JDBC MATCH(OK)
   setFloat() getLong=98 was null false JDBC MATCH(OK)
+  setFloat() as batch getLong=98 was null false JDBC MATCH(OK)
   setDouble() getLong=98 was null false JDBC MATCH(OK)
+  setDouble() as batch getLong=98 was null false JDBC MATCH(OK)
   setBigDecimal() getLong=99 was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getLong=99 was null false JDBC MATCH(OK)
   setBigDecimal(null) getLong=0 was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getLong=0 was null true JDBC MATCH(OK)
   setBoolean() getLong=1 was null false JDBC MATCH(OK)
+  setBoolean() as batch getLong=1 was null false JDBC MATCH(OK)
   setString() getLong=97 was null false JDBC MATCH(OK)
+  setString() as batch getLong=97 was null false JDBC MATCH(OK)
   setString(null) getLong=0 was null true JDBC MATCH(OK)
+  setString(null) as batch getLong=0 was null true JDBC MATCH(OK)
   setBytes() IC JDBC MATCH (INVALID)
   setBytes(null) IC JDBC MATCH (INVALID)
   setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
   setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
   setTime() IC JDBC MATCH (INVALID)
   setTime(null) IC JDBC MATCH (INVALID)
   setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
   setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
   setAsciiStream() IC JDBC MATCH (INVALID)
   setAsciiStream(null) IC JDBC MATCH (INVALID)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -680,24 +725,39 @@
 setXXX() with all JDBC Types on REAL
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getFloat=98.0 was null false JDBC MATCH(OK)
+  setByte() as batch getFloat=98.0 was null false JDBC MATCH(OK)
   setShort() getFloat=98.0 was null false JDBC MATCH(OK)
+  setShort() as batch getFloat=98.0 was null false JDBC MATCH(OK)
   setInt() getFloat=98.0 was null false JDBC MATCH(OK)
+  setInt() as batch getFloat=98.0 was null false JDBC MATCH(OK)
   setLong() getFloat=98.0 was null false JDBC MATCH(OK)
+  setLong() as batch getFloat=98.0 was null false JDBC MATCH(OK)
   setFloat() getFloat=98.4 was null false JDBC MATCH(OK)
+  setFloat() as batch getFloat=98.4 was null false JDBC MATCH(OK)
   setDouble() getFloat=98.5 was null false JDBC MATCH(OK)
+  setDouble() as batch getFloat=98.5 was null false JDBC MATCH(OK)
   setBigDecimal() getFloat=99.0 was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getFloat=99.0 was null false JDBC MATCH(OK)
   setBigDecimal(null) getFloat=0.0 was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getFloat=0.0 was null true JDBC MATCH(OK)
   setBoolean() getFloat=1.0 was null false JDBC MATCH(OK)
+  setBoolean() as batch getFloat=1.0 was null false JDBC MATCH(OK)
   setString() getFloat=97.0 was null false JDBC MATCH(OK)
+  setString() as batch getFloat=97.0 was null false JDBC MATCH(OK)
   setString(null) getFloat=0.0 was null true JDBC MATCH(OK)
+  setString(null) as batch getFloat=0.0 was null true JDBC MATCH(OK)
   setBytes() IC JDBC MATCH (INVALID)
   setBytes(null) IC JDBC MATCH (INVALID)
   setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
   setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
   setTime() IC JDBC MATCH (INVALID)
   setTime(null) IC JDBC MATCH (INVALID)
   setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
   setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
   setAsciiStream() IC JDBC MATCH (INVALID)
   setAsciiStream(null) IC JDBC MATCH (INVALID)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -877,24 +937,39 @@
 setXXX() with all JDBC Types on FLOAT
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getDouble=98.0 was null false JDBC MATCH(OK)
+  setByte() as batch getDouble=98.0 was null false JDBC MATCH(OK)
   setShort() getDouble=98.0 was null false JDBC MATCH(OK)
+  setShort() as batch getDouble=98.0 was null false JDBC MATCH(OK)
   setInt() getDouble=98.0 was null false JDBC MATCH(OK)
+  setInt() as batch getDouble=98.0 was null false JDBC MATCH(OK)
   setLong() getDouble=98.0 was null false JDBC MATCH(OK)
+  setLong() as batch getDouble=98.0 was null false JDBC MATCH(OK)
   setFloat() getDouble=98.4000015258789 was null false JDBC MATCH(OK)
+  setFloat() as batch getDouble=98.4000015258789 was null false JDBC MATCH(OK)
   setDouble() getDouble=98.5 was null false JDBC MATCH(OK)
+  setDouble() as batch getDouble=98.5 was null false JDBC MATCH(OK)
   setBigDecimal() getDouble=99.0 was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getDouble=99.0 was null false JDBC MATCH(OK)
   setBigDecimal(null) getDouble=0.0 was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getDouble=0.0 was null true JDBC MATCH(OK)
   setBoolean() getDouble=1.0 was null false JDBC MATCH(OK)
+  setBoolean() as batch getDouble=1.0 was null false JDBC MATCH(OK)
   setString() getDouble=97.0 was null false JDBC MATCH(OK)
+  setString() as batch getDouble=97.0 was null false JDBC MATCH(OK)
   setString(null) getDouble=0.0 was null true JDBC MATCH(OK)
+  setString(null) as batch getDouble=0.0 was null true JDBC MATCH(OK)
   setBytes() IC JDBC MATCH (INVALID)
   setBytes(null) IC JDBC MATCH (INVALID)
   setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
   setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
   setTime() IC JDBC MATCH (INVALID)
   setTime(null) IC JDBC MATCH (INVALID)
   setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
   setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
   setAsciiStream() IC JDBC MATCH (INVALID)
   setAsciiStream(null) IC JDBC MATCH (INVALID)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -1073,24 +1148,39 @@
 setXXX() with all JDBC Types on DOUBLE
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getDouble=98.0 was null false JDBC MATCH(OK)
+  setByte() as batch getDouble=98.0 was null false JDBC MATCH(OK)
   setShort() getDouble=98.0 was null false JDBC MATCH(OK)
+  setShort() as batch getDouble=98.0 was null false JDBC MATCH(OK)
   setInt() getDouble=98.0 was null false JDBC MATCH(OK)
+  setInt() as batch getDouble=98.0 was null false JDBC MATCH(OK)
   setLong() getDouble=98.0 was null false JDBC MATCH(OK)
+  setLong() as batch getDouble=98.0 was null false JDBC MATCH(OK)
   setFloat() getDouble=98.4000015258789 was null false JDBC MATCH(OK)
+  setFloat() as batch getDouble=98.4000015258789 was null false JDBC MATCH(OK)
   setDouble() getDouble=98.5 was null false JDBC MATCH(OK)
+  setDouble() as batch getDouble=98.5 was null false JDBC MATCH(OK)
   setBigDecimal() getDouble=99.0 was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getDouble=99.0 was null false JDBC MATCH(OK)
   setBigDecimal(null) getDouble=0.0 was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getDouble=0.0 was null true JDBC MATCH(OK)
   setBoolean() getDouble=1.0 was null false JDBC MATCH(OK)
+  setBoolean() as batch getDouble=1.0 was null false JDBC MATCH(OK)
   setString() getDouble=97.0 was null false JDBC MATCH(OK)
+  setString() as batch getDouble=97.0 was null false JDBC MATCH(OK)
   setString(null) getDouble=0.0 was null true JDBC MATCH(OK)
+  setString(null) as batch getDouble=0.0 was null true JDBC MATCH(OK)
   setBytes() IC JDBC MATCH (INVALID)
   setBytes(null) IC JDBC MATCH (INVALID)
   setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
   setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
   setTime() IC JDBC MATCH (INVALID)
   setTime(null) IC JDBC MATCH (INVALID)
   setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
   setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
   setAsciiStream() IC JDBC MATCH (INVALID)
   setAsciiStream(null) IC JDBC MATCH (INVALID)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -1269,24 +1359,39 @@
 setXXX() with all JDBC Types on DECIMAL(10,5)
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getBigDecimal=98.00000 was null false JDBC MATCH(OK)
+  setByte() as batch getBigDecimal=98.00000 was null false JDBC MATCH(OK)
   setShort() getBigDecimal=98.00000 was null false JDBC MATCH(OK)
+  setShort() as batch getBigDecimal=98.00000 was null false JDBC MATCH(OK)
   setInt() getBigDecimal=98.00000 was null false JDBC MATCH(OK)
+  setInt() as batch getBigDecimal=98.00000 was null false JDBC MATCH(OK)
   setLong() getBigDecimal=98.00000 was null false JDBC MATCH(OK)
+  setLong() as batch getBigDecimal=98.00000 was null false JDBC MATCH(OK)
   setFloat() getBigDecimal=98.40000 was null false JDBC MATCH(OK)
+  setFloat() as batch getBigDecimal=98.40000 was null false JDBC MATCH(OK)
   setDouble() getBigDecimal=98.50000 was null false JDBC MATCH(OK)
+  setDouble() as batch getBigDecimal=98.50000 was null false JDBC MATCH(OK)
   setBigDecimal() getBigDecimal=99.00000 was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getBigDecimal=99.00000 was null false JDBC MATCH(OK)
   setBigDecimal(null) getBigDecimal=null was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getBigDecimal=null was null true JDBC MATCH(OK)
   setBoolean() getBigDecimal=1.00000 was null false JDBC MATCH(OK)
+  setBoolean() as batch getBigDecimal=1.00000 was null false JDBC MATCH(OK)
   setString() getBigDecimal=97.00000 was null false JDBC MATCH(OK)
+  setString() as batch getBigDecimal=97.00000 was null false JDBC MATCH(OK)
   setString(null) getBigDecimal=null was null true JDBC MATCH(OK)
+  setString(null) as batch getBigDecimal=null was null true JDBC MATCH(OK)
   setBytes() IC JDBC MATCH (INVALID)
   setBytes(null) IC JDBC MATCH (INVALID)
   setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
   setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
   setTime() IC JDBC MATCH (INVALID)
   setTime(null) IC JDBC MATCH (INVALID)
   setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
   setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
   setAsciiStream() IC JDBC MATCH (INVALID)
   setAsciiStream(null) IC JDBC MATCH (INVALID)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -1471,24 +1576,39 @@
 setXXX() with all JDBC Types on CHAR(60)
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getString=98                                                           was null false JDBC MATCH(OK)
+  setByte() as batch getString=98                                                           was null false JDBC MATCH(OK)
   setShort() getString=98                                                           was null false JDBC MATCH(OK)
+  setShort() as batch getString=98                                                           was null false JDBC MATCH(OK)
   setInt() getString=98                                                           was null false JDBC MATCH(OK)
+  setInt() as batch getString=98                                                           was null false JDBC MATCH(OK)
   setLong() getString=98                                                           was null false JDBC MATCH(OK)
+  setLong() as batch getString=98                                                           was null false JDBC MATCH(OK)
   setFloat() getString=98.4                                                         was null false JDBC MATCH(OK)
+  setFloat() as batch getString=98.4                                                         was null false JDBC MATCH(OK)
   setDouble() getString=98.5                                                         was null false JDBC MATCH(OK)
+  setDouble() as batch getString=98.5                                                         was null false JDBC MATCH(OK)
   setBigDecimal() getString=99                                                           was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getString=99                                                           was null false JDBC MATCH(OK)
   setBigDecimal(null) getString=null was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getString=null was null true JDBC MATCH(OK)
   setBoolean() getString=1                                                            was null false JDBC MATCH(OK)
+  setBoolean() as batch getString=1                                                            was null false JDBC MATCH(OK)
   setString() getString=97                                                           was null false JDBC MATCH(OK)
+  setString() as batch getString=97                                                           was null false JDBC MATCH(OK)
   setString(null) getString=null was null true JDBC MATCH(OK)
+  setString(null) as batch getString=null was null true JDBC MATCH(OK)
   setBytes() getString=EncodedString: > 1027 64963 29440 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 < was null false CLOUD EXT (OK)
   setBytes(null) getString=null was null true CLOUD EXT (OK)
   setDate() getString=2004-02-14                                                   was null false JDBC MATCH(OK)
+  setDate() as batch getString=2004-02-14                                                   was null false JDBC MATCH(OK)
   setDate(null) getString=null was null true JDBC MATCH(OK)
+  setDate(null) as batch getString=null was null true JDBC MATCH(OK)
   setTime() getString=13:26:42                                                     was null false JDBC MATCH(OK)
   setTime(null) getString=null was null true JDBC MATCH(OK)
   setTimestamp() getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
+  setTimestamp() as batch getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
   setTimestamp(null) getString=null was null true JDBC MATCH(OK)
+  setTimestamp(null) as batch getString=null was null true JDBC MATCH(OK)
   setAsciiStream() getString=eg012d                                                       was null false JDBC MATCH(OK)
   setAsciiStream(null) getString=null was null true JDBC MATCH(OK)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -1662,24 +1782,39 @@
 setXXX() with all JDBC Types on VARCHAR(60)
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getString=98 was null false JDBC MATCH(OK)
+  setByte() as batch getString=98 was null false JDBC MATCH(OK)
   setShort() getString=98 was null false JDBC MATCH(OK)
+  setShort() as batch getString=98 was null false JDBC MATCH(OK)
   setInt() getString=98 was null false JDBC MATCH(OK)
+  setInt() as batch getString=98 was null false JDBC MATCH(OK)
   setLong() getString=98 was null false JDBC MATCH(OK)
+  setLong() as batch getString=98 was null false JDBC MATCH(OK)
   setFloat() getString=98.4 was null false JDBC MATCH(OK)
+  setFloat() as batch getString=98.4 was null false JDBC MATCH(OK)
   setDouble() getString=98.5 was null false JDBC MATCH(OK)
+  setDouble() as batch getString=98.5 was null false JDBC MATCH(OK)
   setBigDecimal() getString=99 was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getString=99 was null false JDBC MATCH(OK)
   setBigDecimal(null) getString=null was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getString=null was null true JDBC MATCH(OK)
   setBoolean() getString=1 was null false JDBC MATCH(OK)
+  setBoolean() as batch getString=1 was null false JDBC MATCH(OK)
   setString() getString=97 was null false JDBC MATCH(OK)
+  setString() as batch getString=97 was null false JDBC MATCH(OK)
   setString(null) getString=null was null true JDBC MATCH(OK)
+  setString(null) as batch getString=null was null true JDBC MATCH(OK)
   setBytes() getString=EncodedString: > 1027 64963 29440 < was null false CLOUD EXT (OK)
   setBytes(null) getString=null was null true CLOUD EXT (OK)
   setDate() getString=2004-02-14 was null false JDBC MATCH(OK)
+  setDate() as batch getString=2004-02-14 was null false JDBC MATCH(OK)
   setDate(null) getString=null was null true JDBC MATCH(OK)
+  setDate(null) as batch getString=null was null true JDBC MATCH(OK)
   setTime() getString=13:26:42 was null false JDBC MATCH(OK)
   setTime(null) getString=null was null true JDBC MATCH(OK)
   setTimestamp() getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
+  setTimestamp() as batch getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
   setTimestamp(null) getString=null was null true JDBC MATCH(OK)
+  setTimestamp(null) as batch getString=null was null true JDBC MATCH(OK)
   setAsciiStream() getString=eg012d was null false JDBC MATCH(OK)
   setAsciiStream(null) getString=null was null true JDBC MATCH(OK)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -1853,24 +1988,39 @@
 setXXX() with all JDBC Types on LONG VARCHAR
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getString=98 was null false JDBC MATCH(OK)
+  setByte() as batch getString=98 was null false JDBC MATCH(OK)
   setShort() getString=98 was null false JDBC MATCH(OK)
+  setShort() as batch getString=98 was null false JDBC MATCH(OK)
   setInt() getString=98 was null false JDBC MATCH(OK)
+  setInt() as batch getString=98 was null false JDBC MATCH(OK)
   setLong() getString=98 was null false JDBC MATCH(OK)
+  setLong() as batch getString=98 was null false JDBC MATCH(OK)
   setFloat() getString=98.4 was null false JDBC MATCH(OK)
+  setFloat() as batch getString=98.4 was null false JDBC MATCH(OK)
   setDouble() getString=98.5 was null false JDBC MATCH(OK)
+  setDouble() as batch getString=98.5 was null false JDBC MATCH(OK)
   setBigDecimal() getString=99 was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getString=99 was null false JDBC MATCH(OK)
   setBigDecimal(null) getString=null was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getString=null was null true JDBC MATCH(OK)
   setBoolean() getString=1 was null false JDBC MATCH(OK)
+  setBoolean() as batch getString=1 was null false JDBC MATCH(OK)
   setString() getString=97 was null false JDBC MATCH(OK)
+  setString() as batch getString=97 was null false JDBC MATCH(OK)
   setString(null) getString=null was null true JDBC MATCH(OK)
+  setString(null) as batch getString=null was null true JDBC MATCH(OK)
   setBytes() getString=EncodedString: > 1027 64963 29440 < was null false CLOUD EXT (OK)
   setBytes(null) getString=null was null true CLOUD EXT (OK)
   setDate() getString=2004-02-14 was null false JDBC MATCH(OK)
+  setDate() as batch getString=2004-02-14 was null false JDBC MATCH(OK)
   setDate(null) getString=null was null true JDBC MATCH(OK)
+  setDate(null) as batch getString=null was null true JDBC MATCH(OK)
   setTime() getString=13:26:42 was null false JDBC MATCH(OK)
   setTime(null) getString=null was null true JDBC MATCH(OK)
   setTimestamp() getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
+  setTimestamp() as batch getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
   setTimestamp(null) getString=null was null true JDBC MATCH(OK)
+  setTimestamp(null) as batch getString=null was null true JDBC MATCH(OK)
   setAsciiStream() getString=eg012d was null false JDBC MATCH(OK)
   setAsciiStream(null) getString=null was null true JDBC MATCH(OK)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -1990,24 +2140,39 @@
 setXXX() with all JDBC Types on VARCHAR(60) FOR BIT DATA
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() IC JDBC MATCH (INVALID)
+  setByte() as batch IC JDBC MATCH (INVALID)
   setShort() IC JDBC MATCH (INVALID)
+  setShort() as batch IC JDBC MATCH (INVALID)
   setInt() IC JDBC MATCH (INVALID)
+  setInt() as batch IC JDBC MATCH (INVALID)
   setLong() IC JDBC MATCH (INVALID)
+  setLong() as batch IC JDBC MATCH (INVALID)
   setFloat() IC JDBC MATCH (INVALID)
+  setFloat() as batch IC JDBC MATCH (INVALID)
   setDouble() IC JDBC MATCH (INVALID)
+  setDouble() as batch IC JDBC MATCH (INVALID)
   setBigDecimal() IC JDBC MATCH (INVALID)
+  setBigDecimal() as batch IC JDBC MATCH (INVALID)
   setBigDecimal(null) IC JDBC MATCH (INVALID)
+  setBigDecimal(null) as batch IC JDBC MATCH (INVALID)
   setBoolean() IC JDBC MATCH (INVALID)
+  setBoolean() as batch IC JDBC MATCH (INVALID)
   setString() IC JDBC MATCH (INVALID)
+  setString() as batch IC JDBC MATCH (INVALID)
   setString(null) IC JDBC MATCH (INVALID)
+  setString(null) as batch IC JDBC MATCH (INVALID)
   setBytes() getBytes=0x4,0x3 was null false JDBC MATCH(OK)
   setBytes(null) getBytes=null was null true JDBC MATCH(OK)
   setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
   setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
   setTime() IC JDBC MATCH (INVALID)
   setTime(null) IC JDBC MATCH (INVALID)
   setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
   setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
   setAsciiStream() IC JDBC MATCH (INVALID)
   setAsciiStream(null) IC JDBC MATCH (INVALID)
   setBinaryStream() getBytes=0x82,0x43 was null false JDBC MATCH(OK)
@@ -2166,24 +2331,39 @@
 setXXX() with all JDBC Types on DATE
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() IC JDBC MATCH (INVALID)
+  setByte() as batch IC JDBC MATCH (INVALID)
   setShort() IC JDBC MATCH (INVALID)
+  setShort() as batch IC JDBC MATCH (INVALID)
   setInt() IC JDBC MATCH (INVALID)
+  setInt() as batch IC JDBC MATCH (INVALID)
   setLong() IC JDBC MATCH (INVALID)
+  setLong() as batch IC JDBC MATCH (INVALID)
   setFloat() IC JDBC MATCH (INVALID)
+  setFloat() as batch IC JDBC MATCH (INVALID)
   setDouble() IC JDBC MATCH (INVALID)
+  setDouble() as batch IC JDBC MATCH (INVALID)
   setBigDecimal() IC JDBC MATCH (INVALID)
+  setBigDecimal() as batch IC JDBC MATCH (INVALID)
   setBigDecimal(null) IC JDBC MATCH (INVALID)
+  setBigDecimal(null) as batch IC JDBC MATCH (INVALID)
   setBoolean() IC JDBC MATCH (INVALID)
+  setBoolean() as batch IC JDBC MATCH (INVALID)
   setString()  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL DATE
+  setString() as batch  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL DATE
   setString(null) getDate=null was null true JDBC MATCH(OK)
+  setString(null) as batch getDate=null was null true JDBC MATCH(OK)
   setBytes() IC JDBC MATCH (INVALID)
   setBytes(null) IC JDBC MATCH (INVALID)
   setDate() getDate=2004-02-14 was null false JDBC MATCH(OK)
+  setDate() as batch getDate=2004-02-14 was null false JDBC MATCH(OK)
   setDate(null) getDate=null was null true JDBC MATCH(OK)
+  setDate(null) as batch getDate=null was null true JDBC MATCH(OK)
   setTime() IC JDBC MATCH (INVALID)
   setTime(null) IC JDBC MATCH (INVALID)
   setTimestamp() getDate=2004-02-23 was null false JDBC MATCH(OK)
+  setTimestamp() as batch getDate=2004-02-23 was null false JDBC MATCH(OK)
   setTimestamp(null) getDate=null was null true JDBC MATCH(OK)
+  setTimestamp(null) as batch getDate=null was null true JDBC MATCH(OK)
   setAsciiStream() IC JDBC MATCH (INVALID)
   setAsciiStream(null) IC JDBC MATCH (INVALID)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -2344,24 +2524,39 @@
 setXXX() with all JDBC Types on TIME
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() IC JDBC MATCH (INVALID)
+  setByte() as batch IC JDBC MATCH (INVALID)
   setShort() IC JDBC MATCH (INVALID)
+  setShort() as batch IC JDBC MATCH (INVALID)
   setInt() IC JDBC MATCH (INVALID)
+  setInt() as batch IC JDBC MATCH (INVALID)
   setLong() IC JDBC MATCH (INVALID)
+  setLong() as batch IC JDBC MATCH (INVALID)
   setFloat() IC JDBC MATCH (INVALID)
+  setFloat() as batch IC JDBC MATCH (INVALID)
   setDouble() IC JDBC MATCH (INVALID)
+  setDouble() as batch IC JDBC MATCH (INVALID)
   setBigDecimal() IC JDBC MATCH (INVALID)
+  setBigDecimal() as batch IC JDBC MATCH (INVALID)
   setBigDecimal(null) IC JDBC MATCH (INVALID)
+  setBigDecimal(null) as batch IC JDBC MATCH (INVALID)
   setBoolean() IC JDBC MATCH (INVALID)
+  setBoolean() as batch IC JDBC MATCH (INVALID)
   setString()  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIME
+  setString() as batch  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIME
   setString(null) getTime=null was null true JDBC MATCH(OK)
+  setString(null) as batch getTime=null was null true JDBC MATCH(OK)
   setBytes() IC JDBC MATCH (INVALID)
   setBytes(null) IC JDBC MATCH (INVALID)
   setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
   setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
   setTime() getTime=13:26:42 was null false JDBC MATCH(OK)
   setTime(null) getTime=null was null true JDBC MATCH(OK)
   setTimestamp() getTime=17:14:24 was null false JDBC MATCH(OK)
+  setTimestamp() as batch getTime=17:14:24 was null false JDBC MATCH(OK)
   setTimestamp(null) getTime=null was null true JDBC MATCH(OK)
+  setTimestamp(null) as batch getTime=null was null true JDBC MATCH(OK)
   setAsciiStream() IC JDBC MATCH (INVALID)
   setAsciiStream(null) IC JDBC MATCH (INVALID)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -2523,24 +2718,39 @@
 setXXX() with all JDBC Types on TIMESTAMP
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() IC JDBC MATCH (INVALID)
+  setByte() as batch IC JDBC MATCH (INVALID)
   setShort() IC JDBC MATCH (INVALID)
+  setShort() as batch IC JDBC MATCH (INVALID)
   setInt() IC JDBC MATCH (INVALID)
+  setInt() as batch IC JDBC MATCH (INVALID)
   setLong() IC JDBC MATCH (INVALID)
+  setLong() as batch IC JDBC MATCH (INVALID)
   setFloat() IC JDBC MATCH (INVALID)
+  setFloat() as batch IC JDBC MATCH (INVALID)
   setDouble() IC JDBC MATCH (INVALID)
+  setDouble() as batch IC JDBC MATCH (INVALID)
   setBigDecimal() IC JDBC MATCH (INVALID)
+  setBigDecimal() as batch IC JDBC MATCH (INVALID)
   setBigDecimal(null) IC JDBC MATCH (INVALID)
+  setBigDecimal(null) as batch IC JDBC MATCH (INVALID)
   setBoolean() IC JDBC MATCH (INVALID)
+  setBoolean() as batch IC JDBC MATCH (INVALID)
   setString()  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIMESTAMP
+  setString() as batch  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIMESTAMP
   setString(null) getTimestamp=null was null true JDBC MATCH(OK)
+  setString(null) as batch getTimestamp=null was null true JDBC MATCH(OK)
   setBytes() IC JDBC MATCH (INVALID)
   setBytes(null) IC JDBC MATCH (INVALID)
   setDate() getTimestamp=00:00:00 was null false JDBC MATCH(OK)
+  setDate() as batch getTimestamp=00:00:00 was null false JDBC MATCH(OK)
   setDate(null) getTimestamp=null was null true JDBC MATCH(OK)
+  setDate(null) as batch getTimestamp=null was null true JDBC MATCH(OK)
   setTime() getTimestamp=13:26:42 was null false JDBC MATCH(OK)
   setTime(null) getTimestamp=null was null true JDBC MATCH(OK)
   setTimestamp() getTimestamp=17:14:24 was null false JDBC MATCH(OK)
+  setTimestamp() as batch getTimestamp=17:14:24 was null false JDBC MATCH(OK)
   setTimestamp(null) getTimestamp=null was null true JDBC MATCH(OK)
+  setTimestamp(null) as batch getTimestamp=null was null true JDBC MATCH(OK)
   setAsciiStream() IC JDBC MATCH (INVALID)
   setAsciiStream(null) IC JDBC MATCH (INVALID)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -2702,24 +2912,39 @@
 setXXX() with all JDBC Types on CLOB(1k)
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() IC JDBC MATCH (INVALID)
+  setByte() as batch IC JDBC MATCH (INVALID)
   setShort() IC JDBC MATCH (INVALID)
+  setShort() as batch IC JDBC MATCH (INVALID)
   setInt() IC JDBC MATCH (INVALID)
+  setInt() as batch IC JDBC MATCH (INVALID)
   setLong() IC JDBC MATCH (INVALID)
+  setLong() as batch IC JDBC MATCH (INVALID)
   setFloat() IC JDBC MATCH (INVALID)
+  setFloat() as batch IC JDBC MATCH (INVALID)
   setDouble() IC JDBC MATCH (INVALID)
+  setDouble() as batch IC JDBC MATCH (INVALID)
   setBigDecimal() IC JDBC MATCH (INVALID)
+  setBigDecimal() as batch IC JDBC MATCH (INVALID)
   setBigDecimal(null) IC JDBC MATCH (INVALID)
+  setBigDecimal(null) as batch IC JDBC MATCH (INVALID)
   setBoolean() IC JDBC MATCH (INVALID)
+  setBoolean() as batch IC JDBC MATCH (INVALID)
   setString() getClob=0x39,0x37 was null false CLOUD EXT (OK)
+  setString() as batch getClob=0x39,0x37 was null false CLOUD EXT (OK)
   setString(null) getClob=null was null true CLOUD EXT (OK)
+  setString(null) as batch getClob=null was null true CLOUD EXT (OK)
   setBytes() IC JDBC MATCH (INVALID)
   setBytes(null) IC JDBC MATCH (INVALID)
   setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
   setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
   setTime() IC JDBC MATCH (INVALID)
   setTime(null) IC JDBC MATCH (INVALID)
   setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
   setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
   setAsciiStream() getClob=0x65,0x67 was null false JDBC MATCH(OK)
   setAsciiStream(null) getClob=null was null true JDBC MATCH(OK)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -2837,24 +3062,39 @@
 setXXX() with all JDBC Types on BLOB(1k)
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() IC JDBC MATCH (INVALID)
+  setByte() as batch IC JDBC MATCH (INVALID)
   setShort() IC JDBC MATCH (INVALID)
+  setShort() as batch IC JDBC MATCH (INVALID)
   setInt() IC JDBC MATCH (INVALID)
+  setInt() as batch IC JDBC MATCH (INVALID)
   setLong() IC JDBC MATCH (INVALID)
+  setLong() as batch IC JDBC MATCH (INVALID)
   setFloat() IC JDBC MATCH (INVALID)
+  setFloat() as batch IC JDBC MATCH (INVALID)
   setDouble() IC JDBC MATCH (INVALID)
+  setDouble() as batch IC JDBC MATCH (INVALID)
   setBigDecimal() IC JDBC MATCH (INVALID)
+  setBigDecimal() as batch IC JDBC MATCH (INVALID)
   setBigDecimal(null) IC JDBC MATCH (INVALID)
+  setBigDecimal(null) as batch IC JDBC MATCH (INVALID)
   setBoolean() IC JDBC MATCH (INVALID)
+  setBoolean() as batch IC JDBC MATCH (INVALID)
   setString() IC JDBC MATCH (INVALID)
+  setString() as batch IC JDBC MATCH (INVALID)
   setString(null) IC JDBC MATCH (INVALID)
+  setString(null) as batch IC JDBC MATCH (INVALID)
   setBytes() getBlob=0x4,0x3 was null false CLOUD EXT (OK)
   setBytes(null) getBlob=null was null true CLOUD EXT (OK)
   setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
   setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
   setTime() IC JDBC MATCH (INVALID)
   setTime(null) IC JDBC MATCH (INVALID)
   setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
   setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
   setAsciiStream() IC JDBC MATCH (INVALID)
   setAsciiStream(null) IC JDBC MATCH (INVALID)
   setBinaryStream() getBlob=0x82,0x43 was null false JDBC MATCH(OK)

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/parameterMapping.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/parameterMapping.out?rev=190127&r1=190126&r2=190127&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/parameterMapping.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/parameterMapping.out Sat Jun 11 08:13:39 2005
@@ -92,24 +92,39 @@
 setXXX() with all JDBC Types on SMALLINT
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getShort=98 was null false JDBC MATCH(OK)
+  setByte() as batch getShort=98 was null false JDBC MATCH(OK)
   setShort() getShort=98 was null false JDBC MATCH(OK)
+  setShort() as batch getShort=98 was null false JDBC MATCH(OK)
   setInt() getShort=98 was null false JDBC MATCH(OK)
+  setInt() as batch getShort=98 was null false JDBC MATCH(OK)
   setLong() getShort=98 was null false JDBC MATCH(OK)
+  setLong() as batch getShort=98 was null false JDBC MATCH(OK)
   setFloat() getShort=98 was null false JDBC MATCH(OK)
+  setFloat() as batch getShort=98 was null false JDBC MATCH(OK)
   setDouble() getShort=98 was null false JDBC MATCH(OK)
+  setDouble() as batch getShort=98 was null false JDBC MATCH(OK)
   setBigDecimal() getShort=99 was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getShort=99 was null false JDBC MATCH(OK)
   setBigDecimal(null) getShort=0 was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getShort=0 was null true JDBC MATCH(OK)
   setBoolean() getShort=1 was null false JDBC MATCH(OK)
+  setBoolean() as batch getShort=1 was null false JDBC MATCH(OK)
   setString() getShort=97 was null false JDBC MATCH(OK)
+  setString() as batch getShort=97 was null false JDBC MATCH(OK)
   setString(null) getShort=0 was null true JDBC MATCH(OK)
+  setString(null) as batch getShort=0 was null true JDBC MATCH(OK)
   setBytes() IC JDBC MATCH (INVALID)
   setBytes(null) IC JDBC MATCH (INVALID)
   setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
   setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
   setTime() IC JDBC MATCH (INVALID)
   setTime(null) IC JDBC MATCH (INVALID)
   setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
   setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
   setAsciiStream() IC JDBC MATCH (INVALID)
   setAsciiStream(null) IC JDBC MATCH (INVALID)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -288,24 +303,39 @@
 setXXX() with all JDBC Types on INTEGER
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getInt=98 was null false JDBC MATCH(OK)
+  setByte() as batch getInt=98 was null false JDBC MATCH(OK)
   setShort() getInt=98 was null false JDBC MATCH(OK)
+  setShort() as batch getInt=98 was null false JDBC MATCH(OK)
   setInt() getInt=98 was null false JDBC MATCH(OK)
+  setInt() as batch getInt=98 was null false JDBC MATCH(OK)
   setLong() getInt=98 was null false JDBC MATCH(OK)
+  setLong() as batch getInt=98 was null false JDBC MATCH(OK)
   setFloat() getInt=98 was null false JDBC MATCH(OK)
+  setFloat() as batch getInt=98 was null false JDBC MATCH(OK)
   setDouble() getInt=98 was null false JDBC MATCH(OK)
+  setDouble() as batch getInt=98 was null false JDBC MATCH(OK)
   setBigDecimal() getInt=99 was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getInt=99 was null false JDBC MATCH(OK)
   setBigDecimal(null) getInt=0 was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getInt=0 was null true JDBC MATCH(OK)
   setBoolean() getInt=1 was null false JDBC MATCH(OK)
+  setBoolean() as batch getInt=1 was null false JDBC MATCH(OK)
   setString() getInt=97 was null false JDBC MATCH(OK)
+  setString() as batch getInt=97 was null false JDBC MATCH(OK)
   setString(null) getInt=0 was null true JDBC MATCH(OK)
+  setString(null) as batch getInt=0 was null true JDBC MATCH(OK)
   setBytes() IC JDBC MATCH (INVALID)
   setBytes(null) IC JDBC MATCH (INVALID)
   setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
   setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
   setTime() IC JDBC MATCH (INVALID)
   setTime(null) IC JDBC MATCH (INVALID)
   setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
   setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
   setAsciiStream() IC JDBC MATCH (INVALID)
   setAsciiStream(null) IC JDBC MATCH (INVALID)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -484,24 +514,39 @@
 setXXX() with all JDBC Types on BIGINT
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getLong=98 was null false JDBC MATCH(OK)
+  setByte() as batch getLong=98 was null false JDBC MATCH(OK)
   setShort() getLong=98 was null false JDBC MATCH(OK)
+  setShort() as batch getLong=98 was null false JDBC MATCH(OK)
   setInt() getLong=98 was null false JDBC MATCH(OK)
+  setInt() as batch getLong=98 was null false JDBC MATCH(OK)
   setLong() getLong=98 was null false JDBC MATCH(OK)
+  setLong() as batch getLong=98 was null false JDBC MATCH(OK)
   setFloat() getLong=98 was null false JDBC MATCH(OK)
+  setFloat() as batch getLong=98 was null false JDBC MATCH(OK)
   setDouble() getLong=98 was null false JDBC MATCH(OK)
+  setDouble() as batch getLong=98 was null false JDBC MATCH(OK)
   setBigDecimal() getLong=99 was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getLong=99 was null false JDBC MATCH(OK)
   setBigDecimal(null) getLong=0 was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getLong=0 was null true JDBC MATCH(OK)
   setBoolean() getLong=1 was null false JDBC MATCH(OK)
+  setBoolean() as batch getLong=1 was null false JDBC MATCH(OK)
   setString() getLong=97 was null false JDBC MATCH(OK)
+  setString() as batch getLong=97 was null false JDBC MATCH(OK)
   setString(null) getLong=0 was null true JDBC MATCH(OK)
+  setString(null) as batch getLong=0 was null true JDBC MATCH(OK)
   setBytes() IC JDBC MATCH (INVALID)
   setBytes(null) IC JDBC MATCH (INVALID)
   setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
   setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
   setTime() IC JDBC MATCH (INVALID)
   setTime(null) IC JDBC MATCH (INVALID)
   setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
   setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
   setAsciiStream() IC JDBC MATCH (INVALID)
   setAsciiStream(null) IC JDBC MATCH (INVALID)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -680,24 +725,39 @@
 setXXX() with all JDBC Types on REAL
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getFloat=98.0 was null false JDBC MATCH(OK)
+  setByte() as batch getFloat=98.0 was null false JDBC MATCH(OK)
   setShort() getFloat=98.0 was null false JDBC MATCH(OK)
+  setShort() as batch getFloat=98.0 was null false JDBC MATCH(OK)
   setInt() getFloat=98.0 was null false JDBC MATCH(OK)
+  setInt() as batch getFloat=98.0 was null false JDBC MATCH(OK)
   setLong() getFloat=98.0 was null false JDBC MATCH(OK)
+  setLong() as batch getFloat=98.0 was null false JDBC MATCH(OK)
   setFloat() getFloat=98.4 was null false JDBC MATCH(OK)
+  setFloat() as batch getFloat=98.4 was null false JDBC MATCH(OK)
   setDouble() getFloat=98.5 was null false JDBC MATCH(OK)
+  setDouble() as batch getFloat=98.5 was null false JDBC MATCH(OK)
   setBigDecimal() getFloat=99.0 was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getFloat=99.0 was null false JDBC MATCH(OK)
   setBigDecimal(null) getFloat=0.0 was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getFloat=0.0 was null true JDBC MATCH(OK)
   setBoolean() getFloat=1.0 was null false JDBC MATCH(OK)
+  setBoolean() as batch getFloat=1.0 was null false JDBC MATCH(OK)
   setString() getFloat=97.0 was null false JDBC MATCH(OK)
+  setString() as batch getFloat=97.0 was null false JDBC MATCH(OK)
   setString(null) getFloat=0.0 was null true JDBC MATCH(OK)
+  setString(null) as batch getFloat=0.0 was null true JDBC MATCH(OK)
   setBytes() IC JDBC MATCH (INVALID)
   setBytes(null) IC JDBC MATCH (INVALID)
   setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
   setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
   setTime() IC JDBC MATCH (INVALID)
   setTime(null) IC JDBC MATCH (INVALID)
   setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
   setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
   setAsciiStream() IC JDBC MATCH (INVALID)
   setAsciiStream(null) IC JDBC MATCH (INVALID)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -877,24 +937,39 @@
 setXXX() with all JDBC Types on FLOAT
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getDouble=98.0 was null false JDBC MATCH(OK)
+  setByte() as batch getDouble=98.0 was null false JDBC MATCH(OK)
   setShort() getDouble=98.0 was null false JDBC MATCH(OK)
+  setShort() as batch getDouble=98.0 was null false JDBC MATCH(OK)
   setInt() getDouble=98.0 was null false JDBC MATCH(OK)
+  setInt() as batch getDouble=98.0 was null false JDBC MATCH(OK)
   setLong() getDouble=98.0 was null false JDBC MATCH(OK)
+  setLong() as batch getDouble=98.0 was null false JDBC MATCH(OK)
   setFloat() getDouble=98.4000015258789 was null false JDBC MATCH(OK)
+  setFloat() as batch getDouble=98.4000015258789 was null false JDBC MATCH(OK)
   setDouble() getDouble=98.5 was null false JDBC MATCH(OK)
+  setDouble() as batch getDouble=98.5 was null false JDBC MATCH(OK)
   setBigDecimal() getDouble=99.0 was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getDouble=99.0 was null false JDBC MATCH(OK)
   setBigDecimal(null) getDouble=0.0 was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getDouble=0.0 was null true JDBC MATCH(OK)
   setBoolean() getDouble=1.0 was null false JDBC MATCH(OK)
+  setBoolean() as batch getDouble=1.0 was null false JDBC MATCH(OK)
   setString() getDouble=97.0 was null false JDBC MATCH(OK)
+  setString() as batch getDouble=97.0 was null false JDBC MATCH(OK)
   setString(null) getDouble=0.0 was null true JDBC MATCH(OK)
+  setString(null) as batch getDouble=0.0 was null true JDBC MATCH(OK)
   setBytes() IC JDBC MATCH (INVALID)
   setBytes(null) IC JDBC MATCH (INVALID)
   setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
   setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
   setTime() IC JDBC MATCH (INVALID)
   setTime(null) IC JDBC MATCH (INVALID)
   setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
   setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
   setAsciiStream() IC JDBC MATCH (INVALID)
   setAsciiStream(null) IC JDBC MATCH (INVALID)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -1073,24 +1148,39 @@
 setXXX() with all JDBC Types on DOUBLE
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getDouble=98.0 was null false JDBC MATCH(OK)
+  setByte() as batch getDouble=98.0 was null false JDBC MATCH(OK)
   setShort() getDouble=98.0 was null false JDBC MATCH(OK)
+  setShort() as batch getDouble=98.0 was null false JDBC MATCH(OK)
   setInt() getDouble=98.0 was null false JDBC MATCH(OK)
+  setInt() as batch getDouble=98.0 was null false JDBC MATCH(OK)
   setLong() getDouble=98.0 was null false JDBC MATCH(OK)
+  setLong() as batch getDouble=98.0 was null false JDBC MATCH(OK)
   setFloat() getDouble=98.4000015258789 was null false JDBC MATCH(OK)
+  setFloat() as batch getDouble=98.4000015258789 was null false JDBC MATCH(OK)
   setDouble() getDouble=98.5 was null false JDBC MATCH(OK)
+  setDouble() as batch getDouble=98.5 was null false JDBC MATCH(OK)
   setBigDecimal() getDouble=99.0 was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getDouble=99.0 was null false JDBC MATCH(OK)
   setBigDecimal(null) getDouble=0.0 was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getDouble=0.0 was null true JDBC MATCH(OK)
   setBoolean() getDouble=1.0 was null false JDBC MATCH(OK)
+  setBoolean() as batch getDouble=1.0 was null false JDBC MATCH(OK)
   setString() getDouble=97.0 was null false JDBC MATCH(OK)
+  setString() as batch getDouble=97.0 was null false JDBC MATCH(OK)
   setString(null) getDouble=0.0 was null true JDBC MATCH(OK)
+  setString(null) as batch getDouble=0.0 was null true JDBC MATCH(OK)
   setBytes() IC JDBC MATCH (INVALID)
   setBytes(null) IC JDBC MATCH (INVALID)
   setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
   setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
   setTime() IC JDBC MATCH (INVALID)
   setTime(null) IC JDBC MATCH (INVALID)
   setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
   setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
   setAsciiStream() IC JDBC MATCH (INVALID)
   setAsciiStream(null) IC JDBC MATCH (INVALID)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -1269,24 +1359,39 @@
 setXXX() with all JDBC Types on DECIMAL(10,5)
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getBigDecimal=98.00000 was null false JDBC MATCH(OK)
+  setByte() as batch getBigDecimal=98.00000 was null false JDBC MATCH(OK)
   setShort() getBigDecimal=98.00000 was null false JDBC MATCH(OK)
+  setShort() as batch getBigDecimal=98.00000 was null false JDBC MATCH(OK)
   setInt() getBigDecimal=98.00000 was null false JDBC MATCH(OK)
+  setInt() as batch getBigDecimal=98.00000 was null false JDBC MATCH(OK)
   setLong() getBigDecimal=98.00000 was null false JDBC MATCH(OK)
+  setLong() as batch getBigDecimal=98.00000 was null false JDBC MATCH(OK)
   setFloat() getBigDecimal=98.40000 was null false JDBC MATCH(OK)
+  setFloat() as batch getBigDecimal=98.40000 was null false JDBC MATCH(OK)
   setDouble() getBigDecimal=98.50000 was null false JDBC MATCH(OK)
+  setDouble() as batch getBigDecimal=98.50000 was null false JDBC MATCH(OK)
   setBigDecimal() getBigDecimal=99.00000 was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getBigDecimal=99.00000 was null false JDBC MATCH(OK)
   setBigDecimal(null) getBigDecimal=null was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getBigDecimal=null was null true JDBC MATCH(OK)
   setBoolean() getBigDecimal=1.00000 was null false JDBC MATCH(OK)
+  setBoolean() as batch getBigDecimal=1.00000 was null false JDBC MATCH(OK)
   setString() getBigDecimal=97.00000 was null false JDBC MATCH(OK)
+  setString() as batch getBigDecimal=97.00000 was null false JDBC MATCH(OK)
   setString(null) getBigDecimal=null was null true JDBC MATCH(OK)
+  setString(null) as batch getBigDecimal=null was null true JDBC MATCH(OK)
   setBytes() IC JDBC MATCH (INVALID)
   setBytes(null) IC JDBC MATCH (INVALID)
   setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
   setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
   setTime() IC JDBC MATCH (INVALID)
   setTime(null) IC JDBC MATCH (INVALID)
   setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
   setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
   setAsciiStream() IC JDBC MATCH (INVALID)
   setAsciiStream(null) IC JDBC MATCH (INVALID)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -1471,24 +1576,39 @@
 setXXX() with all JDBC Types on CHAR(60)
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getString=98                                                           was null false JDBC MATCH(OK)
+  setByte() as batch getString=98                                                           was null false JDBC MATCH(OK)
   setShort() getString=98                                                           was null false JDBC MATCH(OK)
+  setShort() as batch getString=98                                                           was null false JDBC MATCH(OK)
   setInt() getString=98                                                           was null false JDBC MATCH(OK)
+  setInt() as batch getString=98                                                           was null false JDBC MATCH(OK)
   setLong() getString=98                                                           was null false JDBC MATCH(OK)
+  setLong() as batch getString=98                                                           was null false JDBC MATCH(OK)
   setFloat() getString=98.4                                                         was null false JDBC MATCH(OK)
+  setFloat() as batch getString=98.4                                                         was null false JDBC MATCH(OK)
   setDouble() getString=98.5                                                         was null false JDBC MATCH(OK)
+  setDouble() as batch getString=98.5                                                         was null false JDBC MATCH(OK)
   setBigDecimal() getString=99                                                           was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getString=99                                                           was null false JDBC MATCH(OK)
   setBigDecimal(null) getString=null was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getString=null was null true JDBC MATCH(OK)
   setBoolean() getString=1                                                            was null false JDBC MATCH(OK)
+  setBoolean() as batch getString=1                                                            was null false JDBC MATCH(OK)
   setString() getString=97                                                           was null false JDBC MATCH(OK)
+  setString() as batch getString=97                                                           was null false JDBC MATCH(OK)
   setString(null) getString=null was null true JDBC MATCH(OK)
+  setString(null) as batch getString=null was null true JDBC MATCH(OK)
   setBytes() getString=EncodedString: > 1027 64963 29440 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 < was null false CLOUD EXT (OK)
   setBytes(null) getString=null was null true CLOUD EXT (OK)
   setDate() getString=2004-02-14                                                   was null false JDBC MATCH(OK)
+  setDate() as batch getString=2004-02-14                                                   was null false JDBC MATCH(OK)
   setDate(null) getString=null was null true JDBC MATCH(OK)
+  setDate(null) as batch getString=null was null true JDBC MATCH(OK)
   setTime() getString=13:26:42                                                     was null false JDBC MATCH(OK)
   setTime(null) getString=null was null true JDBC MATCH(OK)
   setTimestamp() getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
+  setTimestamp() as batch getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
   setTimestamp(null) getString=null was null true JDBC MATCH(OK)
+  setTimestamp(null) as batch getString=null was null true JDBC MATCH(OK)
   setAsciiStream() getString=eg012d                                                       was null false JDBC MATCH(OK)
   setAsciiStream(null) getString=null was null true JDBC MATCH(OK)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -1662,24 +1782,39 @@
 setXXX() with all JDBC Types on VARCHAR(60)
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getString=98 was null false JDBC MATCH(OK)
+  setByte() as batch getString=98 was null false JDBC MATCH(OK)
   setShort() getString=98 was null false JDBC MATCH(OK)
+  setShort() as batch getString=98 was null false JDBC MATCH(OK)
   setInt() getString=98 was null false JDBC MATCH(OK)
+  setInt() as batch getString=98 was null false JDBC MATCH(OK)
   setLong() getString=98 was null false JDBC MATCH(OK)
+  setLong() as batch getString=98 was null false JDBC MATCH(OK)
   setFloat() getString=98.4 was null false JDBC MATCH(OK)
+  setFloat() as batch getString=98.4 was null false JDBC MATCH(OK)
   setDouble() getString=98.5 was null false JDBC MATCH(OK)
+  setDouble() as batch getString=98.5 was null false JDBC MATCH(OK)
   setBigDecimal() getString=99 was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getString=99 was null false JDBC MATCH(OK)
   setBigDecimal(null) getString=null was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getString=null was null true JDBC MATCH(OK)
   setBoolean() getString=1 was null false JDBC MATCH(OK)
+  setBoolean() as batch getString=1 was null false JDBC MATCH(OK)
   setString() getString=97 was null false JDBC MATCH(OK)
+  setString() as batch getString=97 was null false JDBC MATCH(OK)
   setString(null) getString=null was null true JDBC MATCH(OK)
+  setString(null) as batch getString=null was null true JDBC MATCH(OK)
   setBytes() getString=EncodedString: > 1027 64963 29440 < was null false CLOUD EXT (OK)
   setBytes(null) getString=null was null true CLOUD EXT (OK)
   setDate() getString=2004-02-14 was null false JDBC MATCH(OK)
+  setDate() as batch getString=2004-02-14 was null false JDBC MATCH(OK)
   setDate(null) getString=null was null true JDBC MATCH(OK)
+  setDate(null) as batch getString=null was null true JDBC MATCH(OK)
   setTime() getString=13:26:42 was null false JDBC MATCH(OK)
   setTime(null) getString=null was null true JDBC MATCH(OK)
   setTimestamp() getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
+  setTimestamp() as batch getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
   setTimestamp(null) getString=null was null true JDBC MATCH(OK)
+  setTimestamp(null) as batch getString=null was null true JDBC MATCH(OK)
   setAsciiStream() getString=eg012d was null false JDBC MATCH(OK)
   setAsciiStream(null) getString=null was null true JDBC MATCH(OK)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -1853,24 +1988,39 @@
 setXXX() with all JDBC Types on LONG VARCHAR
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getString=98 was null false JDBC MATCH(OK)
+  setByte() as batch getString=98 was null false JDBC MATCH(OK)
   setShort() getString=98 was null false JDBC MATCH(OK)
+  setShort() as batch getString=98 was null false JDBC MATCH(OK)
   setInt() getString=98 was null false JDBC MATCH(OK)
+  setInt() as batch getString=98 was null false JDBC MATCH(OK)
   setLong() getString=98 was null false JDBC MATCH(OK)
+  setLong() as batch getString=98 was null false JDBC MATCH(OK)
   setFloat() getString=98.4 was null false JDBC MATCH(OK)
+  setFloat() as batch getString=98.4 was null false JDBC MATCH(OK)
   setDouble() getString=98.5 was null false JDBC MATCH(OK)
+  setDouble() as batch getString=98.5 was null false JDBC MATCH(OK)
   setBigDecimal() getString=99 was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getString=99 was null false JDBC MATCH(OK)
   setBigDecimal(null) getString=null was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getString=null was null true JDBC MATCH(OK)
   setBoolean() getString=1 was null false JDBC MATCH(OK)
+  setBoolean() as batch getString=1 was null false JDBC MATCH(OK)
   setString() getString=97 was null false JDBC MATCH(OK)
+  setString() as batch getString=97 was null false JDBC MATCH(OK)
   setString(null) getString=null was null true JDBC MATCH(OK)
+  setString(null) as batch getString=null was null true JDBC MATCH(OK)
   setBytes() getString=EncodedString: > 1027 64963 29440 < was null false CLOUD EXT (OK)
   setBytes(null) getString=null was null true CLOUD EXT (OK)
   setDate() getString=2004-02-14 was null false JDBC MATCH(OK)
+  setDate() as batch getString=2004-02-14 was null false JDBC MATCH(OK)
   setDate(null) getString=null was null true JDBC MATCH(OK)
+  setDate(null) as batch getString=null was null true JDBC MATCH(OK)
   setTime() getString=13:26:42 was null false JDBC MATCH(OK)
   setTime(null) getString=null was null true JDBC MATCH(OK)
   setTimestamp() getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
+  setTimestamp() as batch getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
   setTimestamp(null) getString=null was null true JDBC MATCH(OK)
+  setTimestamp(null) as batch getString=null was null true JDBC MATCH(OK)
   setAsciiStream() getString=eg012d was null false JDBC MATCH(OK)
   setAsciiStream(null) getString=null was null true JDBC MATCH(OK)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -1990,24 +2140,39 @@
 setXXX() with all JDBC Types on VARCHAR(60) FOR BIT DATA
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() IC JDBC MATCH (INVALID)
+  setByte() as batch IC JDBC MATCH (INVALID)
   setShort() IC JDBC MATCH (INVALID)
+  setShort() as batch IC JDBC MATCH (INVALID)
   setInt() IC JDBC MATCH (INVALID)
+  setInt() as batch IC JDBC MATCH (INVALID)
   setLong() IC JDBC MATCH (INVALID)
+  setLong() as batch IC JDBC MATCH (INVALID)
   setFloat() IC JDBC MATCH (INVALID)
+  setFloat() as batch IC JDBC MATCH (INVALID)
   setDouble() IC JDBC MATCH (INVALID)
+  setDouble() as batch IC JDBC MATCH (INVALID)
   setBigDecimal() IC JDBC MATCH (INVALID)
+  setBigDecimal() as batch IC JDBC MATCH (INVALID)
   setBigDecimal(null) IC JDBC MATCH (INVALID)
+  setBigDecimal(null) as batch IC JDBC MATCH (INVALID)
   setBoolean() IC JDBC MATCH (INVALID)
+  setBoolean() as batch IC JDBC MATCH (INVALID)
   setString() IC JDBC MATCH (INVALID)
+  setString() as batch IC JDBC MATCH (INVALID)
   setString(null) IC JDBC MATCH (INVALID)
+  setString(null) as batch IC JDBC MATCH (INVALID)
   setBytes() getBytes=0x4,0x3 was null false JDBC MATCH(OK)
   setBytes(null) getBytes=null was null true JDBC MATCH(OK)
   setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
   setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
   setTime() IC JDBC MATCH (INVALID)
   setTime(null) IC JDBC MATCH (INVALID)
   setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
   setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
   setAsciiStream() IC JDBC MATCH (INVALID)
   setAsciiStream(null) IC JDBC MATCH (INVALID)
   setBinaryStream() getBytes=0x82,0x43 was null false JDBC MATCH(OK)
@@ -2166,24 +2331,39 @@
 setXXX() with all JDBC Types on DATE
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() IC JDBC MATCH (INVALID)
+  setByte() as batch IC JDBC MATCH (INVALID)
   setShort() IC JDBC MATCH (INVALID)
+  setShort() as batch IC JDBC MATCH (INVALID)
   setInt() IC JDBC MATCH (INVALID)
+  setInt() as batch IC JDBC MATCH (INVALID)
   setLong() IC JDBC MATCH (INVALID)
+  setLong() as batch IC JDBC MATCH (INVALID)
   setFloat() IC JDBC MATCH (INVALID)
+  setFloat() as batch IC JDBC MATCH (INVALID)
   setDouble() IC JDBC MATCH (INVALID)
+  setDouble() as batch IC JDBC MATCH (INVALID)
   setBigDecimal() IC JDBC MATCH (INVALID)
+  setBigDecimal() as batch IC JDBC MATCH (INVALID)
   setBigDecimal(null) IC JDBC MATCH (INVALID)
+  setBigDecimal(null) as batch IC JDBC MATCH (INVALID)
   setBoolean() IC JDBC MATCH (INVALID)
+  setBoolean() as batch IC JDBC MATCH (INVALID)
   setString()  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL DATE
+  setString() as batch  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL DATE
   setString(null) getDate=null was null true JDBC MATCH(OK)
+  setString(null) as batch getDate=null was null true JDBC MATCH(OK)
   setBytes() IC JDBC MATCH (INVALID)
   setBytes(null) IC JDBC MATCH (INVALID)
   setDate() getDate=2004-02-14 was null false JDBC MATCH(OK)
+  setDate() as batch getDate=2004-02-14 was null false JDBC MATCH(OK)
   setDate(null) getDate=null was null true JDBC MATCH(OK)
+  setDate(null) as batch getDate=null was null true JDBC MATCH(OK)
   setTime() IC JDBC MATCH (INVALID)
   setTime(null) IC JDBC MATCH (INVALID)
   setTimestamp() getDate=2004-02-23 was null false JDBC MATCH(OK)
+  setTimestamp() as batch getDate=2004-02-23 was null false JDBC MATCH(OK)
   setTimestamp(null) getDate=null was null true JDBC MATCH(OK)
+  setTimestamp(null) as batch getDate=null was null true JDBC MATCH(OK)
   setAsciiStream() IC JDBC MATCH (INVALID)
   setAsciiStream(null) IC JDBC MATCH (INVALID)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -2344,24 +2524,39 @@
 setXXX() with all JDBC Types on TIME
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() IC JDBC MATCH (INVALID)
+  setByte() as batch IC JDBC MATCH (INVALID)
   setShort() IC JDBC MATCH (INVALID)
+  setShort() as batch IC JDBC MATCH (INVALID)
   setInt() IC JDBC MATCH (INVALID)
+  setInt() as batch IC JDBC MATCH (INVALID)
   setLong() IC JDBC MATCH (INVALID)
+  setLong() as batch IC JDBC MATCH (INVALID)
   setFloat() IC JDBC MATCH (INVALID)
+  setFloat() as batch IC JDBC MATCH (INVALID)
   setDouble() IC JDBC MATCH (INVALID)
+  setDouble() as batch IC JDBC MATCH (INVALID)
   setBigDecimal() IC JDBC MATCH (INVALID)
+  setBigDecimal() as batch IC JDBC MATCH (INVALID)
   setBigDecimal(null) IC JDBC MATCH (INVALID)
+  setBigDecimal(null) as batch IC JDBC MATCH (INVALID)
   setBoolean() IC JDBC MATCH (INVALID)
+  setBoolean() as batch IC JDBC MATCH (INVALID)
   setString()  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIME
+  setString() as batch  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIME
   setString(null) getTime=null was null true JDBC MATCH(OK)
+  setString(null) as batch getTime=null was null true JDBC MATCH(OK)
   setBytes() IC JDBC MATCH (INVALID)
   setBytes(null) IC JDBC MATCH (INVALID)
   setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
   setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
   setTime() getTime=13:26:42 was null false JDBC MATCH(OK)
   setTime(null) getTime=null was null true JDBC MATCH(OK)
   setTimestamp() getTime=17:14:24 was null false JDBC MATCH(OK)
+  setTimestamp() as batch getTime=17:14:24 was null false JDBC MATCH(OK)
   setTimestamp(null) getTime=null was null true JDBC MATCH(OK)
+  setTimestamp(null) as batch getTime=null was null true JDBC MATCH(OK)
   setAsciiStream() IC JDBC MATCH (INVALID)
   setAsciiStream(null) IC JDBC MATCH (INVALID)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -2523,24 +2718,39 @@
 setXXX() with all JDBC Types on TIMESTAMP
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() IC JDBC MATCH (INVALID)
+  setByte() as batch IC JDBC MATCH (INVALID)
   setShort() IC JDBC MATCH (INVALID)
+  setShort() as batch IC JDBC MATCH (INVALID)
   setInt() IC JDBC MATCH (INVALID)
+  setInt() as batch IC JDBC MATCH (INVALID)
   setLong() IC JDBC MATCH (INVALID)
+  setLong() as batch IC JDBC MATCH (INVALID)
   setFloat() IC JDBC MATCH (INVALID)
+  setFloat() as batch IC JDBC MATCH (INVALID)
   setDouble() IC JDBC MATCH (INVALID)
+  setDouble() as batch IC JDBC MATCH (INVALID)
   setBigDecimal() IC JDBC MATCH (INVALID)
+  setBigDecimal() as batch IC JDBC MATCH (INVALID)
   setBigDecimal(null) IC JDBC MATCH (INVALID)
+  setBigDecimal(null) as batch IC JDBC MATCH (INVALID)
   setBoolean() IC JDBC MATCH (INVALID)
+  setBoolean() as batch IC JDBC MATCH (INVALID)
   setString()  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIMESTAMP
+  setString() as batch  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIMESTAMP
   setString(null) getTimestamp=null was null true JDBC MATCH(OK)
+  setString(null) as batch getTimestamp=null was null true JDBC MATCH(OK)
   setBytes() IC JDBC MATCH (INVALID)
   setBytes(null) IC JDBC MATCH (INVALID)
   setDate() getTimestamp=00:00:00 was null false JDBC MATCH(OK)
+  setDate() as batch getTimestamp=00:00:00 was null false JDBC MATCH(OK)
   setDate(null) getTimestamp=null was null true JDBC MATCH(OK)
+  setDate(null) as batch getTimestamp=null was null true JDBC MATCH(OK)
   setTime() getTimestamp=13:26:42 was null false JDBC MATCH(OK)
   setTime(null) getTimestamp=null was null true JDBC MATCH(OK)
   setTimestamp() getTimestamp=17:14:24 was null false JDBC MATCH(OK)
+  setTimestamp() as batch getTimestamp=17:14:24 was null false JDBC MATCH(OK)
   setTimestamp(null) getTimestamp=null was null true JDBC MATCH(OK)
+  setTimestamp(null) as batch getTimestamp=null was null true JDBC MATCH(OK)
   setAsciiStream() IC JDBC MATCH (INVALID)
   setAsciiStream(null) IC JDBC MATCH (INVALID)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -2702,24 +2912,39 @@
 setXXX() with all JDBC Types on CLOB(1k)
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() IC JDBC MATCH (INVALID)
+  setByte() as batch IC JDBC MATCH (INVALID)
   setShort() IC JDBC MATCH (INVALID)
+  setShort() as batch IC JDBC MATCH (INVALID)
   setInt() IC JDBC MATCH (INVALID)
+  setInt() as batch IC JDBC MATCH (INVALID)
   setLong() IC JDBC MATCH (INVALID)
+  setLong() as batch IC JDBC MATCH (INVALID)
   setFloat() IC JDBC MATCH (INVALID)
+  setFloat() as batch IC JDBC MATCH (INVALID)
   setDouble() IC JDBC MATCH (INVALID)
+  setDouble() as batch IC JDBC MATCH (INVALID)
   setBigDecimal() IC JDBC MATCH (INVALID)
+  setBigDecimal() as batch IC JDBC MATCH (INVALID)
   setBigDecimal(null) IC JDBC MATCH (INVALID)
+  setBigDecimal(null) as batch IC JDBC MATCH (INVALID)
   setBoolean() IC JDBC MATCH (INVALID)
+  setBoolean() as batch IC JDBC MATCH (INVALID)
   setString() getClob=0x39,0x37 was null false CLOUD EXT (OK)
+  setString() as batch getClob=0x39,0x37 was null false CLOUD EXT (OK)
   setString(null) getClob=null was null true CLOUD EXT (OK)
+  setString(null) as batch getClob=null was null true CLOUD EXT (OK)
   setBytes() IC JDBC MATCH (INVALID)
   setBytes(null) IC JDBC MATCH (INVALID)
   setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
   setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
   setTime() IC JDBC MATCH (INVALID)
   setTime(null) IC JDBC MATCH (INVALID)
   setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
   setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
   setAsciiStream() getClob=0x65,0x67 was null false JDBC MATCH(OK)
   setAsciiStream(null) getClob=null was null true JDBC MATCH(OK)
   setBinaryStream() IC JDBC MATCH (INVALID)
@@ -2837,24 +3062,39 @@
 setXXX() with all JDBC Types on BLOB(1k)
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() IC JDBC MATCH (INVALID)
+  setByte() as batch IC JDBC MATCH (INVALID)
   setShort() IC JDBC MATCH (INVALID)
+  setShort() as batch IC JDBC MATCH (INVALID)
   setInt() IC JDBC MATCH (INVALID)
+  setInt() as batch IC JDBC MATCH (INVALID)
   setLong() IC JDBC MATCH (INVALID)
+  setLong() as batch IC JDBC MATCH (INVALID)
   setFloat() IC JDBC MATCH (INVALID)
+  setFloat() as batch IC JDBC MATCH (INVALID)
   setDouble() IC JDBC MATCH (INVALID)
+  setDouble() as batch IC JDBC MATCH (INVALID)
   setBigDecimal() IC JDBC MATCH (INVALID)
+  setBigDecimal() as batch IC JDBC MATCH (INVALID)
   setBigDecimal(null) IC JDBC MATCH (INVALID)
+  setBigDecimal(null) as batch IC JDBC MATCH (INVALID)
   setBoolean() IC JDBC MATCH (INVALID)
+  setBoolean() as batch IC JDBC MATCH (INVALID)
   setString() IC JDBC MATCH (INVALID)
+  setString() as batch IC JDBC MATCH (INVALID)
   setString(null) IC JDBC MATCH (INVALID)
+  setString(null) as batch IC JDBC MATCH (INVALID)
   setBytes() getBlob=0x4,0x3 was null false CLOUD EXT (OK)
   setBytes(null) getBlob=null was null true CLOUD EXT (OK)
   setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
   setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
   setTime() IC JDBC MATCH (INVALID)
   setTime(null) IC JDBC MATCH (INVALID)
   setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
   setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
   setAsciiStream() IC JDBC MATCH (INVALID)
   setAsciiStream(null) IC JDBC MATCH (INVALID)
   setBinaryStream() getBlob=0x82,0x43 was null false JDBC MATCH(OK)

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/parameterMapping.java
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/parameterMapping.java?rev=190127&r1=190126&r2=190127&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/parameterMapping.java (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/parameterMapping.java Sat Jun 11 08:13:39 2005
@@ -1077,6 +1077,28 @@
 	}
 	private static void setXXX(Statement s, PreparedStatement psi, PreparedStatement psq, int type) throws SQLException, java.io.IOException {
 
+		boolean executeBatchTests = true;
+		
+		// DERBY-349 - Disable executeBatch on these target types as invald conversions
+		// using setByte() and executeBatch lead to the test hanging.
+		if (TestUtil.isDerbyNetClientFramework())
+		{		
+			switch (jdbcTypes[type])
+			{
+			case Types.BINARY:
+			case Types.VARBINARY:
+			case Types.LONGVARBINARY:
+			case Types.DATE:
+			case Types.TIMESTAMP:
+			case Types.TIME:
+			case Types.CLOB:
+			case Types.BLOB:
+				executeBatchTests = false;
+				break;
+			}
+		}
+			
+		
 		{
 		s.execute("DELETE FROM PM.TYPE_AS");
 
@@ -1097,7 +1119,28 @@
 		}
 		judge_setXXX(worked, sqleResult, 0, type);
 		}
-
+		// and as a batch
+		if (executeBatchTests) {
+			s.execute("DELETE FROM PM.TYPE_AS");
+
+			SQLException sqleResult = null;
+			boolean worked;
+			try {
+				System.out.print("  setByte() as batch ");
+				psi.setByte(1, (byte) 98);
+				psi.addBatch();
+				psi.executeBatch();
+
+				getValidValue(psq, jdbcTypes[type]);
+
+				worked = true;
+
+			} catch (SQLException sqle) {
+				sqleResult = sqle;
+				worked = false;
+			}
+			judge_setXXX(worked, sqleResult, 0, type);
+			}
 		{
 		s.execute("DELETE FROM PM.TYPE_AS");
 
@@ -1118,7 +1161,28 @@
 		}
 		judge_setXXX(worked, sqleResult, 1, type);
 		}
+		// and as a batch
+		if (executeBatchTests) {
+		s.execute("DELETE FROM PM.TYPE_AS");
+			
+		SQLException sqleResult = null;
+		boolean worked;
+		try {
+			System.out.print("  setShort() as batch ");
+			psi.setShort(1, (short) 98);
+			psi.addBatch();
+			psi.executeBatch();
 
+			getValidValue(psq, jdbcTypes[type]);
+
+			worked = true;
+
+		} catch (SQLException sqle) {
+			sqleResult = sqle;
+			worked = false;
+		}
+		judge_setXXX(worked, sqleResult, 1, type);
+		}
 		{
 		s.execute("DELETE FROM PM.TYPE_AS");
 
@@ -1139,7 +1203,28 @@
 		}
 		judge_setXXX(worked, sqleResult, 2, type);
 		}
-	
+		// and as a batch
+		if (executeBatchTests) {
+			s.execute("DELETE FROM PM.TYPE_AS");
+
+			SQLException sqleResult = null;
+			boolean worked;
+			try {
+				System.out.print("  setInt() as batch ");
+				psi.setInt(1, 98);
+				psi.addBatch();
+				psi.executeBatch();
+
+				getValidValue(psq, jdbcTypes[type]);
+
+				worked = true;
+
+			} catch (SQLException sqle) {
+				sqleResult = sqle;
+				worked = false;
+			}
+			judge_setXXX(worked, sqleResult, 2, type);
+		}	
 		{
 		s.execute("DELETE FROM PM.TYPE_AS");
 
@@ -1160,7 +1245,29 @@
 		}
 		judge_setXXX(worked, sqleResult, 3, type);
 		}
-		
+		// as a batch
+		if (executeBatchTests) {
+			s.execute("DELETE FROM PM.TYPE_AS");
+
+			SQLException sqleResult = null;
+			boolean worked;
+			try {
+				System.out.print("  setLong() as batch ");
+				psi.setLong(1, 98L);
+				psi.addBatch();
+				psi.executeBatch();
+
+				getValidValue(psq, jdbcTypes[type]);
+
+				worked = true;
+
+			} catch (SQLException sqle) {
+				sqleResult = sqle;
+				worked = false;
+			}
+			judge_setXXX(worked, sqleResult, 3, type);
+			}
+					
 		{
 		s.execute("DELETE FROM PM.TYPE_AS");
 
@@ -1181,6 +1288,29 @@
 		}
 		judge_setXXX(worked, sqleResult, 4, type);
 		}
+		
+		// and as a batch
+		if (executeBatchTests) {
+			s.execute("DELETE FROM PM.TYPE_AS");
+
+			SQLException sqleResult = null;
+			boolean worked;
+			try {
+				System.out.print("  setFloat() as batch ");
+				psi.setFloat(1, 98.4f);
+				psi.addBatch();
+				psi.executeBatch();
+
+				getValidValue(psq, jdbcTypes[type]);
+
+				worked = true;
+
+			} catch (SQLException sqle) {
+				sqleResult = sqle;
+				worked = false;
+			}
+			judge_setXXX(worked, sqleResult, 4, type);
+		}
 
 		{
 		s.execute("DELETE FROM PM.TYPE_AS");
@@ -1202,6 +1332,30 @@
 		}
 		judge_setXXX(worked, sqleResult, 5, type);
 		}
+		
+		// as a batch
+		if (executeBatchTests) {
+			s.execute("DELETE FROM PM.TYPE_AS");
+
+			SQLException sqleResult = null;
+			boolean worked;
+			try {
+				System.out.print("  setDouble() as batch ");
+				psi.setDouble(1, 98.5);
+				psi.addBatch();
+				psi.executeBatch();
+
+				getValidValue(psq, jdbcTypes[type]);
+
+				worked = true;
+
+			} catch (SQLException sqle) {
+				sqleResult = sqle;
+				worked = false;
+			}
+			judge_setXXX(worked, sqleResult, 5, type);
+		}
+
 
 		{
 		s.execute("DELETE FROM PM.TYPE_AS");
@@ -1223,6 +1377,28 @@
 		}
 		judge_setXXX(worked, sqleResult, 6, type);
 		}
+		// as a batch
+		if (executeBatchTests) {
+			s.execute("DELETE FROM PM.TYPE_AS");
+
+			SQLException sqleResult = null;
+			boolean worked;
+			try {
+				System.out.print("  setBigDecimal() as batch ");
+				psi.setBigDecimal(1, new BigDecimal(99.0));
+				psi.addBatch();
+				psi.executeBatch();
+
+				getValidValue(psq, jdbcTypes[type]);
+
+				worked = true;
+
+			} catch (SQLException sqle) {
+				sqleResult = sqle;
+				worked = false;
+			}
+			judge_setXXX(worked, sqleResult, 6, type);
+			}
 		// null BigDecimal
 		{
 		s.execute("DELETE FROM PM.TYPE_AS");
@@ -1245,6 +1421,29 @@
 		judge_setXXX(worked, sqleResult, 6, type);
 		}
 
+		// null BigDecimal
+		if (executeBatchTests) {
+		s.execute("DELETE FROM PM.TYPE_AS");
+
+		SQLException sqleResult = null;
+		boolean worked;
+		try {
+			System.out.print("  setBigDecimal(null) as batch ");
+			psi.setBigDecimal(1, null);
+			psi.addBatch();
+			psi.executeBatch();
+
+			getValidValue(psq, jdbcTypes[type]);
+
+			worked = true;
+
+		} catch (SQLException sqle) {
+			sqleResult = sqle;
+			worked = false;
+		}
+		judge_setXXX(worked, sqleResult, 6, type);
+		}
+
 		{
 		s.execute("DELETE FROM PM.TYPE_AS");
 
@@ -1265,7 +1464,27 @@
 		}
 		judge_setXXX(worked, sqleResult, 7, type);
 		}
+		if (executeBatchTests) {
+			s.execute("DELETE FROM PM.TYPE_AS");
 
+			SQLException sqleResult = null;
+			boolean worked;
+			try {
+				System.out.print("  setBoolean() as batch ");
+				psi.setBoolean(1, true);
+				psi.addBatch();
+				psi.executeBatch();
+
+				getValidValue(psq, jdbcTypes[type]);
+
+				worked = true;
+
+			} catch (SQLException sqle) {
+				sqleResult = sqle;
+				worked = false;
+			}
+			judge_setXXX(worked, sqleResult, 7, type);
+		}
 		{
 		s.execute("DELETE FROM PM.TYPE_AS");
 
@@ -1292,7 +1511,35 @@
 		}
 		judge_setXXX(worked, sqleResult, 8, type);
 		}
-
+		// as batch
+		if (executeBatchTests) {
+			s.execute("DELETE FROM PM.TYPE_AS");
+
+			SQLException sqleResult = null;
+			boolean worked;
+			try {
+				System.out.print("  setString() as batch ");
+				psi.setString(1, "97");
+				psi.addBatch();
+				psi.executeBatch();
+
+				getValidValue(psq, jdbcTypes[type]);
+
+				worked = true;
+
+			} catch (SQLException sqle) {
+				sqleResult = sqle;
+				worked = false;
+			} catch (Throwable t) {
+				// JCC has some bugs
+				System.out.println(t.getMessage());
+				worked = false;
+				sqleResult = null;
+
+			}
+			judge_setXXX(worked, sqleResult, 8, type);
+			}
+		
 		// null String
 		{
 		s.execute("DELETE FROM PM.TYPE_AS");
@@ -1320,7 +1567,34 @@
 		}
 		judge_setXXX(worked, sqleResult, 8, type);
 		}
+		// null String as batch
+		if (executeBatchTests) {
+		s.execute("DELETE FROM PM.TYPE_AS");
+
+		SQLException sqleResult = null;
+		boolean worked;
+		try {
+			System.out.print("  setString(null) as batch ");
+			psi.setString(1, null);
+			psi.addBatch();
+			psi.executeBatch();
+
+			getValidValue(psq, jdbcTypes[type]);
 
+			worked = true;
+
+		} catch (SQLException sqle) {
+			sqleResult = sqle;
+			worked = false;
+		} catch (Throwable t) {
+			// JCC has some bugs
+			System.out.println(t.getMessage());
+			worked = false;
+			sqleResult = null;
+
+		}
+		judge_setXXX(worked, sqleResult, 8, type);
+		}
 		{
 		s.execute("DELETE FROM PM.TYPE_AS");
 
@@ -1384,6 +1658,27 @@
 		}
 		judge_setXXX(worked, sqleResult, 10, type);
 		}
+		if (executeBatchTests) {
+			s.execute("DELETE FROM PM.TYPE_AS");
+
+			SQLException sqleResult = null;
+			boolean worked;
+			try {
+				System.out.print("  setDate() as batch ");
+				psi.setDate(1, java.sql.Date.valueOf("2004-02-14"));
+				psi.addBatch();
+				psi.executeBatch();
+
+				getValidValue(psq, jdbcTypes[type]);
+
+				worked = true;
+
+			} catch (SQLException sqle) {
+				sqleResult = sqle;
+				worked = false;
+			}
+			judge_setXXX(worked, sqleResult, 10, type);
+			}
 		// null Date
 		{
 		s.execute("DELETE FROM PM.TYPE_AS");
@@ -1405,7 +1700,30 @@
 		}
 		judge_setXXX(worked, sqleResult, 10, type);
 		}
+		
+		// null Date
+		if (executeBatchTests) {
+		s.execute("DELETE FROM PM.TYPE_AS");
+
+		SQLException sqleResult = null;
+		boolean worked;
+		try {
+			System.out.print("  setDate(null) as batch ");
+			psi.setDate(1, null);
+			psi.addBatch();
+			psi.executeBatch();
 
+			getValidValue(psq, jdbcTypes[type]);
+
+			worked = true;
+
+		} catch (SQLException sqle) {
+			sqleResult = sqle;
+			worked = false;
+		}
+		judge_setXXX(worked, sqleResult, 10, type);
+		}
+		
 		{
 		s.execute("DELETE FROM PM.TYPE_AS");
 
@@ -1467,6 +1785,29 @@
 		}
 		judge_setXXX(worked, sqleResult, 12, type);
 		}
+		// as batch
+		if (executeBatchTests) {
+			s.execute("DELETE FROM PM.TYPE_AS");
+
+			SQLException sqleResult = null;
+			boolean worked;
+			try {
+				System.out.print("  setTimestamp() as batch ");
+				psi.setTimestamp(1, java.sql.Timestamp.valueOf("2004-02-23 17:14:24.097625551"));
+				psi.addBatch();
+				psi.executeBatch();
+
+				getValidValue(psq, jdbcTypes[type]);
+
+				worked = true;
+
+			} catch (SQLException sqle) {
+				sqleResult = sqle;
+				worked = false;
+			}
+			judge_setXXX(worked, sqleResult, 12, type);
+			}
+
 		{
 		s.execute("DELETE FROM PM.TYPE_AS");
 
@@ -1487,7 +1828,29 @@
 		}
 		judge_setXXX(worked, sqleResult, 12, type);
 		}
-
+		// as batch
+		if (executeBatchTests) {
+			s.execute("DELETE FROM PM.TYPE_AS");
+
+			SQLException sqleResult = null;
+			boolean worked;
+			try {
+				System.out.print("  setTimestamp(null) as batch ");
+				psi.setTimestamp(1, null);
+				psi.addBatch();
+				psi.executeBatch();
+
+				getValidValue(psq, jdbcTypes[type]);
+
+				worked = true;
+
+			} catch (SQLException sqle) {
+				sqleResult = sqle;
+				worked = false;
+			}
+			judge_setXXX(worked, sqleResult, 12, type);
+			}
+		
 		{
 		s.execute("DELETE FROM PM.TYPE_AS");