Posts tagged XML
A few months ago I came across a relatively new book: Processing XML Documents with Oracle JDeveloper 11g by Deepak Vohra (370 pages, Packt Publishing, ISBN 978-1-847196-66-8, February 2009).
It is an interesting mix of topics, all having to do with XML and most directly related to JDeveloper. The topcis and chapters do not at all times seem logically bundled together (for example design time and run time seem to be somewhat strangely intermingled in the book) but they provide a lot of useful information to any developer working on applications that involve XML in some way (and which one does not today) using JDeveloper as an IDE or Oracle XDK 11g..
And JDeveloper 11g’s XML capabilities may not be entirely on par with single issue IDEs such as XMLSpy, it certainly does a very good job at many frequent and less frequent XML tasks. This book does a good job at showing the various XML specific features of JDeveloper – although it also fails to mention one or two. It contains many examples of writing Java code to process XML in some way, primarily using XDK 11g; those examples are not always really specifically related to JDeveloper 11g, as the code uses standard libraries that can More >
An advert for myself. Wow! How cool is that…
The local Oracle User Group Holland starts on the 16th of April with a new series of presentations given this time by the Dutch Oracle ACE’s and Oracle ACE Directors under the compelling name "Oracle ACE Cases". They asked me to do the kick-off of the series… A whole evening with just me and "my" Oracle XMLDB. I felt honored, so I said yes, but was also surprised…
I still notice that "people" have problems regarding the "specialism" Oracle XMLDB. Is it development, dba stuff, an architecture, an appliance…? I was very proud to be able to present in 2007, for the first time, on a big symposium called UKOUG, although under the label "Fusion Technology". In 2008 I had the pleasure to be on the 25th anniversary of the UKOUG, this time I had to "compete" (if you make an attempt, why not grasp for the stars ) in the same time slot with a Mr. Tom Kyte and a Mr. Jonathan Lewis and this time my XMLDB topic was relabeled as "Server Technology".
So the name of the game is changing and being a DBA, I think this correct for core functionality as Oracle XMLDB currently is, at least since the Oracle 11g database release. I also like More >
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, '+' ), 2 ) || ' = ' || 4 XMLQuery( substr( sys_connect_by_path( level, '+' ), 2 ) RETURNING CONTENT).getnumberval() sum 5 from dual 6* connect by level < 6 SQL>/ PRODUCT SUM ------------------------- ------------------------- 1 = 1 1 = 1 1*2 = 2 1+2 = 3 1*2*3 = 6 1+2+3 = 6 1*2*3*4 = 24 1+2+3+4 = 10 1*2*3*4*5 = 120 1+2+3+4+5 = 15
Anton Marco’s first performance investigation:== First Time ==
Execution Plan ———————————————————- Plan hash value: 1236776825
—————————————————————————– | Id | Operation | Name | Rows | Cost (%CPU)| Time | —————————————————————————– | 0 | SELECT STATEMENT | | 1 | 2 (0)| 00:00:01 | |* 1 | CONNECT BY WITHOUT FILTERING| | | | | | 2 | FAST DUAL | | 1 | 2 (0)| 00:00:01 | —————————————————————————–
Predicate Information More >
My first days at AMIS I examined JasperReports (v. 0.6.3), an open source report-generating library. This tool is entirely written in Java and uses XML report templates to generate reports you can display on the screen, send to a printer, or save as a PDF document.
In order to fill a report with data, the report design (template) must be compiled first. This compilation is performed by the compileReport() method exposed by the net.sf.jasperreports.engine.JasperCompileManager class. Through compilation, the report design is loaded into a report design object that is then serialized and stored on disk (net.sf.jasperreports.engine.JasperReport). This serialized object is then used when the application wants to fill the specified report design with data. In fact, the compilation of a report design implies the compilation of all Java expressions defined in the XML file representing the report design. Various verifications are made at compilation time, to check the report design consistency. The result is a ready to fill report design that will be then used to generate documents on different sets of data. (more…)