Codedrop™ Weblog

Trying to integrate support for Oracle XMLDB in a grails app didn’t turn out to be as straightforward as you might think.  By putting the xmlparserv2.jar file in the $GRAILS_HOME/lib folder I was suddenly presented with SAX parse errors…
Luckily I stumbled across this post by Graeme Rocher who had a similar problem and identified [...]

A very useful feature of Oracle is the ‘CONNECT BY’ command. I make use of this whenever I need to generate any SQL output that has any sequential data as a key to the query. For example, a report of the number of logins per day or per hour.
To use connect by [...]

Here’s a quick solution for trying to extract the raw xml string from an Oracle XDB database when working with Grails.
After an initial attempt to hardcode a hibernate query to return the raw sql using .getStringVal() as follows:
SELECT x.id, x.xmlData xmldata.getStringVal(), lines.*
FROM xml_requests x
XMLTable(‘declare [...]

Below are the installation note’s I captured in installing Oracle10.2.0.1 on a Fedora 8 workstation. For some reason installations ofOracle on Fedora linux in past never went as smooth as hoped.. I washowever relatively happy with how things turned out on F8 and its niceto see some of the old problems, like hanging during [...]