I would expect that you can extend one of the protocols to do this more easily?
http://clojure-doc.org/articles/ecosystem/java_jdbc/using_sql.html#protocol-extensions-for-transforming-values Sean On Jan 27, 2014, at 12:08 AM, Niels van Klaveren <niels.vanklave...@gmail.com> 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, bww00...@yahoo.com 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
signature.asc
Description: Message signed with OpenPGP using GPGMail
