Audit log table for webservice

Dedicated to DataStage and DataStage TX editions featuring IBM<sup>®</sup> Service-Oriented Architectures.

Moderators: chulett, rschirm

Post Reply
skywayterrace
Participant
Posts: 7
Joined: Thu Aug 15, 2013 8:49 pm
Location: ny

Audit log table for webservice

Post by skywayterrace »

Hi
I am using the ISD input-->Transformer ---> isd output and oracle Db connection to write the all webservice request to oracle database


any time when i get request..message is passed to isd output ...(i can see response in SOAP UI) but its not writing to oracle Db.

when undeploy the service..its writes to oracle db.I tried to transformer link ordering,increase isd output timeout value,buffer etc..


I appreciate inputs for unique problem.

thanks
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

It is writing them but not committing them, I'll wager. Use a small transaction size or an ODBC stage so you can specifically issue a 'commit' when needed.
-craig

"You can never have too many knives" -- Logan Nine Fingers
skywayterrace
Participant
Posts: 7
Joined: Thu Aug 15, 2013 8:49 pm
Location: ny

Post by skywayterrace »

Thank you, issue was resolved. Apologize for the delayed reply.

thanks,
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Out of curiosity - what was your actual resolution?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply