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 …
Category: IT
Generating PDFs from ADF Business Components View Object datasets using XSQL
In the projects we do, we very often encounter the requirement for generating PDF documents containing data or reports from a database. We usually meet this requirement by creating …
Model Driven Architecture (MDA)
Introduction MDA stands for Model Driven Architecture. It is a framework from the Object Management Group (OMG). The basic idea about MDA is to generate code from visual UML …
Integrate webforms application with InterConnect and BPEL
In the last months we have been busy building and extending a webforms application (10g rel 2) to integrate with Oracle InterConnect. The webforms application is a home-build application …
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 …
Software Deploying using ANT
Some time ago a customer of AMIS asked me to setup the automatic deployment of the software for their application. Till then this was done manually, took an awful …
KC SDPL – Jonathan Lewis
Eindelijk zijn ze er dan. De presentaties over het Seminar van Jonathan Lewis. In dit zip-file zitten de presentaties die Anton en Alex gedaan hebben. Ook zitten de demo-scripts …
Better Builds With Maven – Free book about Maven 2
April 27, 2006
Book reviews and Publications, IT, Java, Software Engineering, Web HTML5 CSS3, Web/Java
2 Comments
When I was browsing through some articles on JRoller I found this interesting free book. As far as I know this is the first book about Maven 2. There …
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 …
SpringOne conference
Op 15 en 16 juni aanstaande wordt de SpringOne conferentie gehouden in Antwerpen. Dit is de eerste Europese conferentie die specifiek op het Spring Framework betrekking heeft. Het evenement …
Oracle and resilvering on AIX
Oracle and resilvering data on Mirrored Logical Volumes on AIX How to set up your storage with regards to Mirror Write Consistency Suppose you have or plan to implement an …
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 …
Hiding the Web.show_document URL
![Hiding the Web.show_document URL]({"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"} "Hiding the Web.show_document URL")
Last week I delivered a Forms module which invoked the Oracle Reports server by submitting report requests displaying the report on the screen using the Web.Show_document procedure. One thing …
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 …
Construct a "Save" URL syntax for the Oracle Reports Server
For a customer had to create an Oracle Forms functionality which would need to make several requests to the Oracle Report Server. The customer wanted me to generate a …
Friday afternoon – updating Oracle XE
I had nothing really to do this afternoon, so i updated Oracle XE (10.2.0.1 Beta) with the Oracle (standard database) patch 10.2.0.2, that is...only the data dictionary part. Just …
Oracle Forms: Productivity with new choices
Last Monday we had a KC meeting, where we discussed the latest features of Oracle Forms (OF). Basically these features break up into two categories: Oracle Forms Pl/Sql features …
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 …
Back to the future (Oracle 4.1 VM appliance)
We had some nice KC-DBA (expertise meetings) meetings in 2005. One of them was about virtual machines (VMware basically). To show how you could use virtual machine technology 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
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 …
A truckload of new books
This week we had many new books arriving. Three boxes came in with over 30 books. Among them are:
Oracle introduces free database development tool
Oracle recently released its first production version of a graphical database development tool called “SQL Developer†(version 1.0) – formerly project Raptor. If you have ever worked with Oracle …
Oracle Forms for games?!
Tired of writing only administrative applications? Try a Forms game.
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 …
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 …
More Jonathan Lewis
A little while ago, Jonathan Lewis presented a three day seminar in The Netherlands. You may have read other blogs on this site about this seminar. AMIS had sent …
Integrate webforms application with InterConnect and BPEL
In the last months we have been busy building and extending a webforms application (10g rel 2) to integrate with Oracle InterConnect. The webforms application is a home-build application …
Design Patterns in PL/SQL – Interface Injection for even looser coupling
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 …
Design Patterns in PL/SQL – The Template Pattern
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 …
Some musings on JCA (Java Connector Architecture)
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 …
Dependency Injection in PL/SQL – Remove Hard Coded Dependencies from your code
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 …