HOWTO: Create a Native Database Web Service
Posted on July 8, 2008
Filed Under 11g, Howto, SQL*Net, Protocol Server, XMLDB | Leave a Comment
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:
- Install Oracle XMLDB
- Enable the Protocol Server for HTTP access
- Enable the orawsv entry points in xdbconfig.xml
- Create an example to test the NDWS service
- Test the NDWS service by calling the WSDL entry point
- 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.
Oracle OTN SAX Loader Example
Posted on July 3, 2008
Filed Under General, Howto, XMLDB | Leave a Comment
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 more
BEA Welcome and Oracle’s Middleware Strategy Briefing
Posted on July 1, 2008
Filed Under General | Leave a Comment
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.
I have a guess that the BEA WebLogic Server will be indeed a important asset in Oracle’s Product line. I am curious what the future of OC4J will be in Oracle’s strategy, how BEA AquaLogic will fit in, ESB or EBA BPM Studio.
Anyway have a go at 18:00 CET (9:00 a.m. PT / 12:00 noon ET) via the following URL:
BEA Welcome and Oracle’s Middleware Strategy Briefing
Don’t miss the special Juli 1 Webcast featuring Oracle President Charles Philips and Senior Vice President Thomas Kurian (SVP Fusion Middleware).
Join Oracle executives Charles Phillips, President, and Thomas Kurian, Senior Vice President, for an informative briefing that will explore how the addition of BEA products to Oracle Fusion Middleware creates a best-in-class combination, advances a common vision, and reinforces Oracle’s middleware strategy.
M.
This is so Wrong - WiiWare for the Wii !
Posted on June 26, 2008
Filed Under General | Leave a Comment
As if a Wii owner / user is not yet tempted enough, regarding those cool games.
For instance, I was able to get one of those very rare shiny Wii Boards (for the Wii Fit game, amongst others) and the first thing I see after finally being able to setup my wireless connection with my Linksys WAG200G router: WiiWare!
WiiWare is software, fully compatible with the Wii, that you can download via the Wii Shopping channel. I had some 1000 points left so downloaded an old favorite (Block Breaker, The Luxe) of mine for 8 euro’s (I guess roundabout 10 US $). It is a little bit more fancier than the one I have on my Nokia mobile phone but just as fun.
Looking around on the main page, I see there is some very teasing stuff, already out there or scheduled for the near future (”LostWinds” looks very cool!).
Ouch, those temptations… 
Oh and for those who might need the information…
Linksys WAG200G - Wii Wireless Setup
Linksys WAG200G:
- Mixed network mode
- WPA-2 mixed
- DHCP enable
- No further restrictions (yet)
Wii Settings:
- WPA-TKIP
BEA available on Oracle E-Delivery
Posted on June 26, 2008
Filed Under General | Leave a Comment
I have no idea when they made it available but, while searching on Oracle E-delivery for a complete Oracle BPA package, I saw that a lot of BEA software can be downloaded via Oracle’s E-Delivery channel. It look like it concerns all BEA software packages, although I don’t know their full product stack by heart.
Click on the picture to enlarge
It’s time to play…
Quering RSS Feeds The XMLDB Way
Posted on June 25, 2008
Filed Under 11g, General, Howto, Oracle, RDBMS, XMLDB, XSQL, XPath, XQuery | 2 Comments
Actually this is old stuff (2006), but it got lost in a comment section. I think this can still be useful to some and I also post this here for prosperity.
Somewhere in 2006 my colleague Lucas Jellema wrote a post on the AMIS Technology site about querying rss feeds from the database. My colleague Anton Scheffer and I commented on that article with our XMLDB functionality mindset. Later on in 2007 Lucas wrote another useful post called “Querying RSS feeds in SQL…“. Peter Wolf commented that he had also written a very nice blog post about using XMLDB functionality while Integrating Yahoo Pipes into APEX.
I think this is still useful stuff to a lot of us, although you should keep in mind that the table(xmlsequence(extract())) construct will be, in time, out lived by the XMLTABLE function. Also XMLTABLE supports XPath V2, the table(xmlsequence(extract())) doesn’t. The XMLTABLE function is available from Oracle database version 10.2.
