🚀 go-pugleaf

Chris,

the database group is probably the place to ask this kind of
questions, but here I go:

This will depend on 
a) yes, the db architecture 
b) the JDBC driver architecture 
c) the data type of the field (VARCHAR, CLOB, BLOB) - different 
types will likely be handled differently by both the db and 
the driver.

I guess the only thing you can influece is by choosing the right data type. 

Torsten

ChrisC <tester@crop.cri.nz> wrote:
>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
>