Re: executeBatch()

From: Steffen Ramlow (s.ramlow_at_gmx.net)
Date: 06/12/04

  • Next message: Joe Weinstein: "Re: executeBatch()" 
    Date: Sat, 12 Jun 2004 18:03:38 +0200

    Joe Weinstein wrote:

    >> when I use a PreparedStatement for a executing a batch of inserts,
    >> the driver executes a single sp_executesql for EACH statement in the
    >> batch.
    >>
    >> Is this a limitation of the database or of the driver?
    >
    > The question is whether those sp_executesql calls are sent
    > one-at-a-time with a wait for a DBMS response for each one, or
    > whether they are sent
    > all together in one network packet, with whatever parameter calls
    > needed
    > in between. The best performance would of course be to send
    > everything in one packet. If it doesn't, it's because the driver
    > implemented the syntax of batches without reaching for the best
    > performance.
    > Joe

    One call per statement. Maybe this is necessary to get the results for each
    statement? 

    --
Kein Plan überlebt die erste Feindberührung.
  • Next message: Joe Weinstein: "Re: executeBatch()"

    Relevant Pages

    • Re: Java vs SQL Server float datatype limits
      ... However Java double has a much wider range: ... Joe Weinstein at BEA Systems ... So I would have imagined that an SQL Server driver either handle the ... The JDBC specification says something about the driver being expected to coerce the Java data type into the correct data type for the server the driver is representing. ...
      (microsoft.public.sqlserver.jdbcdriver)
    • Re: JDBC and JVM question
      ... > public SybDriver() ... > change of regime in DriverManager from one perfectly good driver instance ... > Joe Weinstein at BEA ... There would be no need for the registerWithDriverManager() routine. ...
      (comp.lang.java.databases)
    • Re: ResultSet.updateString against DB2 giving "Column not updatable"
      ... I just based my conclusion on the obvious driver response ... program that makes a JDBC connection, creates a table, inserts ... Check the driver documents about this. ... Joe Weinstein at BEA Systems ...
      (comp.lang.java.databases)
    • Re: JDBC and JVM question
      ... >> I just checked the very latest 5.5 EBF driver. ... >> public class SybDriver ... >> Joe Weinstein at BEA ... >There would be no need for the registerWithDriverManager() routine. ...
      (comp.lang.java.databases)
    • Re: executeBatch()
      ... > driver executes a single sp_executesql for EACH statement in the batch. ... all together in one network packet, ...
      (microsoft.public.sqlserver.jdbcdriver)