🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.jbuilder.database
Article #439

Re: Batch updates

#439
From: Simon Bisson
Date: Mon, 12 Dec 2005 13:24
37 lines
2417 bytes
Hi Kevin, I had a look through the code and saw that the
default resolver creates prepared  statements.  What I wanted
to do was use the JDBC .addBatch capability and I couldn't find
that in the code.  Also my datasets are all different, so I
have to use a statement as opposed to a prepared statement.
I think this means I would have to write my own resolver?
Thanks, Simon.

"Kevin Dean [TeamB]" <NkOdSePaAnM@datadevelopment.com> wrote:
>Simon Bisson wrote:
>
>>Hi, is it possible to make the query resolver do a series of
>>insert/update/delete as a batch update (for an array of
>>datasets)?  Thanks, Simon
>
>The underlying data set architecture does updates in batch already.  When 
>you post a record, you save changes to the internally cached copy of the 
>record set.  It's the saveChanges() method that actually goes out to the 
>back-end and updates everything.
>
>If you're looking specifically for the ability to use the database's batch 
>update capabilities, then you would have to write your own resolver; see 
>"Database Application Developer's Guide" in the online help.
>
>-- 
>Kevin Dean [TeamB]
>Dolphin Data Development Ltd.
>http://www.datadevelopment.com/
>
>NEW WHITEPAPERS
>Team Development with JBuilder and Borland Enterprise Server
>Securing Borland Enterprise Server
>http://www.datadevelopment.com/papers/index.html
>
>Please see Borland's newsgroup guidelines at
>http://info.borland.com/newsgroups/guide.html
Technical Details
Message-ID: <439d880b$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!news-out.newsfeeds.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail
References: <439d6272$1@newsgroups.borland.com> <xn0eaw9ylxtq3000-kdean@www.teamb.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 1073da,3fa290d0f3c37040
X-Google-Attributes: gid1073da,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Simon Bisson" <sbisson@espeed.co.uk>
Sender: "Simon Bisson" <sbisson@espeed.co.uk>
Reply-To: "Simon Bisson" <sbisson@espeed.co.uk>
Subject: Re: Batch updates
Newsgroups: borland.public.jbuilder.database
X-User-Info: 148.106.128.38     
References:  <439d6272$1@newsgroups.borland.com> <xn0eaw9ylxtq3000-kdean@www.teamb.com>
NNTP-Posting-Host: 207.105.83.66
Message-ID: <439d880b$1@newsgroups.borland.com>
Date: 12 Dec 2005 06:24:11 -0700
X-Trace: newsgroups.borland.com 1134397451 207.105.83.66 (12 Dec 2005 06:24:11 -0700)
Lines: 38
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!news-out.newsfeeds.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail