RAC vs. Data Guard or "Political High Availability"
Thursday 14 december 2006, we had here at AMIS a Query called "High Availability: RAC vs. Data Guard" the Query was lead by Oak Table Network members Carel Jan …
Category: Oracle
The issue of Webforms and Internet Explorer add-ons
IE 7 Webforms jvm.dll crash
Disappearing Columns
At the site where I am currently working Oracle Designer is used. The version they have here, Designer 10, does not supprt XMLType and this posed a problem at …
APEX installation via the Oracle Protocol Server (listener)
From time to time, people on the OTN XMLDB forum, ask if it is possible to connect via the Oracle Protocol Server (aka the Oracle Listener), for instance in …
JDeveloper and Subversion
December 18, 2006
Continuous Delivery, Java, Oracle, Oracle WebLogic Server, Software Development, Tools
3 Comments
Like many others, we use Subversion as our preferred source control system (scm). Since a few months an official JDeveloper extension is available which makes our ADF development and …
First experiences with Oracle BPA (Business Process Analysis Suite)
I just noticed that the Oracle BPA (Business Process Analysis Suite) is available for download from OTN: http://www.oracle.com/technologies/soa/bpa-suite.html . I downloaded the 236 Mb zipfile and did the installation …
My Article on JDeveloper 10.1.3.1 just got published in JDJ (Java Developer Journal)
It is not a novel experience for me to have an article published. That has happened before. However, today I saw the article on JDeveloper 10.1.3.1 that I have …
Master Class Jonathan Lewis Cost Based Optimizer
A couple of weeks ago I was at a MasterClass from Jonathan Lewis about the Cost Based Optimizer. It was a very interesting two days and I like to …
A session you must attend – How to best achieve High Availability for Oracle Databases with Carel-Jan Engel and Jeroen Evers
As you can see in the announcement on the top of this page – tomorrow we will host the most exciting DBA event of the year: the AMIS Query …
Generate jsf navigationrules with JHeadstart
December 13, 2006
Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Web HTML5 CSS3
3 Comments
The templating mechanism of JHeadstart is a huge improvement over the previous versions. It is now quite easy to add your postgeneration changes to a velocity template and add …
Extraction information from the JHeadstart Application Definition file using xslt and a wiki
December 12, 2006
Oracle, Oracle Application Development Framework, Software Development, XML
No Comments
One of the challenges of developing (J2EE) applications is information. It’s very hard to have an overview of the different components, objects, database tables etc. and how they interact. …
Little trick to set the database context when using the ADF BC Tester
The Tester for ADF BC is a very handy tool, to verify the correctness of the Business Components we have created. However, there are times when the Tester is …
Continuous integration for ADF applications using Maven2
December 11, 2006
Continuous Delivery, Java, Oracle, Oracle WebLogic Server, Software Development, Tools
5 Comments
I am currently working in Nouméa, New Caledonia (western part of the pacific) to setup an environment for the continuous integration of ADF Faces applications for a department of …
Implement JAAS based Authentication and Authorization for ADF Faces applications on OC4J 10.1.3
Implementing JAAS based security – or at least Authentication and (role based) Authorization – in JSF applications is a joint responsibility of the Application and the Application Server. The …
Customizing BLAF for ADF Faces – easier than Skins for influencing colors and fonts
December 9, 2006
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Tools, Web HTML5 CSS3
26 Comments
One fairly common remark on ADF Faces applications is their Look and Feel. The default look and feel is the Oracle BLAF, and either you love it or you …
New books in our library
Over the course of the last few weeks, we had several book shipments arriving, filling the shelves in our library to the brim. It is interesting to note that …
Writing a Word Search puzzle solver in SQL
Brace yourself for yet another pretty useless demonstration of the unexpected wonders of SQL as well as my apparent lack of meaningful things to do with my life. Undoubtedly, …
Installation of Oracle Enterprise Linux on VMWare
Recently, Oracle announced and released it’s Enterprise linux. Time to check out what’s it all about! While downloading the software from OTN, I was surprised to see there were …
Myths on bitmap indexes
Although bitmap indexes are already available in Oracle 8i or even before (some sources even say 7.3!!!), they are still surrounded by many myths. Time for some clearing up. …
Setting properties per record in Forms MRB
![Setting properties per record in Forms MRB]({"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"} "Setting properties per record in Forms MRB")
This is probably described many times before, but you just can’t have enough example code snippets. Imagine you want to restrict users to update records which end-dates are in …
Dummy data without dummy tables – just a little SQL trick with the TABLE operator
While writing useless queries for solving exotic challenges, I realized that the use of dummy tables or unions of selects against DUAL for producing a few data-rows is a …
Using a SelectMany… component in a JHeadstart Advanced Search Form – search for all CLERKS & SALESMEN
November 27, 2006
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Tools
2 Comments
JHeadstart is capable of generating so called advanced search forms. These allow the end user of the ADF application created using JHeadstart to enter various search criteria on which …
XML-Publisher 5.6.2, datasource and users
XML-Publisher
WHEN-IMAGE-PRESSED Trigger problem in Oracle Forms 6.0
Yesterday we ran into Oracle bug 1004056 while coding a module for a customer. I hear people think "Oracle Forms 60 that’s old". Yes it is but it is …
XML-Publisher 5.6.2, the automatic install
Some time ago I experimented with XML-Publisher 50 Desktop. The tool of which it looks like it is going to replace Oracle Reports in the future. Although the desktop …
The ADF Faces inputText component
The ADF Faces library contains many JSF components. One of the most common used components is the af:inputText. In the JHeadstart it is the default type for most items. …
Configuring Oracle Enterprise Service and JDeveloper 10.1.3.1 on Windows – Create a JDeveloper connection to the ESB
Recenlty I installed both the Oracle SOA Suite 10.1.3 as well as JDeveloper 10.1.3.1 – the Design Time environment for the SOA Suite. Everything was set up locally on …
NLS enabled JHeadstart templates
JHeadstart is a great tool for generating ADF Faces applications. One of the main new features (since 10.1.3) is the templating mechanism. Almost everything is generated with velocity templates …
Invitation for AMIS Query (14th December) on High Availability: RAC vs. Data Guard with Oak Table Network members Carel Jan Engel and Jeroen Evers
AMIS is proud to announce our next AMIS Query (free technical seminar), targeted at Oracle Database architects en DBAs: Oracle Database High Availability – RAC and Data Guard go …
The SQL Query to power Google Suggest
You probably know Google Suggest or one of its derivatives. An input item on a web-page or another user interface where you can enter a value that all of …
Pimp you SQL Developer
SQL Developer released a 1.1 evaluation version a couple of days ago, which you can download here, and I noticed something very familiair. In Firefox you can have search …
Generate 'Delete with Confirmation' in JHeadstart applications
November 10, 2006
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, Tools
3 Comments
JHeadstart is one of the tools we use quite successfully here at AMIS. We have written on this blog about JHeadstart and ways to extend, enhance and optimally benefit …
Creating a message based routing service in ESB
Yesterday I blogged about difficulties in routing messages from an AQ adpater to different outputs using the Oracle ESB (https://technology.amis.nl/blog/?p=1395). I was unable to create a single router that …
Guaranteed delivery not obvious for ESB.
Recently I have made an ESB system based on dequeueing an advanced queue and conditionally forward of the content to different files on the file system. In the development …
How to start/stop OC4J-standalone as a Windows service
In one of the previous blog-articles a colleague of mine described how to start an OC4J-container on the command line. Which was and is correct, but… I’m a database …
Sneak Preview of Oracle Fusion Middleware for the Regional Directors (OOW 2006)
A rather interesting session took place last week during OOW 2006, away from the crowds in a small meeting room in the Mariott hotel. The group that assembled there …
OOW2K6 – Keynotes and Presentations
Most of the Keynotes and Presentations of Oracle Open World 2006 can be found here: http://www28.cplan.com/cc139/catalog.jsp As it says in smaller lettertype just below…easy to overlook… To download presentations, …
The Future of Oracle Applications – John Wookey at OOW 2006
One of the keynote speakers during last week’s Oracle Open World Conference van John Wookey, Senior Vice President for Oracle Applications. John is sort of an old acquaintance, as …
Extracting Master-Detail data from an XMLType with a single SQL statement
Probably this is old news for all of you who have lots of experience with XMLDB, but for me this is something new. In order for me to remember …
Oracle Enterprise Linux available [ for free! ]
Oracle Enterprise Linux is now available from the Oracle unbreakable 2 program and ISO’s can be downloaded for free – see Sergio’s blog here: http://www.orablogs.com/sergio/archives/001838.html. I heared from Dimitri …