Article View: borland.public.jbuilder.database
Article #439Re: Batch updates
From: Simon Bisson
Date: Mon, 12 Dec 2005 13:24
Date: Mon, 12 Dec 2005 13:24
37 lines
2417 bytes
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-mailReferences:
<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