Hello, thank you for the hints. Please see my answers below. > -----Original Message----- > From: Blas Rodriguez Somoza [mailto:[EMAIL PROTECTED]] > Sent: Dienstag, 9. April 2002 03:21 > To: [EMAIL PROTECTED] > Cc: Paskamp, Marco > Subject: PreparedStatement.executeBatch > > > Hello > > In the last jdbc Driver (23a) with kernel 21 there are > two things in the > executeBatch methods that don't comply with JDBC tests. > > 1.- PreparedStatement.executeBatch returns -2 count > (Success_No_Info) > for every execution. Although this is in the specifications, > the JDBC tests > don't accept this value as correct. In a previous mail in > this list Marco > stated that this problem came from kernel restrictions so I > suppose it is > dificult to change.
The specification says that Success_No_Info should returned when the correct result count cannot be delivered by the underlaying database. So that's a problem of the testsuite and not a problem of the driver. It's possible to retrieve the correct result counts from the database, but this will decrease the performance of the batch commands enormously. > > 2.- When there is an error in a > PreparedStatement.batchUpdate, and so a > batchUpdateException is throwed, > batchUpdateException.getUpdateCounts() > returns an int[0] where the correct dimension (the error is > in the second > update of three) can be int[1] or int[3]. This should work. Please tryout the newest driver (ftp://ftp.sap.com/pub/sapdb/bin/patch/sapdb-jdbc-bin-7.3.0.23a.jar). Can you send me a JDBC-trace when the problem still occurs? > > In the latest test from Sun, there are a change over what I report > previously as an error. The tests that check in > CallableStatement.executeBatch that any procedure with OUT or INOUT > parameters throw an Exception was removed by Sun in the new > tests version > (1.3.1). Maybe the testcase was removed from sun's testsuite. But it's specified in the JDBC-specification. So I think the driver should still check this. Regards, Marco ---------------------------------------------- Marco PASKAMP SAP DB, SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
