CODEWITHSUNDEEP
typesmuleblobmule-flow
RAYMOND MCMANEMIN
RAYMOND MCMANEMIN

Reputation: 21

Mule Flow - Inserting BLOB attachment types into an Oracle database field

I am new to the Mule ESB and I am trying to find a solution to what is hopefully a common business requirement.

I have a payload where one of its elements will be inserted into an Oracle database as a BLOB type. I have seen several discussions about setting up a "custom-transformer" where I could create Java code to convert the payload into a byte-array (also saw that Mule has this build in transformer object-to-byte-array).

Is there a way with a payload to isolate the map-payload element (in this case an "attachment" file) and convert it into a byte-array which then simply becomes an element(along with the rest of the other map-payload elements) in the SQL insert statement I have created?

Not sure if Mule also supports an in-line transformer on an element without calling/referencing a "custom-transformer"? I have seen several posting struggling with this issue, but I have not seen an answer that I can readily apply.

Upvotes: 2

Views: 1527

Answers (0)

Related Questions