Archive for May, 2007
Working with Mercury Quality Center
May 31st
Last few weeks I’ve worked with Mercury Quality Center (MQC). This product can be used to register the test scenario’s you made. For example the functional tests in Oracle E-business Suite. In MQC the scenario’s can be registered so tests in the future can be done in the same way as you did the original test. A very nice feature of MQC is that the tests can be automated. When the tests are automated the time you need to test your system can be reduced by hours. For example you can activate the test when your leave and when you come back the next morning the test results are displayed.
Read the rest of this entry »
Are Index Scans always good……
May 31st
During my work a lot of times I have heard the same rumour. Lots of people are stating that when a system is doing index scans the system is doing well. But is this actual true, that is the question. In my work I experienced a lot of times that I was called to look at a system and specific queries (BI) where not performing well. In lots of these cases I saw that the system was doing lots of "db file sequential reads" and not "db file scattered reads". The "db file sequential reads" are used when index scans are done, the "db file scattered reads" are used when full table scans are done.
Read the rest of this entry »
Why I sometimes hate GUI’s…
May 31st
Hate?
Let’s say it is a love / hate thing, but I can’t help myself. I am a script nerd and probably always will be, but even I have to "evolve" or at least adapt to what the new software cycle brings. So preparing myself for the future, I based remote administration on Oracle Enterprise Manager Grid Control. I even updated the stuff to the latest re-lease 10.2.0.3. Working with these kinds of tooling makes you lazy, at least IMHO, and most of the time, it doesn’t learn you anything. What makes me really itchy is the following…
Introducing the Oracle PL/SQL Pseudo Code Compiler !?? – 3rd Oracle SQL Quiz – Smokin’ Water – All new, all intriguing – Come and participate: 20th June@ODTUG Kaleidoscope
May 30th
For the third year running, Alex and I will present the Oracle SQL Quiz on the ODTUG conference. This Quiz has a dozen or so questions on Oracle SQL and PL/SQL, that introduce some exotic, hidden or new as well as some fairly well known yet misunderstood features. Even die-hard Oracle developers tend to score less than 66% on the quiz, yet all of us learn from it!
One of the questions in this year’s quiz is based on the following case:
If you are curious as to what this is – please come and join us at the ODTUG 2007 Kaleidoscope Conference in Daytona Beach where we will present on Wednesday 20th June.
Using the javax.xml.bind annotations to convert Java objects to XML and XSD
May 30th
Did you know that when you put the @XmlRootElement annotation on any class you can have an XML representation of that class?
When I first saw Java 6 I didn't get very excited by it, but I have found out some nice things (scripting and Derby for example). This article will also describe a new feature of Java 6. I believe it was also possible with JWSDP, but I don't like to search external libraries (or at least not standard in a Maven 2 repository
)
I wanted to put an get an XML document in and from a database. With the new JDBC 4.0 you can save and load the XmlType data type from your database. But this article is not about JDBC, it started as an article about it, but then I discovered some pretty cool featues with XML only. The JDBC 4.0 has to wait a little longer.
Read the rest of this entry »
Getting started with Derby – The java database bundled with Java 6
May 24th
I often need a database to perform some quick tests. I usually start my Oracle instance. This takes some time and for most things it’s overkill. So a database that starts up quickly and is easy to use and install was on my wish list.
Derby is very easy to install and because it’s bundled with Java 6 you don’t even have to download or install it (not that downloading 2 Mb is such a bad thing by the way).
My main goal is to get you up and running with Derby in no-time. There are enough reviews of Derby and strangely enough it’s also documented pretty well.
Donderdag 31 mei (17.00 uur): AMIS Mini-Conferentie – zes presentaties: SQL Quiz, ADF & Maven, .Net Windows Forms, Oracle BPEL & Workflow, Implementing a SOA Infrastructure, AJAX in ADF Faces
May 24th
Next month, the ODTUG 2007 Kaleidoscope Conference takes place in Daytona Beach, Florida. 125 presentations on Oracle Development tools related topics – database, SOA, BI, ADF, JEE 5, AJAX, Oracle Forms, .Net – attended by developers from all over the world, at a venue right on the beach: things could get worse! Out of the 125 presentations, no fewer than 9 are to be presented by AMIS specialists (and a 10th by a soon-to-be AMIS colleague). Thursday 31st May, we will present a preview of the AMIS contribution for those of you for whom it is easier to come to our office in Nieuwegein than to travel to Daytona Beach. Since that probably primarily applies to people from The Netherlands, the remainder of this article is in Dutch.
- Datum: donderdag 31 mei
- Tijd: 17.00 – 21.00
- Sprekers: Sjoerd Michels, Peter Ebell, Matthieu de Graaf, Alex Nuijten, Aino Andriessen, Lucas Jellema
- Aanmelden en meer inhoudelijke details: http://www.amis.nl/activiteiten
- Toegang: uiteraard gratis en inclusief diner
Presentaties:
- Implementing and Managing an Oracle SOA Infrastructure
- Oracle SQL and PL/SQL Quiz: Smokin’ Water…
- Just Press Next: Developing an Intelligent User Interface Through BPEL Workflow Tasks Using Oracle ADF
- Windows Forms: The Natural Successor to Oracle Forms?
- Build, Test, and Deploy ADF Applications Without Effort with the Use of Maven2
- Getting the Most Ajax out of ADF Faces: Developing Really Rich Web Applications
De meer
Read the rest of this entry »
Annoying pop-up’s (CiD adware) and the security equilibrium
May 22nd
I believe I am careful when I am on the internet.
My personal laptop is almost a fortress regarding protecting me from internet scum, so I try to protect it x-fold via Microsoft Defender, Search & Destroy, Firewalls, protected host and configuration files, WPA network connections, virusscan software, no browser caching, phishing filters, etc, etc, etc. Being aware that there is always a loophole to enter this fort, a "port d’entree", I am also very aware of what I am doing on the Internet, but alas, sometimes all precautions fail. If my precautions fail it is also, almost always, a very very nasty bug. A bug on which normal insect spray only causes it to evolve…
On the other hand, I , we have to do some work, so all these precautions are not (always) practical or very annoying and prevent me and you from working. If I am working with, let’s say application servers, these precautions can have strange side effects. I don’t like, what I call, paranoia systems/environments, where everything is controlled and my working progress is slowed down because of it. There is somewhere an equilibrium between the amount of security and functionality. If security is to tight, functionality diminishes and vice versa. Creativity is killed in the process or not, I have seen brilliant creativity of people in trying to circumvent security in such kind of very controlled secure environments. Old standalone windows commander executables where given a new start trying to avoid locked down Windows machines.
But anyway, I was bitten again. This time it was a very annoying pop-up that displayed commercial websites. Once in while one would pop-up without any reason while I was using Internet Explorer 7 (my alternative when my favorite Firefox browser doesn’t suffice). So I checked startup entries in my registry, Performed deep scan stuff via "Search & Destroy", looked into malicious looking programs resident in memory, did a full heuristic scan via my virus scanner software. I tried Google to find something sounding like "pop-up / adware / removing / detecting / etc", but this gives you zillions of other annoying Adware entries, more commercial sites to remove and sell you stuff.
At last I saw a starting point. Every pop-up Windows had a small title called "CiD". So I looked it up via Google.Almost immediately I found what I needed to remove this annoying behavior and read other frustrated victims sharing the same fate (http://www.lavasoftsupport.com/index.php?showtopic=7569). Apparently this bug is really smart and avoids almost every detection. What annoys me most in all of this, is that I, apparently, somehow installed the bugger and I have now idea when I did it… Realizing that you can do nasty things nowadays, for instance via XMLHTTPRequest, I maybe was infected somehow via a website but the when eludes me…
Things we have to live with I guess. The more incentive for me to make the move (also on personal machines) to Linux or an operation system that is so obscure that people don’t bother to write nasty programs for… Maybe, just maybe, I should revive my old OS2 Warp software (that is obscure!).

Using JMX to snoop on data manipulation events inside ADF Business Components
May 22nd
The steps for observing the Salary Changes made in an ADF BC application – JClient, JSF or WebService style does not matter – are pretty straightforward. Building on the implementation of the EmpListener in the article Using ADF BC Event Listeners to monitor data changes application wide through RSS Feeds and Monitor Pages, we simply add an MBean that is associated with the EmpListener and that exposes the most recent Salary Change Event information through the MBean Server. JMX Clients – either JConsole, other tools or a client we program ourselves – can connect to the MBean Server and read the details exposed by the MBean.

The steps:
Read the rest of this entry »
5-day ADF Training in The Netherlands – getting started with ADF BC, JSF, ADF Faces and ADF Model
May 21st
In the week starting 4th June, AMIS will organize another edition of its five-day ADF Training on the Oracle Application Development Framework. In particular, this training will address:
- ADF Business Components
- Java Server Faces
- ADF Faces
- ADF Model or Data Binding
The training is targeted at developers with some understanding of HTML/Web Applications and some database (SQL) background. Java skills are useful, but not required. Oracle Forms/Designer developers as well as developers with a different background are welcome.
The training will consist of a lot of hands on workshop and frequent but short periods of theory and demonstration. Of course it provides a lot of practical tips and guidelines, directly derived from the extensive project experience AMIS has built with ADF BC (since 2001), ADF Model (since 2004) and JSF/ADF Faces (starting 2002 with UIX, the predecessor of ADF Faces). After attending this training, developers will be able to start developing ADF based Web Applications. They will have a good foundation to further build knowledge and experience on.
Registration for the training can be done at: http://www.amis.nl/training You will also find more details on subjects and organization.
International Availability
If you are interested in this training
Read the rest of this entry »


