Weblog for the AMIS Technology corner
Software Development
Masterclass Oracle 11g voor Database Ontwikkelaars – haal meer uit SQL en PL/SQL in 11g
Jan 23rd
Aanstaande vrijdag 27 januari verzorgt Oracle ACE Director Alex Nuijten bij AMIS Services in Nieuwegein een Masterclass voor Oracle Database Developers: iedereen die met enige regelmaat SQL en/of PL/SQL toepast in zijn of haar werk. In deze Masterclass leidt Alex de deelnemers rond in Oracle Database 11g Release 1 en 2 met als voornaamste doelstelling de bezoekers in staat te stellen nuttig gebruik te gaan maken van de nieuwe mogelijkheden in deze 11g releases ten einde code simpeler, beter, sneller en functioneel rijker te maken.
Alex staat wereldwijd bekend als enthousiaste verteller en duidelijke explicateur (hij heeft met die eigenschappen al meerdere speaker-awards gewonnen op internationale conferenties). Hij combineert een duidelijk overzicht van de theoretische achtergrond met sprekende demonstraties en praktijkvoorbeelden. Deelnemers kunnen idealiter zijn some wat droge gevoel voor humor waarderen – en zijn in staat om in een tamelijk intensieve dag veel nieuwe kennis te verwerken.
Voor deze Masterclass is nog een beperkt aantal plaatsen beschikbaar. Zie http://www.amis.nl/amis-masterclasses/masterclass-oracle-11g-voor-database-developers voor meer informatie en inschrijving.
Preparing your environment for modern open source Java libraries and frameworks using Git and Maven, throwing in Tomcat as a bonus
Jan 1st
In my investigations into jWebWSockets, Kaazing, Atmosphere, CometD 2 and other frameworks I came to understand that in order to get these frameworks installed, integrate them into my custom applications or run the samples to go with these products, it would be convenient if not essential to have an environment with Maven and Git operational – and having Tomcat ready to run helps too.
So I decided to set up these tools – and write a short article with some hints for future reference for me and anyone who might be interested. First of all, let me tell you that it took far shorter and far less trouble than I anticipated. It really was easy to have my environment prepared for big and beautiful things. In subsequent posts I will explain how to load and run the Atmosphere demos as well as the CometD 2 samples – leveraging the Maven and Git (and Tomcat) environment discussed in this article.
Manage Agility through Manage-ability – Introducing Design Time at Run Time in Oracle Fusion Middleware
Nov 10th
Below is my presentation from the OGH DBA, SOA & BPM Day on November 8th. My talk was about achieving instant agility with application, through the ability to manipulate behavior and look & feel of applications at run time. And also to provide various flavors – parallel versions – of the application through customization.
Oracle Fusion Middleware has built-in infrastructure to provide run time agility as well as customization. This infrastructure is commonly referred to as ‘design time at run time’ (and lately also the Fusion Extension Platform). It is based on MDS (meta data services) Repository and a bunch of run time, WYSIWYG tools: the composers.
To make agility work through design time at run time, it is adamant that organizations clearly define the roles and the process associated with it. And finding staff to play the role of ‘run time application editor’ will not be easy.
Solving connection problems using virtualBox:”SOA&BPM Development VM”
Nov 2nd
A few weeks ago I had to work with a virtual box by oracle with a pre installed Database (xe) and weblogic to do some BPM Studio work. After the default installation I expected to just start the Virtual machine, start the weblogic server and enjoying the advantages of having everything installed properly…
Not exactly because I could not get the right connection established and on the virtual machine I could not get the Weblogic Server started. If you encounter the same type of problem here is my solution that worked for me and perhaps as well for you. Hoping this will speed up things and to concentrate more on the BPM stuff then actually fixing the bugs on the VM Boxes J. Read the rest of this entry »
2 dagen seminar door Steven Feuerstein: Best of Oracle PL/SQL (8 en 9 december)
Oct 13th
Steven Feuerstein
In dit tweedaagse seminar neemt Steven Feuerstein je mee ver voorbij de basismogelijkheden van PL/SQL. Steven zal tijdens dit seminar de best practices behandelen die hij op tientallen plekken in de wereld heeft verzameld en die hij ook mede door zijn nauwe samenwerking met het PL/SQL product team van Oracle kan verifiëren en aanscherpen. Hij laat via code-voorbeelden en interactieve sessies zien hoe je als ontwikkelaar in staat bent om snel, hoogwaardige, goed onderhoudbare en uitbreidbare applicaties kunt maken.
Er is tijdens dit seminar voldoende ruimte om vragen te stellen en ideeën met Steven Feurestein uit te wisselen.
Bij dit seminar zijn de volgende zaken inbegrepen:
- Een exemplaar van het boek Oracle PL/SQL Programming (5th edition) van Steven Feuerstein (twv €71,-).
- Een PL/SQL quiz onder leiding van Steven Feuerstein met leuke prijzen.
- Ook ontvang je een gratis jaarabonnement op het PL/SQL Channel. Hiermee heb je toegang tot 27 uur videotraining (normaal $395).
Dit is de kans om in Nederland in een select gezelschap met één van de experts op PL/SQL gebied kennis te maken en je expertise in Oracle PL/SQL verder te vergroten. Meer informatie of inschrijven kan via deze link.
(NB: Deelname voor deze twee dagen kost 1050 euro)
OOW 2011 – What’s New, Improved and Coming in Oracle Application Development
Oct 3rd
Currently at Tom Kyte’s session regarding topics new, improved or coming in Oracle Application Development. Tom told about the history APEX has gone thru and the current setup with the APEX Listener and even the “PL/SQL Gateway” was mentioned. I always have to laugh a bit because this last one touches the XDB Protocol Server which can do way more then only this PL/SQL extension for APEX which has been embedded in this XDB Protocol Server framework. There is a APEX book out there that touches a bit the possibilities of the framework, one of the reasons I will promote and explain it a bit more during conferences like UKOUG, because I think its a shame that people don’t know its full potential. Anyway. Tom stressed once again that APEX is a serious environment regarding the huge websites out there based on APEX supporting 1000th of user sessions. Also it nowadays had a better debug support (4.1) and use / support for ROWID, improved data upload and calendar wizard support and redesigned websheets in APEX 4.1.
Most important, yet most overlooked..
Sep 15th
After reading the title of this blog post, you could easily be forgiven for not having a clue what this piece of writing will be about. Not to worry, soon, this will all change.
A warning is due, however. Being called the AMIS Technology blog, this place is usually (over)filled with code, code and then some more code. Not this time. Stop reading here, if you are looking for code.
This short article will be about the most overlooked part of software development. And I am not even talking about testing or documentation. No, there is another aspect to software development that seems to be neglected on an even larger scale.
How you manage to get an Object as outcome with a User task
Aug 12th
Here’s a short update for those who, just as I did, searched for hours to the solution of getting an outcome object instead of the standard outcome string of a Human Task. You need to know this one detail if you want to get the object as an outcome. And at the end it makes sense, as almost everything does if you know what to do 
.
Here it goes…
Remove duplicate rows with Oracle SQL ROW_NUMBER – intelligent and efficient data cleansing
Aug 2nd
I am quite sure I have addressed this before. But I could not find it readily and I needed it today. So here it goes:
I am loading data from some external source. Well actually, from several external sources. The loading of the data is done in a better safe than sorry way: it is very important that all records come in. At the risk of loading duplicates – we will get them all!
However, once they are all in, there are more in than we want: I have loaded quite a few duplicate records. That will hurt the later on, so the duplicates have to go. With Oracle SQL Analytical Functions, that is quite easy. In two steps:
1) identify the duplicates
2) remove the duplicates
Tour de France 2011 – Analysis using ADF DVT Graphs – Part 2 – Gap with Cadel for Top 5 throughout the stages
Jul 25th
This article uses the statistics about this year’s Tour de France to visualize the gap between each of the top 5 riders and Cadel Evans – throughout the 21 stages. It produces a line chart that provides easy insight in the history of this year’s event – making it abundantly clear that for example Contador never really stood a chance and only kept losing time. It also shows that Frank Schleck did very well indeed, outpacing is brother for the first 17 stages.
The chart this is created in this article looks like this:
It is fairly basic – created using only simple declarative ADF DVT settings. The greatest hurdle to overcome was the creation of a SQL Query that returns the required data in format that is easily consumed and processed by the graph.
