Hi all,

I want to do multiple inserts/updates in a (Oracle) database. I use this
code:

...
final String query="update ...";
PreparedStatement stmt=conn.prepareStatement(query);
stmt.setString(1,string1);
stmt.executeUpdate();
stmt.setString(2,string2);
stmt.executeUpdate();
...
stmt.close();
...

So far this works fine. However I read the oracle docs recently abot
statement caching and all the examples use a stmt.close() between update
calls, e.g.

...
final String query="update ...?...";
PreparedStatement stmt1=conn.prepareStatement(query);
stmt1.setString(1,string1);
stmt1.executeUpdate();
stmt1.close();
PreparedStatement stmt2=conn.prepareStatement(query);
stmt2.setString(2,string2);
stmt2.executeUpdate();
stmt2.close();
...

This code is about 50% slower than mine above, even if I turn on
implicit statement caching in the oracle driver by using
conn.setImplicitStatementCache(true). Could someone please point out if
I am missing something important with my solution.

Also, I thought that by using a PreparedStatement the driver would send
it to the db immediately to do the optimizer stuff and the only waiting
for the bind variables to be submitted. There the Oracle doc suggests
that this is a JDBC-driver-thingy only.

Thank you for help,
Markus