XML Data – To be stored or not to be stored, and beyond…
It is nagging… I got an email from that you are able to download the handouts from ODTUG until half September (download them now, 1/2 September they will be …
Category: XML
In between AMIS consultancy jobs…
This (for this site) is a strange post… I am looking for a consultancy job. Nothing new here, but only a strange way to make this visible to the …
Searching the AMIS Weblog directly from your Firefox searchbar
Why bother using Google if you know you will find the answer on this blog anyway? It would be a nice feature if you could search directly from your …
Oracle 11G: XMLQuery = eval
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 ) || ' = ' …
Building a report in XML Publisher
Last week I made my first steps with XML-Publisher 5.6 Desktop and I am very pleased with the simplicity you can create a report in such a short time. When …
EclipseLink – Youngest Open Source Project provides venerable Java Software – TopLink’s enterprise level Object Relational and Object XML mapping now open source
Some months ago, Oracle announced its plans to donate the high end Object Relational Mapping Framework TopLink to the open source community. To be more specific: under the EclipseLink …
Oracle 11g – First Impressions
The official launch is at hand. In less then 3 weeks Oracle 11g will be presented at the world during a, probably, great launch event in New York. AMIS …
Using the javax.xml.bind annotations to convert Java objects to XML and XSD
May 30, 2007
Java, Software Development, Software Engineering, Tools, Web HTML5 CSS3, Web/Java, XML
4 Comments
Did you know that when you put the @XmlRootElement annotation on any class you can have an XML representation of that class? When I first saw Java 6 I …
Brilliant use of XML in the relational database
A great example of how one could use the Oracle XMLDB functionality in a unforeseen way in your relational world, is being demonstrated by Laurent Schneider in his article …
New XML(DB) related whitepapers available from Ken Atkins
During OPP 2007, two presentations by Ken Atkins where given regarding XML(DB) items, featues and best practices. My collegae Alex Nuijten was also attending, and presenting, and hinted me …
Creating XML Data Services for Reporting and ESB integration using DBMS_EPG (the internal HTTP/PLSQL Gateway) and XMLType
Today I all of a sudden found myself investigating the creation op PL/SQL based Data Services, returning XML documents with data from SQL queries to HTTP Clients. The direct …
How to programmatically add a CDATA section to an XML document (with the internal Xerces)
This problem probably sounds very easy and it is actually very easy, but it took me so long to figure this out I think it’s worth a blog. I’ll …
How to call a WS-Security secured web service from Oracle BPEL
Introduction I have been investigating Oracle’s Web Service Manager recently. WSM is shipped with the new SOA Suite. The WSM is a service gateway. Existing services can be placed …
Transaction Dependent Webservice Invocation…or how to call a webservice from a database trigger and make the call part of the transaction
One of our clients asked us to help with calling a webservice from a database trigger. This webservice would duplicate the actions done by the database in a different …
XML-Publisher building a matrix report
Last week I experimented with XML-Publisher a bit. The goal was to figure how to built a matrix report with simular layout as an Oracle Reports matrix report. Would …
APEX installation via the Oracle Protocol Server (listener)
From time to time, people on the OTN XMLDB forum, ask if it is possible to connect via the Oracle Protocol Server (aka the Oracle Listener), for instance in …
Javapolis 2006 – Building Sexy Web apps with Flex
Last year I attended the Flex presentation by Waldo Smeets and played with the beta. I even gave a presentation and workshop about Flex at Amis, so there was …
Extraction information from the JHeadstart Application Definition file using xslt and a wiki
December 12, 2006
Oracle, Oracle Application Development Framework, Software Development, XML
No Comments
One of the challenges of developing (J2EE) applications is information. It’s very hard to have an overview of the different components, objects, database tables etc. and how they interact. …
Extracting Master-Detail data from an XMLType with a single SQL statement
Probably this is old news for all of you who have lots of experience with XMLDB, but for me this is something new. In order for me to remember …
OOW2K6 – and Mr. Kyte has left the building…
Tuesday - Getting into the spirit I am just joking, so far I haven't seen an Elvis look-a-like in town, but I would be very interested how Thomas Kyte …
OOW2K6 – Newbie impressions…
It's amazing how much Lucas already put to "paper", despite all the mishaps we already encountered. The last two days I lost track on Lucas because he has completely …
Oracle Open World 2006 – Almost there…
It's almost Friday, a day before our flight. Lucas and I will be off to San Francisco on Saturday morning. Lucas will give some lectures on OOW 2006; I …
Unit testing with XFire – How to test your SOAP server with a WSDL file
XFire is a java SOAP framework. Of course there is Axis, but I think XFire can replace Axis. Axis is quite a good framework, but I think XFire is …
XMLType and DBMS_OUTPUT
I just got started using XMLType. I know maybe a little late to start to look at it, but better late than never, right? Anyways, to see what is …
Getting started with Lucene 2.0 A powerful java search engine
July 23, 2006
Databases, Java, Software Development, Tools, Web HTML5 CSS3, Web/Java, XML
4 Comments
Lucene is a text search engine written in Java. It’s very easy to use (for both developers and users) and fast. The creator of Lucene (Doug Cutting) started with …
Mastering XML DB – Unexpected side effect of updateXML
When trying to create anonymous data, I encountered an unexpected side effect of the updateXML statement while updating XML documents in an Oracle 10gR2 (10.2.0.1.0) EE database. I got …
Verslag van JSpring 2006
June 16, 2006
AMIS, Databases, IT, Java, Software Development, Tools, Web HTML5 CSS3, XML
No Comments
JSpring vond net als JFall van afgelopen jaar weer plaats in de Reehorst in Ede, een mooie locatie en vooral goed bereikbaar met de auto. Er stonden weer diverse …
Pivot using BPEL
Purpose During the past weeks my collegues at Amis (Anton and Lucas) are pivotting using SQL and PL/SQL, so why not also do some pivotting in BPEL, just for …
Publishing Data Manipulation as an RSS Feed – using Oracle MOD_PLSQL and Flashback
Events in the database – such as Data Manipulation or DML, Database Object Manipulation or DDL, session connect and disconnect, database startup and shutdown, a user querying for specific …
Oracle Enterprise Service Bus (ESB) – A First Impression (and it's not bad at all!)
You never get a second chance for a first impression, the shampoo ad warns us. So every software vendor is likely to be a little nervous about showing a …
Advanced Javascript debugging with FireBug and analyzing your page with View Source Chart
FireBug is a debug tool that integrates with FireFox. You can change the DOM-tree, do logging, analyze AJAX-traffic, have advanced error reporting and probably some things I haven’t found …
AJAX validation with Spring without changing any java-code
SELECT * FROM RSS_FEED – querying feeds in SQL using Table Functions and XML parsing
In a recent article – Building an RSS Feed Reader in PL/SQL – using dbms_xmlparser, dbms_xmldom and dbms_xslprocessor for parsing and transforming – I discussed how we can create …
Building an RSS Feed Reader in PL/SQL – using dbms_xmlparser, dbms_xmldom and dbms_xslprocessor for parsing and transforming
This article will demonstrate how we can build an RSS Feed Reader in PL/SQL. We will use DBMS_XMLPARSER to read an RSS feed from an URL and parsethe RSS …
Parsing RSS and Atom with ROME, easier is impossible
ROME is a java library to do things with RSS and Atom feeds. Things can be reading, writing, merging and converting. Because RSS and Atom feeds are a standard …
JDBC Rowset
Do you still think the only way to retrieve data from the database is to use the java.sql.ResultSet? Try the new (hum) javax.sql.RowSet. One of the coolest features is …
SOA and Email in action – Starting a BPEL process instance by sending an email with XML content- on decoupled interaction between web-site and back office
In what is to become a series of articles illustrating a full blown business case for a Conference Registration Processing process implemented using Oracle BPEL PM, this is the …
Ten golden rules for SOA Design – Database Systems 2006 – part 2
The most provoking presentation I sat in on during the Database Systems 2006 conference was probably the one by Rick van der Lans, on 10 golden rules for SOA …
Converting Word documents to XSL-FO (and onwards to PDF)
In the not too distant past, I have had to implement solutions for generating PDF documents, based on dynamic data and a document template to be defined by the …
Oracle buys Sleepycat
It becomes stranger and stranger. After bying the open source company InnoBase, Timesten, and others, Oracle now also bought SleepyCat. Oracle also released its own freeware in the form …