Codedrop™ Weblog

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 [...]