Category: XMLDB

December 4

My presentation of 2nd of December during the UKOUG Conference… So what was in it? Mainly appetizers of how some useful things work and a little bit high level concepts. I demonstrated, I hope, new ways, with (some) foundations coming from XML DB functionality. How to interface with the outside world, for example, by directly saving and selecting from multiple XML files, on disk, from your database or getting or pushing data from/to the internet, like RSS data, getting data for your Google Maps API or easily setting up a SOAP web service.

So among others:

  • How to enable, disable the Protocol Server and to see its Status
  • Overview of the Protocol Server configuration file xdbconfig.xml, Its contents and meaning
  • Memory structures that effect the shared server and therefore also the Protocol Server
  • Protocol HTTP API’s like the PL/SQL Gateway, DBURI (oradb) and Native Database Web Services (orawsv)
  • An overview how the Native Database Web Services works + DEMO
  • An overview how the DBURI servlet works + DEMO
  • An overview of URITypes of  HTTPUriType and XDBUriType’s + DEMO’s
  • The possibilties of combining BFILENAME and XML, like selecting and save files directly from disk
  • An overview of Repository Event’s, how it works demonstrated via a simple DEMO
November 17
November 10

Sometimes the “how to validate XML” question arises again on the OTN XMLDB Forum. A quick start would be to read up on the XMLDB FAQ Forum questions were Mark Drake demonstrates XML validation via some good examples. Another resource would be to read the Oracle XMLDB Developers Guide chapter about “Transforming and Validating XMLType Data“.

People who just like me, try to answer for fun and/or as a mind game the questions on a Oracle OTN forum, and knowing that if you do not ask for specifics, that you will have to deal with “the merry go round exercise”: With every answer given, you discover that this wasn’t the solution which was hoped for. Sometimes I am up for this because I don’t want to be bitching about: