Re: JDBC batching

From: "Ed Yu" <ekyu(at)asgnet(dot)psc(dot)sc(dot)edu>
To: "Tony DeWitt" <dewitt(at)eizel(dot)com>, "Barry Lind" <barry(at)xythos(dot)com>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: JDBC batching
Date: 2002-01-29 16:15:56
Message-ID: AE6FF3A533861C41A6571F1D7DDF6F6112827E@asgnet2.asg.sc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


Yeah, I've submitted a patch and according to Barry, it was already
fixed. If not, I can re-submit the patch.

-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Tony DeWitt
Sent: Tuesday, January 29, 2002 10:49 AM
To: Barry Lind
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] JDBC batching

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(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Barry Lind
Sent: Tuesday, January 22, 2002 3:47 PM
To: Tony DeWitt
Cc: pgsql-jdbc(at)postgresql(dot)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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2002-01-29 17:59:24 Re: JDBC batching
Previous Message Tony DeWitt 2002-01-29 15:48:44 Re: JDBC batching