Naveen,
I think option 2 would be your best...and you control the return of the Java
Run-process by doing a Set-Field $PROCESS$ instead of a 'Run Process'
action....the set-field process will wait for the external process to
complete....which means you have to adjust your server process settings to
be long enough for your process to complete within that timeout value.

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of NNMN
Sent: Saturday, July 17, 2010 12:18 PM
To: [email protected]
Subject: Document Save from Database

Hi ARSers,

Below is a situation which i am trying to sort out.
1. I have two systems, a Remedy system and a custom application which
generates documents and stores it as blob.
2. I have access to read this blob from the Remedy system and save into an
attachment.

These are the methods which i have thought about, although i am not sure
about its feasibility and .
Method 1: Document generated will be read by calling a procedure using the
Direct SQL from the blob data(although i don't know how to do this via PLQL
if at all if its possible - if anyone knows please lemme know) and save into
the filesystem. As soon as it is saved, i will call the
PERFORM-ACTION-ADD-ATTACHMENT and save it into the required attachment
field.
Method 2: Document generated will be read by a java program which access the
data and saves it as a file in a location which will be called by RUN
PROCESS command line. As soon as it is saved, i will call the
PERFORM-ACTION-ADD-ATTACHMENT and save it into the required attachment
field. Now in this I am not sure how and when the return is going to happen
when i call the RUN PROCESS to execute the java code. 

I would like to have your views, inputs and anything useful regarding this.

Cheers,
Naveen

-----
With Warm Regards,
Naveen
-- 
View this message in context:
http://old.nabble.com/Document-Save-from-Database-tp29192886p29192886.html
Sent from the ARS (Action Request System) mailing list archive at
Nabble.com.

____________________________________________________________________________
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Reply via email to