The long-lived adobe livecycle process has attachments which is List of Document type. It is stored in SQL Server Database as image. Can I retrieve it from SQL Query and pass result to List <Document> type variable in adobe livecycle process? So I could iterate the list to retrieve all files from the attachments. Please advise. Thanks in advance.
Solved! Go to Solution.
Views
Replies
Total Likes
you will have to write some code in the execute script component. The code will be in java. You will be creating a query to get the columns from the database and create a document from that
try converting the image to base64 string and then create Document object to get the attachments
Thanks for reply. I didn"t make it. Cannot retrieve ist type from database in adobe process. Could you provide more details?
Regards.
you will have to write some code in the execute script component. The code will be in java. You will be creating a query to get the columns from the database and create a document from that
I didn't find executescript example to connect sql server DB in beanshell. Where can I find?
Harry
I don’t think there is any sample provided, you will have to write the Java code in the execute script component
Views
Likes
Replies