Processing large XML files in the SOA Suite

Emiel Paasschens 13

Read large XML files in chunks . Introduction At my current project, XML files are uploaded by the end-user in order to be processed in the Oracle SOA Suite. The XML files contain information about employers and their employees. Because an employer can have hundreds and even thousands of employees, […]

Oracle RDBMS 10GR1: solution to avoid character encoding in XML with UPDATEXML

Betty van Dongen

On a recent project, I ran into a problem with an XML document, that had to be enclosed within another XML document, generated from a database query. The problem I ran into was the character encoding of the XMLElement function, which eventually was worked around with UPDATEXML. In this blog […]

Turning any XML document into a Java Object graph using JAXB 2.0

Lucas Jellema 1

As a followup to my recent article on how to Produce and XML document based on data in a POJO structure using JAXB (https://technology.amis.nl/blog/12499/creating-an-xml-document-based-on-my-pojo-domain-model-how-will-jaxb-help-me) I will describe in this article how to go the reverse route: how to take any XML document and process it into a Java Object graph. […]

Handling Complex XML Schemas

Marco Gralike

Currently sitting in at Sam Iducula, Consulting member of the tech. staff and Mark Drake, Sr. Product Manager for Oracle XML DB. Before getting into the more in-depth topics Sam explained XML schema usage, for validation via XML schema validators like for example XML Spy or JDeveloper. This is currently […]

Oracle RDBMS 11gR2 – XML Data Partitioning – Part 1

Marco Gralike

  There is a Metalink note (563802.1) that has a very good example how XML data storage, partitioning can be achieved in Oracle version 9.2.0.3.0 (the first officially supported XMLDB database functionality) and onwards. Partitioning can be used in such XML situations to spread the I/O load and it also […]

TopLink 11g is available for download

Lucas Jellema

I just found that at OTN’s TopLink page the announcement is already published that was expected later today: TopLink 11g is available. Note that TopLink 11g is based on EclipseLink – an open source product under the Eclipse Foundation. All functionality of TopLink 11g is available in the open source […]

Oracle 11G: XMLQuery = eval

Anton Scheffer 6

A nice little trick on Oracle 11G is using XMLQuery as an eval function: SQL>l   1  select substr( sys_connect_by_path( level, ‘*’ ), 2 ) || ‘ = ‘ ||   2         XMLQuery( substr( sys_connect_by_path( level, ‘*’ ), 2 ) RETURNING CONTENT).getnumberval() product   3       , substr( sys_connect_by_path( level, ‘+’ […]