🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.jbuilder.java.language
Article #8075

MS SQLServer & large data

#8075
From: ChrisC
Date: Tue, 24 Apr 2001 01:22
11 lines
1384 bytes
We are writing an app that accesses a MS SQLServer DB and we need to
store data files that are typically 20 ~ 60 KB in size. Getting and
putting the data of this size into the SQLServer DB seems to be done in
the MS realm by multiple calls of 8KB blocks of the binary data.

My question is this, is there an elegant way to do this within Java/JDBC
that avoids having to do multiple calls or are we restricted by the
DBarchitecture? How should one do this sort of large data transfer?

Thanks in advance for any help
Chris C
Technical Details
Message-ID: <3AE4D55A.E2A22589@crop.cri.nz>
Path: arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-03!supernews.com!news-xfer.nuri.net!enews.sgi.com!npeer.kpnqwest.net!news.tele.dk!130.133.1.3!fu-berlin.de!news.boerde.de!dnews

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f74b3,54d8dcf161bfdc52,start
X-Google-Attributes: gidf74b3,public
X-Google-ArrivalTime: 2001-04-23 18:44:02 PST
Message-ID: <3AE4D55A.E2A22589@crop.cri.nz>
Date: Tue, 24 Apr 2001 13:22:34 +1200
From: ChrisC <tester@crop.cri.nz>
Organization: Crop & Food Research
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: borland.public.jbuilder.java.language
Subject: MS SQLServer & large data 
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 161.65.3.114
X-Trace: dnews 988075338 161.65.3.114 (23 Apr 2001 18:22:18 -0700)
Lines: 12
Path: arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-03!supernews.com!news-xfer.nuri.net!enews.sgi.com!npeer.kpnqwest.net!news.tele.dk!130.133.1.3!fu-berlin.de!news.boerde.de!dnews