jdbc driver classes12_01.zip

i checked out the behaviour of this driver when using batches for prepare stmts and callable stmts

it seems that:

prep. stmts in a batch are very very fast coz the batch (one stmt executed n times) is parsed once and executed once (found out via sql_trace & tkprof)

but... in case of a exception no BatchUpdateException is fired.. so this driver is not jdbc 2.1 compliant and i have no chance to find out which stmt in the batch failed

for callables stmt the situation is absolutely weird.

when i call the stored proc n times via a callable stmt then the stmt is pared once and executed n times - normal but when i call the same stored proc n times via a batch the batch is parsed n times and executed n times - weird

am i doing anything wrong, is the driver buggy? or what?

the weird result is that stored procs in batches are running much more slower (factor 10 and more) than plain stmts... Received on Fri Jan 04 2002 - 12:02:08 CST