Logging SOAP messages to DB - 11g
By Prakash Yamuna on Sep 09, 2011
Quick note: If you were a 10g OWSM customer and were using the feature that allowed Logging SOAP messages to DB - you might have realized that there is no equivalent functionality in 11g. In 11g, OWSM supports logging SOAP messages to a file but not to a DB. If you want to log messages to the DB, you have two options:
a) You can write a custom assertion that logs the messages to DB.
b) Build some kind of an automation tool that can take messages logged to the file and upload it to the DB.
If you build a custom assertion - I suggest you use the category for the assertion as "security/logging". This will enable you to add the custom assertion before and after a security assertion - similar to the out of the box "oracle/security_log_template".
If you do decide to write a custom assertion - you will need to take into consideration a couple of key aspects:
- Performance implication - doing a synchronous write to the DB may be expensive - you may need some kind of an asynchronous mechanism to the write the message to the DB
- DB growth - if you have logging of SOAP messages enabled in a system dealing with huge volume of transactions - then the growth of the DB is a significant issue that you will need to consider.