On Wednesday, April 23, 2014 9:00:40 AM UTC+2, Noel Grandin wrote:
>
> Why not just retrieve the data as a ResultSet, call getInputStream() on 
> the ResultSet and write the InputStream to disk. 
> Seems easy enough. 
>
>
Writing such *really well coded* function in Java could be a job for 
experienced Java programmer - to handle all Exceptions like target 
directory permissions, free space size, encoding of CLOB, check of 
correctness of writing using comparison of SHA-1 (MD4. MD5) hash between 
file content and database LOB etc. Or to use some File IO like one from 
Apache. So writing it *once and well* for all in H2 as SQL function should 
be more effective and trustworthy, moreover in case, than FILE_READ already 
exists. That is my humble opinion. 

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to