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
BedrockMission!

Learn More

View all

Sign in to view all badges

how to store blob object in document variable

Avatar

18-03-2009

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

Replies

Avatar

Avatar
Validate 1
Level 9
Steve_L_Walker
Level 9

Likes

197 likes

Total Posts

1,435 posts

Correct Reply

212 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile

Avatar
Validate 1
Level 9
Steve_L_Walker
Level 9

Likes

197 likes

Total Posts

1,435 posts

Correct Reply

212 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile
Steve_L_Walker
Level 9

18-03-2009

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