Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

how to store blob object in document variable

Not applicable
hi,

I am using Query single row service to retrieve pdf file from database(it is stored as blob in database). How can i store this blob object in a document variable?

I gave the mapping in "Data Mapping" property of the service. I mapped the column name with a document variable. It gave the following error:



com.adobe.workflow.datatype.InvalidCoercionException: Cannot coerce object: weblogic.jdbc.wrapper.Blob_oracle_sql_BLOB@832ef of type: weblogic.jdbc.wrapper.Blob_oracle_sql_BLOB to type: com.adobe.idp.Document.



can anyone help me in this? Can i store the blob object retrieved from database in any other form in my process?



Thanks.

kripa
1 Reply
Steve_L_Walker
Level 10
Level 10
kripa,



In a MySQL 5.0 environment where a column is defined as 'BLOB', mapping to a variable of type 'document' works predictably with the MySQL 5.1.6 connector. I do not have an Oracle instance available unfortunately.



Have you tried doing an insert from Workbench or externally through Java? It might help diagnose.



Steve