[Aplaws-devel] Binary Asset Streaming for APLAWS+ 1.0.5 using SQL Blobs

[Aplaws D. L. <apl...@li...>]

Ladies and Gents,

we have recently upgraded our local instance of APLAWS+ 1.0.5 to enable
streaming of binary assets to and from the database using SQL Blobs.

In the current release of APLAWS, all large binary data sets are represented
as SQL Blobs in the database and transferred to and from the database as
byte arrays. That is, the "content" value of binary assets is of type
"byte[]".

Our changes enable streaming of binary data for BinaryAsset types using the
InputStream and OutputStream available with an SQL Blob instance. That is,
the "content" value of binary assets has been changed from type "byte[]" to
type "java.sql.Blob".

Only BinaryAsset types have changed. All other asset types remain unchanged
and continue to transfer binary data using byte arrays.

The bulk of our testing has been with Oracle SE/XE 10.2.0, Profiling has
shown a substantial reduction to memory usage in the JVM when uploading and
downloading large binary assets.  However, we have only undertaken limited
testing with PostGres 8.4, so results may vary.

If other APLAWS community members are interested in these changes, I can
post a more comprehensive outline of the changes and/or a send a patch set
to the newsgroup.


Regards,
Tim Telcik

-- 

+++
Tim Telcik
tim...@pe...