nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to handle XML content stored within oracle?

sentoo

Hello together, 
 
I am to create a report (my first report) that operates on an Oracle DB, so far so good. My problem/question is that the interesting column contains its' information as XML. From Oracle's point of view it is a CLOB. 
 
Background information: 
That table holds logging information from different applications. The information contained is about the application usage. As these applications differ quite much, they do not have a common DTD. That is why the column is of type CLOB and not XMLTYPE. 
 
Within such an XML information like this may be stored: 
<pre class='_prettyXprint _lang-auto _linenums:0'><?xml version="1.0"?>
<Search>
<section name='java'/>
<section name='eclipse'/>
<Term>
<operator value='OR'/>
<searchField name='title' value='j2ee tutorial'/>
</Term>
<Term>
<operator value='OR'/>
<searchField name='year' value='2008'/>
</Term>
</Search></pre>
 
Thanks in advance for your time. 
 
P.S. I hope the answer is not too trivial, as I have searched for a solution, but have not found something yet. Probably I am missing the right keyword to search for.

Find more posts tagged with

Comments

bhanley

First off, given the many ways BIRT can access data, I am sure there is not a single correct answer to this question. My opinion would be to create a scripted data source. This allows you the greatest degree of flexibility in how you access and process each XML stream in the DB. The issue here is that you need to use an XML data source to process your data, but the XML cannot be processed via an accessible URL; you need to go through a DB driver to get to the data itself. The different access needs introduce enough complexity that I would manage things in the Java layer and produce the data set that way. 
 
A scripted data source involves three things: 
 
<ul class='bbcol decimal'><li>A POJO representing a "row" of data on the report</li><li>A POJO that has an array of the data objects described in #1 and an iterator to access each object in the array.</li><li>A script in the onFetch method of the Data Set to map the POJO fields to the BIRT Data Set</li></ul>
 
It sounds complex, but it is really not. You access the XML in the Java layer and process it to produce an array of simple POJOs. 
 
There are lots of examples here and elsewhere on the Internet guiding you through the creation of this kind of data source. If you get stuck, post the questions here. I will watch the thread and get you through whatever comes up. 
 
The site is here to help. Good Luck!