Weblog for the AMIS Technology corner
Posts tagged Add new tag
Launchdate 1st July: JDeveloper 11.1.1.1.0 (Bulldog) – Interesting new features
Jul 1st
As part of the announcement on July 1st around Oracle Fusion Middleware 11g, Oracle released the next point release (11.1.1.0.2 => 11.1.1.1.0) of JDeveloper. And while the change is only in the fourth digit, 
there are still quite a few very interesting new options, features and components new in this release. In this article a brief and by no means exhaustive list of some of those new things as I have discovered them in the last few months.
This release 11.1.1.1.0 release had the internal code name of Bulldog and I have been referring to that name a few times before. One of the important changes since its predecessor (11.1.1.0.0, internally known as Boxer) is that now the full Fusion Middleware 11g R1 release is available, for which JDeveloper provides the design time environment. So the Bulldog release launched today has the design time for SOA Suite 11g and WebCenter 11g, to name but two. The WebLogic server that ships with this JDeveloper release is now the latest 10.3.1 – the foundation for FMW 11g.
Enhancing fast queries using “Tapio-Indexes”
Jun 4th
During the years I have a lot of times encountered performance problems that ended up to be fast queries (less than 10ms) which are executed very much. In these situations the execution plans, from such queries can look like:
OPERATION OPTIONS OBJECT# NAME
-------------------- -------------------- ---------- -----------------------------------
SELECT STATEMENT .
SORT ORDER BY .
TABLE ACCESS BY INDEX ROWID 120713 XXX.TABLE_WITH_MANY_COLUMNS
INDEX RANGE SCAN 121558 XXX.INDEX_WITH_FEW_COLUMNS
In a lot of cases we deal with a query for example which is returning fewer columns than exists in the involved table like four, from an involved table having twenty columns. Although the execution plan looks already pretty “OK”, it still results in a query which is in top three most resource taking queries.
To enhance the query we can use “Fat Indexes” or nowadays better known “Tapio Indexes” (I call them like that nowadays). What are these kind of indexes…. In principle nothing really new, but for me a couple of years ago an (re)eye opener by Tapio Lahdenmaki. This Finish independent database performance consultant and instructor gave a presentation at Miracle Open World 2007 in Denmark, I attended. Tapio can present this topic in a very special way, and in my opinion “his message” should be known by all developers and dba’s.
ADF 11g – Invoke a Popup from a Popup
May 18th
Today I was triggered by a question on the JDeveloper forum about invoking a popup from a backing bean. Actually some time ago I had to build that solution for one of my customers that needed some kind of confirmation to the user that an action invoked in a dialog popup was succesfull. The flow in this solution was more ore less like this: Invoke a dialog popup –> press ok (or cancel) in the dialog –> if ok was pressed, invoke the dialogListener which contains the actual logic to be executed. In case the action is succesfull, show another popup that tells the user "all is well" in all the other cases do something different. Read the rest of this entry »
Echo2: Building a web application without web skills…without web skills…
Feb 6th
Echo2… oh no, naf! (not another framework). I just want java, not some tricky framework I have to learn into depth before being productive. Ok, then you’re up to Echo2!
Building a complete interactive web application with partial page refreshing (AJAX) without knowledge of AJAX and even without knowledge of (X)HTML, Javascript, JSP, TLD, XSLT. That can’t be possible or can we do this? Yes we can!
Agile software development, the principles. Principle 9 : Continuous attention to technical excellence and good design enhances agility
Dec 28th
This is the ninth of 12 posts about the principles of agile software development. Purpose is to go back to the start of the agile manifesto (http://agilemanifesto.org/principles.html) and discuss the implementation of the 12 principles in real life software engineering. Goals of agility are to go deliver software of higher quality, faster, with a higher acceptance to end-users and able to follow the changing business requirements to strive for competitive advantage.
The question is: is this going to work in practice or is this only based on a nice marketing and sales story.
Principle 9: Continuous attention to technical excellence and good design enhances agility.
The first time I looked at this principle I thought: “How is this possible”. Agility focuses on quickly delivering working software (reading: “Quick and dirty”). I experienced this is not true. Attention to technical excellence is making the agile process working better. Technical excellence can make the development process more flexible. In this context I would like to point out that there is a difference between technical excellence / good design compared to complex design and technical complexity. How many developers, designers and architects (the ivory tower / PowerPoint architects) cannot resist creating complex designs, patterns and code with no other purpose than to show off their technical superiority? How many projects have stranded in complex designs and abstract meta-models without creating any business value? These projects are good to be displayed in the Museum Of Modern Software Development but completely useless in the real world.
Smart technology and smart design
Every developer, architect and designer must work with principles of smart design in their minds. In my opinion there are only two principles: 1) the concept must work and 2) other team members understand and are able apply the principle.
Smart technology and good design has its greatest advantage when it is used for the benefit of the whole application and the whole team. Not just for sub-optimal improvements for a single function or a single developer. Good excellent technology and good design has to make coding easy and the application modular, more flexible and adaptable. By using the right frameworks and supporting tools you are able to deliver higher quality software much faster than you where used to. In practice this means using frameworks for common tasks like authorization, persistence and navigation and tools for building, releasing and deploying your application.
In fact all tasks, that are labor intensive and demand a lot of concentration and focus, are likely candidates to be implemented via frameworks and tools.
Some sql scripts for analyzing Oracle eBS
Nov 11th
While working in Oracle eBS it can sometimes be very helpful to have a quick overview of how and/or what is setup. Sometimes it is enough to just use what was made available to you and by clicking through the available setup screens you will simply find what you are looking for. However, in some cases you end up not having the right responsibilities to see these details or you just want to prevent scrolling and clicking through these windows or combine details from different screens. Read the rest of this entry »
ADF 11g RichFaces – Creating a googleMaps Mashup Part I: clientListeners and clientAttributes
Nov 3rd
While creating the itinerary for my next trip I had to look for things like campgrounds and gasstations on my route. For this I use google Maps. It wasn’t the first time I did this, however this time I wondered if it was possible to integrate googleMaps in an ADF 11g application. It turned out that it wasn’t that difficult at all. I decided to share my findings here. In this part I will show you how you can use <af:clientListener/> and <af:clientAttribute/> to pinpoint a location in your ADF application on the map.
Read the rest of this entry »
Extreme performance introduced by patchset 11.1.0.7 smart scan
Sep 25th
Larry yesterday did his keynote here at Oracle Open World introducing the "Oracle(R) Exadata Storage Server". This morning I attended a session about the technical details behind the server. In principal the server works with 8 nodes running RAC on Oracle Enterprise Linux 5. For the storage management ASM is used and since 11.1.0.7 smart scan has been introduced. Smart scan has been designed for very big data sources used in queries, like in Data Warehouses, where tables from tera bytes are common. In principle the following is accomplished using smart scan: Read the rest of this entry »
