Wow, I just realised it has been nearly a month since my last post. I think that is the longest since I started blogging. So here is quick round up of my life over the last month.
Starting with work - I have been working in the North East for the last month on an Apex project. Since I have been on site and in hotels in the evening internet access has been limited hence part of the reason I have not been blogging (I wanted to spend the weekends with the family, not my laptop!), this was until I discovered that I could get internet access in my room, anyway, I have finished up north for the time being now.
The work itself was very interesting and challenging and revolved around resolving message failures when XML data was being parsed into a Customer Datahub:
The application had to be able to be used to review failed incoming XML messages and compare them to data in the database that had been reassembled into XML format using XMLDB. The messages could then be edited and validated before being resubmitted to the queue for parsing.
A monitoring page was provided to display extracted data from various AQs in graph format along with the output from a cronjob that gave extra information about the state of the system.
The final part of the application extracted data from a set of staging tables that were used to send summary data to a proprietary Business Intelligence system. These data were again extracted, formatted and displayed along with the original XML message to help with viewing the audit trail.
The application makes extensive use of XMLDB for both building XML and extracting information from XML documents using XPath.
Its this work that has been keeping me off the streets for the last month, even to the point of not really doing much training. Ok, thats work done, I'll post the rest over the next few days.