Author: Lucas Jellema
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 …
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 …
Who is not raving about Web 2.0, the advent of Rich Internet Applications, the marvels of AJAX and of course the wonderful, productive world of Java Web application development …
It is not terribly important. But since I found the solution, I thought I’d share it with you anyway. During our Oracle 7Up workshop on SQL last week we …
My first experience with BPEL was late 2004 using the Oracle BPEL PM and Designer plugin for Eclipse. Afterwards, I have worked primarily with the Oracle JDeveloper BPEL Designer …
Every once in a while you run into a SQL challenge that seems extremely simple at first glance and turns out to be not so very simple when you …
Query Rewrite is an increasingly more important feature of the Oracle database. Linked intimately to Materialized Views, Query Rewrite is used by the CBO to make queries leverage intermediate …
In preparation for the Oracle 7Up Workshop as well as the Oracle Quiz – The Water is Still Burning (presentation and paper) with Alex for the ODTUG 2006 conference …
With the advent of the Oracle 7 RDBMS – 1993 – a new era dawned. Many of the key database functions and facilities, such as (Enforced) Integrity Constraints, Stored …
Yesterday it was announded by JBoss that it signed an agreement to be acquired by Red Hat. See the announcement at www.jboss.org. After several months of rumours about a …
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 …
Using email as a decoupled integration mechanism for applications is a fairly crude and simplistic yet effective approach. Messaging infrastructures – MOM – were all the rage, and still …
This article is about a generic service that takes a simple HTML Form Post and turns it into an Email. It is not revolutionary – but useful nevertheless. Besides, …
… well, at least than I thought. Specifying default values for columns in our database tables seems like a pretty simple and straightforward task. The default is either a …
In a previous article (AJAX – What’s the Buzz Part 1), we discussed the introduction to AJAX as a Design Pattern. We saw a simple demonstration leading up to …
Next in my series on Design Patterns and their implementation in PL/SQL – also see previous articles on Dependency Injection of Values, Dependency Injection of Interfaces and the Template …
Last week, my colleague Marcos guided us through the still relatively new Oracle offering called XML Publisher. During a session of our Knowledge Center on Oracle Development Tools, we …
Yesterday we had a workshop titled: Ajax, What’s the buzz? During this workshop, we discussed AJAX – Asynchronous JavaScript and XML, notable examples of Ajax implementations, the repercussions Ajax …
This week we had many new books arriving. Three boxes came in with over 30 books. Among them are:
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 …
Kennisdeling, onderlinge kennisoverdracht en samen op onderzoek met nieuwe tools en technologie is sterk ingebed in de AMIS organisatie. Deze weblog is daar een uiting van, onze artikelen in …
Today I attended – and presented at – the Database Systems 2006 conference – an annual Dutch conference on Database Architecture and Technology, Enterprise Integration and Service Oriented Architectures …
We at AMIS have a fairly long tradition when it comes to having developers attend the annual ODTUG (Oracle Development Tools User Group) conference. My first conference – while …
For one of our current Java development efforts – a Web application based on JSP, Struts, Oracle ADF technologies – we had to develop functionality to transforms HTML documents …
After quite a few encounters with .NET in recent years, primarily up against Java/J2EE technology – and some with VB before the release of .NET in 2002 – yesterday …
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 …
One of the new features in Java 5 that clearly stands out is called: Annotations (JSR-175). Through Annotations, we can add metadata to our Java sources, not just as …
Some weeks are relatively quiet, some are more hectic. This past week leans towards the latter catagory. Apart from the normal every-day routine, there was our Knowledge Center session …
In a previous article, I discussed Dependency Injection (aka Inversion of Control and the Hollywood principle) and more specifically an implementation of Dependency Injection in PL/SQL. In that we …
These days I am working on a series of articles discussing Design Patterns and their implementation in PL/SQL. In previous articles, I have discussed Aspect Oriented Programming and Dependency …
J2EE contains a plethora of API definitions. From the Servlet API to the EJB API, from JMX to JMS. One of the APIs that I have had very little …
Frequently our code has dependencies. Some are intrinsic dependencies, like the packages we need to invoke and the type definitions we rely on. Other dependencies are more like configuration …
One of the hottest topics in Java programming right now is probably Aspect Oriented Programming. Made popular by frameworks such as AspectJ and Spring, AOP refers to a new …
In a previous article, Introduction to Blackbox testing of Web Applications using Selenium I have introduced Selenium, a framework for Web Application testing – any HTML/JavaScript Web Application, regardless …
After my visit tot JavaPolis, in December 2005, I wrote a brief article on Selenium, a tool for testing Web Applications. For one of our internal Knowledge Center Sessions …
While I was reviewing today’s statistics of our weblog, I noticed a referrer in our top 10 that had guided 24 readers to one of our articles. I …
This article is the sequel to EJB 3.0 Persistence – Introducing EJBQL 3.0, an introduction to EJB QL from an historical, strategic and functional perspective. In this post I …
Last week, release 4.0 of JUnit was published. You may have seen some of the announcements. The JUnit homepage (http://www.junit.org/index.htm)does not reflect this fact at the time of writing, …
For one of our Java projects, I wanted to help a colleague getting started with unit testing. Due to high time pressure, there was a real risk that – …
One of my colleagues needed a simple report on the Entities with their Attributes as defined in an Oracle Designer Repository. Having spent far too much time in the …