(jdbc/query db ["select blob_contents from ce_blob where event_id in
(?,?,?) " [10024279,10024280,10024281]]
:row-fn (fn [r]
(some-> r
:blob_contents
.getBinaryStream
io/input-stream))
:result-set-fn (fn [rs]
(with-open [o (io/output-stream
"d:/temp/testconc.txt")]
(doseq [r rs]
(when r
(io/copy r o))))))
:row-fn is done over every row in the resultset to make an input-stream
from the blob field
:result-set-fn is done over all results of :row-fn, and concatenates all
input-streams into an output stream of a file.
doseq is used instead of map, because the main objective of the function is
to perform side-effects.
Sorry for spamming you, bww00, I was wondering where my replies went, but
only noticed later I was responding to you personally only <blush>
On Wednesday, January 29, 2014 6:48:58 PM UTC+1, [email protected] wrote:
>
> here is where I have gotten:
> query seems to be getting the blob
>
> I am at a loss on how to get to the blob to say write it to a file, or
> ultimately construct a blob of multiple blobs
>
> AS usual any help is greatly appreciated
>
> (jdbc/query db["select blob_contents from ce_blob where event_id
> =?" 10024279]
> :row-fn(fn[r](some-> r
> :blob_contents
> .getBinaryStream
> io/reader
>
> (print r))))
>
> ..........returns
> #<Namespace bww_pnote.core>
> #<BufferedReader java.io.BufferedReader@eb059d> {:blob_contents #<BLOB
> oracle.sql.BLOB@10d697c>}
> (nil)
>
>
>
>
> On Sunday, January 26, 2014 10:21:18 PM UTC-6, [email protected] wrote:
>>
>> ANyone have some examples reading a blob column from an oracle db.
>>
>> We have a database with a blob column.
>> A entity can be split acroos multiple rows.
>> If there are multiple rows we need to read anc concatenate the rows into
>> a single buffer
>> There may be multiple rows that we need to read to concatnate the blobs
>> in this row set
>>
>> any help would be appreciated
>>
>> Thanks
>> bryan
>>
>
--
--
You received this message because you are subscribed to the Google
Groups "Clojure" group.
To post to this group, send email to [email protected]
Note that posts from new members are moderated - please be patient with your
first post.
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/clojure?hl=en
---
You received this message because you are subscribed to the Google Groups
"Clojure" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
