Oops, above example is for a clob, change .getCharacterStream to .getBinaryStream for a true blob.
On Monday, January 27, 2014 9:08:30 AM UTC+1, Niels van Klaveren wrote: > > For reading a single blob you need to get the field's characterstream, > make it a reader and then process it further. > > (jdbc/query c ["select field from table" parameters] > :row-fn (fn [r] (some-> r > :fieldidentifier > .getCharacterStream > io/reader > (further processing > fns))))) > > The some-> is needed because row-fn is done on all rows, and if the field > is null this would throw a NPE. > > Regards, > > Niels > > On Monday, January 27, 2014 5:21:18 AM UTC+1, [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.
