New Book Shipment is in – recent titles on Web, Java and Oracle
Our monthly book-shipment just arrived and I am playing Santa Claus right now by handing out books to some eager colleagues. The list of titles we received this month …
Author: Lucas Jellema
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 …
Smart denormalization and Enhanced PL/SQL Function Call performance – Comparing Function Based Index and Materialized Views
Queries that contain calls to user defined PL/SQL Functions can be performance killers. If a function call is part of the WHERE clause, depending on the execution plan it …
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 …
JavaOne 2006 has started – get the hand-outs for the presentations now
Even when you are not in San Fransisco right now, JavaOne2006 will be on your mind somehow. Or if it is not, as a Java Developer it probably should …
Oracle Toplink goes open source – launch of the Community Edition
I just noticed the Toplink Essentials JPA (java Persistence API or EJB 3.0 Persistence) homepage on OTN: http://www.oracle.com/technology/products/ias/toplink/jpa/index.html . As you probably already know, Oracle has open sourced a …
It's a Chameleon! About JSF Pages that change their appearance mid-flight (or: programmatic manipulation of JSF UI Components)
One of the features in Java Server Faces that distinguishes it from for example JSP technology, is the ability to access UI Components programmatically, at run-time. This makes it …
Workshop on EJB 3.0 Persistence – Download Resources
Yesterday we had a very enjoyable and I think interesting workshop on EJB 3.0 Persistence. After a very nice dinner on our terrace – it was lovely weather – …
Recent changes in the EJB 3.0 Persistence specification (that invalidated my code)
While preparing for a workshop on the EJB 3.0 Persistence API that I will present later today, I decided – against all the instructions in demo-school and presentation-college – …
Oracle releases the UIX to ADF Faces migration utility
It was promised and now it has been delivered: The Oracle UIX 2.2 Migration Tool allows you to migrate a project built using Oracle ADF UIX to use Oracle …
Joyful Successor to Forms – Introduction to JSF (Java Server Faces) and ADF Faces
May 4, 2006
Java, Oracle, Oracle WebLogic Server, PL/SQL, Tools, Web HTML5 CSS3, Web/Java
4 Comments
Developing Web Applications using Java/J2EE technology has not been a picnic over the last few years. It was often hard work, complex, not very productive and the results were …
On returning a collection of user defined objects from PL/SQL to Java – shortcut using a sys_refcursor
Oracle 8.0 introduced Objects into the Oracle database, back in 1996. There has been a lot of ridicule for the OO features in the Oracle database, some of it …
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 …
On Web 2.0, RIA, AJAX and Java Server Faces – 2 May 2006: Presentation and Demonstration by Backbase (16.30 Nieuwegein)
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 …
The Next Value – How much higher is my salary than the next in (Dense) Rank – Oracle Analytical Functions
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 …
BPEL Project by Oracle and IBM – Open Source Eclipse BPEL Plugin
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 …
Find the number of descendant nodes in a SQL query – how many employees work (indirectly) for me? And what do they earn on average?
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 …
Cost Based Optimizing through time travel? – the value of meta-data for enabling Query Rewrite
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 …
Aggregating in SQL across multiple levels and along several dimensions using ROLLUP and GROUPING SETS
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 …
Oracle 7Up to 10g – How time flies… Training for seasoned Oracle SQL and PL/SQL Developers
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 …
JBoss to be acquired by Red Hat – The Oracle (Red) Heat is off
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 …
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 …
Implementing a stand alone Email Server – Getting Started with Apache James
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 …
Generic Service – HTML Form Post to Email Servlet
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, …
Defining Defaults – there is more to it than you think
… 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 …
AJAX – What’s The Buzz – part two (slightly more in depth, on challenges and solutions)
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 …
Design Patterns in PL/SQL – Implementing the Observer Pattern
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 …
Session on XML Publisher – The Successor to Oracle Reports?
April 2, 2006
Data Warehousing & BI, Development Tools, IT, Java, Oracle, Oracle E-Business Suite, PL/SQL
6 Comments
![Session on XML Publisher – The Successor to Oracle Reports?]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "Session on XML Publisher – The Successor to Oracle Reports?")
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 …
AJAX – What’s the buzz? Introduction and Workshop
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 …
A truckload of new books
This week we had many new books arriving. Three boxes came in with over 30 books. Among them are:
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 …
Kennis Maken bij AMIS – serie openbare kennis sessies, van RAC tot JSF en van Source Control tot Oracle WebForms
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 …
Database Systems 2006 – Conference on Service Oriented Architectures
March 28, 2006
Data Warehousing & BI, Database, Databases, IT, Java, Oracle, Oracle WebLogic Server, SOA
No Comments
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 …
ODTUG 2006 Kaleidoscope (Washington) – We are on our way… – AMIS does 9 presentations!
March 28, 2006
AMIS, Data Warehousing & BI, Database, IT, Java, Oracle, Oracle WebLogic Server, PL/SQL
No Comments
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 …
Calling a Servlet in Java Code through a Post Request – or: how Service Oriented we Are
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 …
Introduction to ASP.NET, ADO.NET – dead ringer for Oracle ADF?
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 …
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 …
Java 5 Annotations – Creating your own Annotation Type
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 …
What a week – sessions on Advanced Java, SOA, BPEL and the AMIS Crossroads project
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 …