Author: Lucas Jellema
The UNPIVOT operator was introduced in Oracle Database 11g – see for example: https://technology.amis.nl/blog/2421/the-oracle-11g-unpivot-operator-turning-columns-into-rows. In Oracle, the UNPIVOT operation is the process of turning Columns to Rows. Put simply, …
This article shows how to create a widget in an ADF Faces application that looks like this: This table shows a comparison between records – Departments in this case …
I may have bored you before with stories about Data Visualization. It is one of my favorite topics. We deal in data. And visualization of data can help to …
I am presenting later today on the Oracle Fusion Middleware Forum (Spoorwegmuseum, Utrecht). The topic of today’s presentation is cloud computing – especially Platform as a Service – and …
As a followup to my recent article on how to Produce and XML document based on data in a POJO structure using JAXB (https://technology.amis.nl/blog/12499/creating-an-xml-document-based-on-my-pojo-domain-model-how-will-jaxb-help-me) I will describe in this …
The challenge is a common one. We have got data in a domain model, based on POJOs. And we need to marshall that data into an XML document. Note …
The other day on one of the projects I am involved with, we ran into an unexpected exception, from an innocent looking EL expression: javax.el.PropertyNotFoundException: … value=”Book #{book.title}”: Missing …
I have always had a fascination for the Data Visualization capabilities of all the tools and technologies I have worked with. For example: I worked with Oracle Graphics 2.0, …
In the past few weeks, I have encountered a similar discussion in various organisations. Each organisation uses either SOA Suite (11g) or Oracle Service Bus (11g) at the core …
ADF comes with a rich collection of component that allow us to visualize and analyze data in ways that previously were only available in fancy OLAP and other BI …
Some IT organizations that I visit have a sign somewhere indicating the number of days that have passed without a major issue. Production sites with proper respect for health …
Whilst preparing for the Thursday Thunder session at the last day of the ODTUG Kaleidoscope 2011 conference in Long Beach, where an all star team of moderators and developers …
It is just a little feature addition – this ‘Test WebService’ button in the WSDL Editor in JDeveloper 11g Release 2 that was released last week. But it can …
You may have seen we write on Flashback functionality in the Oracle Database. It’s an area that I like – especially since the introduction of the Flashback Data Archive …
This article demonstrates how, through a bit of JavaScript interacting with the HTML 5 Navigator API, some more JavaScript using the ADF Faces Rich Components API and the ADF …
This very brief article demonstrates how a fairly complex, nested JSON document can be created using a single SQL query. The main features used in the SQL statement are …
Once upon a time, I had something of a reputation for creating Charts in SQL. Bar Charts, Pie Charts, Gantt Charts and several other unlikely chart types, all created …
This article illustrates the use of a custom ELVariableResolver in JavaServer Faces applications. In this example, we extend the basic functionality of JSF EL resolution with the ability to …
The Spring Framework is omnipresent in the world of Java applications. Many developers, teams and organizations make use of Spring for various reasons, such as its persistency support, the …
One of the topics I discussed in today’s Masterclass Advanced Database Development was inter-session communication – or how database sessions can exchange information. One of my favorite vehicles to …
Two small new features caught my eye while scanning the 11gR2 new features list for ADF DVT. One applies to the Carousel, the other to the Hierachy Viewer. They …
After my initial adventures (see https://technology.amis.nl/blog/12198/first-impressions-of-the-thematic-map-component-in-jdeveloper-11gr2) I continue to explore the wonderful world of the Thematic Map component. The previous article demonstrated how data in database tables could be …
My curiosity was piqued by all the tweets from JDeveloper and ADF experts about the hot reloading capabilities of JDeveloper 11gR2. Those capabilities that should allow we to run …
One of the components in JDeveloper/ADF 11gR2 I have really been looking forward to – ever since I saw some very interesting and creativity inspiring demonstrations at Oracle Open …
Early this morning, Oracle released JDeveloper 11g Release 2: This release can be downloaded from http://www.oracle.com/technetwork/developer-tools/jdev/downloads/index.html This list of new features – long and quite impressive – is here: …
De Oracle Database is in zekere zin ook een Applicatie Server. Of in elk geval is de database een zeer krachtige infrastructuur die door allerlei soorten applicaties kan worden …
Aanstaande dinsdag organiseert in het kader van de maandelijkse ‘AMIS Academy Adventure’ een ‘voeten in modder’ en ‘handen aan de ploeg’ evenement, met maar liefst 5 parallel-sessies. In elke …
On April 19th, AMIS organized a BYOL session (bring your own laptop) on Complex Event Processing. This session was a combination of lecture and demo, some discussion and handson …
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 …
![Wat kan je als Forms of database ontwikkelaar met Oracle Database Release 11g?]({"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"} "Wat kan je als Forms of database ontwikkelaar met Oracle Database Release 11g?")