PreparedStatement always returns {-2, -2, -2,...}

[Heath Lilley]

Here we go...
Java Env:WSAD 5.0
Local OS:Windows 2000 Pro
DB:Oracle 9i (9.2.0.1)
DB OS:Solaris 8.0(I think)

I am using a PreparedStatement.addBatch(), to do multiple database updates. In my first attempt I tried to use Replacable Parameters to set my values into the statement.
This worked with 1 or more records, however, the int array that PreparedStatement.executeBatch() return contains nothing but -2's. Now, I know that -2 means "Successful, but updated number of records is unknown". But it would be nice to make sure the number of updated are what I think they should be.
After seeing all of the -2's returned I modified my method to "build" the sql statements by using a StringBuffer. I then used Statement.addBatch(sqlString). This time the array returned all 1's which is what I wanted.
My question is, does anyone know why PreparedStatement.executeBatch() returns -2's and Statement.executeBatch returns 1's while running the same queries?
Here is a snippet of my code the large block of commented out code is from my second attempt. I am including it for posterity. At the bottom recordCount is an int[].

stmt = con.prepareStatement(sql);
//stmt = con.createStatement();

Iterator vIt = vendorTextMap.values().iterator();

while (vIt.hasNext()) {
VendorTextBean vtb = (VendorTextBean)vIt.next();
//StringBuffer sb = new StringBuffer();
//sb.append("UPDATE vendor_text set catalog_order_id=");
//sb.append(vtb.getCatalogOrderId().intValue());
//sb.append(", detail_id=");
//if (vtb.getDetailId() != null) {
//sb.append(vtb.getDetailId());
//} else {
//sb.append("null");
//}
//sb.append(", line=");
//sb.append(vtb.getLine());
//sb.append(", text='");
//sb.append(vtb.getText());
//sb.append("', text_level='");
//sb.append(vtb.getTextLevel());
//sb.append("', text_type='");
//sb.append(vtb.getTextType());
//sb.append("', vendor_id=");
//sb.append(vtb.getVendorId());
//sb.append(" WHERE catalog_order_id=");
//sb.append(vtb.getCatalogOrderId());
//sb.append(" AND line=");
//sb.append(vtb.getLine());
//sb.append(" AND text_level='");
//sb.append(vtb.getTextLevel());
//sb.append("' AND text_type='");
//sb.append(vtb.getTextType());
//sb.append("' AND vendor_id=");
//sb.append(vtb.getVendorId());

stmt.setInt(1, vtb.getCatalogOrderId().intValue());
if (vtb.getDetailId() != null) {
stmt.setInt(2, vtb.getDetailId().intValue());
} else {
stmt.setNull(2, Types.INTEGER);
}
stmt.setInt(3, vtb.getLine().intValue());
stmt.setString(4, vtb.getText());
stmt.setString(5, vtb.getTextLevel());
stmt.setString(6, vtb.getTextType());
stmt.setInt(7, vtb.getVendorId().intValue());
stmt.setInt(8, vtb.getCatalogOrderId().intValue());
stmt.setInt(9, vtb.getLine().intValue());
stmt.setString(10, vtb.getTextLevel());
stmt.setString(11, vtb.getTextType());
stmt.setInt(12, vtb.getVendorId().intValue());
//String sql = sb.toString();
//stmt.addBatch(sql);
stmt.addBatch();
}
recordCount = stmt.executeBatch();

Thanks in advance.
[ May 22, 2003: Message edited by: Heath Lilley ]