Month: July 2008
July 8

HOWTO: Create a Native Database Web Service

I noticed that when I wanted to do some tests with the 11g Native Database Web Service (again), NDWS for short, that I had to gather the information from all over the place on my site. Which was not so very handy. So here a short intro how to set it up, configure and deploy it, also based on the OTN XMLDB Forum example from Mark Drake.

Overview

In short you will have to do the following steps:

  1. Install Oracle XMLDB
  2. Enable the Protocol Server for HTTP access
  3. Enable the orawsv entry points in xdbconfig.xml
  4. Create an example to test the NDWS service
  5. Test the NDWS service by calling the WSDL entry point
  6. Troubleshooting

Sounds very complex, doesn’t it? But be assured, it isn’t at all. As pointed out, most of it is described in posts on this site.

Read the postHOWTO: Create a Native Database Web Service
July 3

Oracle OTN SAX Loader Example

I tried to replay Marcelo Ochoa’s example called “Uploading WikiPedia Dumps to Oracle databases“. I noticed that the reference to the OTN SAXLoader Example was corrupted / partially unavailable.

While searching on my local hard drive, I noticed that I, a long time ago in 2006, downloaded the zip file. Although of course, there is no support from Oracle for it anymore, at least I would expect it tbo unsupported because of the very outdated example, I made it available here for people who still can use it and are in need for an SAX loader example with which will able you to import / load very huge XML files into the database.

The OTN XML DB Sample had once the following available:

Read the postOracle OTN SAX Loader Example
July 1

BEA Welcome and Oracle’s Middleware Strategy Briefing

I just got a hint from my colleague Lucas, via the AMIS internal channels (aka “sharepoint”), that there will be a strategy briefing via webcast about “Oracle Fusion Middleware and the important role BEA’s products will play”. I think this is worthwhile listening / viewing.

I installed this weekend the BEA WebLogic Server 10.3 Technical Preview to get myself acquinted again with BEA’s products. BEA WebLogic is an Application Server that I once mastered while supporting a PeopleSoft environment.  I always enjoyed working with the BEA WebLogic Server because it had a clear interface and (in my time) was a stable environment in conjunction with the PeopleSoft structures.

Read the postBEA Welcome and Oracle’s Middleware Strategy Briefing