Author: Lucas Jellema
Aanstaande dinsdag 19 april ben je om 17.00 uur welkom bij AMIS voor een BYOL (bring your own laptop) sessie rondom Complex Event Processing. De sessie wordt geleid door …
In my quest to position ‘connect by’ (and its 11g successor, Recursive Subquery) as mechanism for recursive queries rather than just an hierarchical query facility, I stumbled across a …
Yesterday I presented the Masterclass Advanced SQL to an audience of very experienced Oracle Database developers – one veteran had started his career on Oracle 5 in the late …
It is only beta at this point, but the long awaited Oracle 11gR2 XE edition – free but with certain limitations – is available for download from OTN – …
I am frequently engaged in creating PowerPoint presentations (or Word documents) that contain many pictures. Logos, screenshots, symbols, photographs are typically combined to create a pleasing and effective visualization. …
The other day a colleague and myself were working on a BPEL process that should wait for a certain period of time for a message to arrive. When the …
The other day I received the following email: thanks for your ADF articles. I will need an urgent technical help. It would be highly appreciated if you help me. …
My favorite conference since 1997 has been the yearly ODTUG conference. Because of its size – that lends an intimacy to the event that is simply unique – and …
Remco is an interesting guy with unexpected ideas springing from a creative brain. He can make life interesting, challenging and puzzling. This time he had another interesting challenge – …
Een upgrade naar de nieuwste versie van de Oracle Database vindt zelden plaats op initiatief van het applicatie-ontwikkelteam. Upgrades worden meestal gedaan in verband met support-regelingen, op verzoek van …
Seems like stating the obvious: if they are are missing, they are not likely to be found, now are they? Makes you wonder what the alternative would be. Something …
In the recently published blog article Database Transaction Recorder – Adding Who to When and What to make Flashback take over from Journalling tables (https://technology.amis.nl/blog/10911/database-transaction-recorder-adding-who-to-when-and-what-to-make-flashback-take-over-from-journalling-tables) I have discussed how …
Today we had an interesting exploration into the many ways available in the Oracle Service Bus to load a piece of XML into a variable in a message flow …
I have to admit that, even though I have tried on several occasions to dive head first into APEX, so far I have only wet my feet. I have …
In previous articles, I have suggested that the arrival of the Flashback Data Archive in Oracle RDBMS 11g allowed us to finally say goodbye to journalling tables. Keeping track …
In my investigations into the role the Oracle RDBMS can play in application architectures and especially how Java applications can leverage the database, I have ventured into some strange …
This article demonstrates how Java application can query data from relational databases (well, in this case more specifically the Oracle RDBMS) without the use of plain old JDBC but …
There are several ways available to integrate content from UCM in Web Applications. The best known one is probably through the WebCenter Document Services (taskflows that can directly be …
It took me a while. I have read through at least a dozen different articles. Probably did many things that in hindsight were not necessary. But at last I …
The Patch Set 3 release of Oracle Fusion Middleware hit the streets a few days back. For many of the FMW components, this release is one that fixes bugs, …
The Patch Set 3 for SOA Suite 11g R1 that was released last weekend brings bug fixes, stabilization, further integration between components and a bunch of new features. Most …
The concept of design time @ run time that empowers application administrators and even end users to influence the application after it has been deployed has been gaining traction …
The article “Quickly creating, deploying and testing a WebService interface for ADF Business Components” (https://technology.amis.nl/blog/9726/quickly-creating-reploying-and-testing-a-webservice-interface-for-adf-business-components) that I recently published describes a way of very rapidly creating the HRService Web …
As you probably already know, ADF Business Components can very easily be exposed through a WebService interface. An Application Module can be configured with a Service Interface, ordinary ViewObjects …
It is a strange thing really: querying the database to find missing data. Queries usually report on what is there. Not the queries in this article (and its prequel): …
It happens quite frequently that in our database applications – in queries or in PL/SQL packages – we need to use the values from more or less standard domains …
The other day, I came across a press release – www.iso.org/iso/pressrelease.htm?refid=Ref1383 – from the ISO organization, announcing that they had issued new country codes for the islands in the …
One of the key objectives – though not ulterior motives – in Service Oriented Architecture is decoupling. By decoupling currently mutually dependent agents, we introduce more opportunity for flexibility, …
Usually in SQL queries, you will try to retrieve information from a database by reading specific records from the relevant tables. However, there are situations where what you want …
Really getting the most out of your database. That would be nice, given wat databases can do (and what you may have paid for them). Few serious Java Applications …
This article accompanies the similarly named article in the Dutch Java Magazine. It provides additional resources, some source code and an invitation to the 4 February Masterclass by Lucas …
In the email that informed me that in a few months time my Google Groups will no longer be supported or even available (ouch, that hurts) – I noticed …
PL/SQL Developer Tools Session Brussels (Belgium) will be the PL/SQL Hotspot of the world during the two-day OPP 2010 (ODTUG’s Oracle PL/SQL Programming) conference – that is co-located with …
Voor het vijfde achtereenvolgende jaar organiseert AMIS deze openbare bijeenkomst waarin uitgebreid verslag wordt gedaan van de belangrijkste conferenties van het jaar: Oracle Open World en JavaOne. Op woensdag …
A few moments ago, Ted Farrell completed his demonstration of ADF 11g – the premier framework for developing rich, multi-channel applications. In 30 minutes he ran the audience through …
Complex Event Processors are capable of handling large volumes of events – by filtering, aggregating or detecting patterns. Java Applications use a CEP to pre-process incoming signals. These applications …
Xenogenetics for PL/SQL: Infusing with Java Best Practices and Design Patterns – Alex Nuijten and Lucas Jellema PL/SQL is a venerable programming language that is both vital and very …
JavaOne started this morning with the first many dozens sessions and the Java Pavilion & Exhibition hall. The official kick off so to speak took place tonight, with Thomas …
Many organizations around the world have adopted Oracle technology for developing custom applications. Over the past two decades, they may have used PL/SQL, Reports, Forms, Designer, Portal or the …
After struggling a bit with various infrastructures that kept falling down (Oracle Wiki, Google Groups) I hope to have found a more stable environment to publish the resources that …