In the book "JDBC API tutorial and Reference, Second Edition" page 823 talks
about BatchUpdate and catching the exceptions but
if you are using SQL 7.0 the SQL you can generate an error in sql and a
exception will not be thrown example
a Table call test with the structure of
FirstName varchar(5)
LastName varchar(5)

try{
stmt.addBatch("Insert into test (FirstName,LastName) values ('Rob','Jones')");
stmt.addBatch("Insert into test (FirstName,LastName) values('Jim','Johnson')");
int[] updateCounts = stmt.executeBatch()}
catch(BatchUpdateException b){}


Using BatchUpdate the above statements will not throw a exception but the
second record will not be add the the
SQL table but the first one will .

int[] updateCounts = stmt.executeBatch()
will return
updateCounts[0]=1
updateCounts[1]=1

but should return
updateCounts[0]=1
updateCounts[1]=0
and throw a exception

Which is not true.

Help!!!! what is the correct statements
Thanks