Re: JDBC batching - Mailing list pgsql-jdbc

From Tony DeWitt
Subject Re: JDBC batching
Date
Msg-id CCELIKPGJPFFONABGGNOCEENCAAA.dewitt@eizel.com
Whole thread Raw
In response to Re: JDBC batching  (Barry Lind <barry@xythos.com>)
List pgsql-jdbc
It does not appear to be so. I grabbed 7.2rc2, and the JDBC driver shipped
with it still implements a batch update with multiple round trips. I
verified this both by sniffing the network packets, reading the shipped
code, and disassembling the Statement class that I'm running. I even checked
the CVS repository at jdbc.postgresql.org.

Am I missing something here?


Thanks,
Tony

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Barry Lind
Sent: Tuesday, January 22, 2002 3:47 PM
To: Tony DeWitt
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] JDBC batching


Tony,

The batch API works in one round trip in 7.2.

thanks,
--Barry


Tony DeWitt wrote:

> I have looked through all the documentation that I can find, as well as
the
> mailing list archives, and I haven't been able to find the answer to this.
> I'm currently running pgsql 7.0.2.
>
> What I'm trying to do is make a large number of writes to a single table
in
> an efficient way. Currently our code makes a separate request for each
> INSERT statement, incurring too many round trips.
>
> I want to convert this to the batch interface, i.e., addBatch() and
> executeBatch(), but I read that this is implemented as multiple round
trips
> anyway in 7.1.x and before. I also read that this might be fixed in 7.2,
but
> I've been unable to verify this in the documentation.
>
> Can anyone enlighten me on the state of the batching interface? or is
there
> some better way to do this?
>
>
> Thank you,
> Tony DeWitt
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly


pgsql-jdbc by date:

Previous
From: "Tony DeWitt"
Date:
Subject: Re: JDBC batching
Next
From: Barry Lind
Date:
Subject: Re: JDBC batching