Single Sign On in UIX applications
In my current project I was asked to investigate the possibility of implementing a Single Sign On solution for a couple of Oracle UIX web applications I am implementing. …
Category: Oracle
Defining Defaults – there is more to it than you think
… well, at least than I thought. Specifying default values for columns in our database tables seems like a pretty simple and straightforward task. The default is either a …
Back to the future (Oracle 4.1 VM appliance)
We had some nice KC-DBA (expertise meetings) meetings in 2005. One of them was about virtual machines (VMware basically). To show how you could use virtual machine technology to …
Simulating sampling in PL/SQL
The standard PL/SQL package dbms_random only allows for drawing uniformly distributed (all numbers equally likely) random numbers. As far as I know, other discrete probability distributions have to be …
AJAX – What’s The Buzz – part two (slightly more in depth, on challenges and solutions)
In a previous article (AJAX – What’s the Buzz Part 1), we discussed the introduction to AJAX as a Design Pattern. We saw a simple demonstration leading up to …
Design Patterns in PL/SQL – Implementing the Observer Pattern
Next in my series on Design Patterns and their implementation in PL/SQL – also see previous articles on Dependency Injection of Values, Dependency Injection of Interfaces and the Template …
Session on XML Publisher – The Successor to Oracle Reports?
April 2, 2006
Data Warehousing & BI, Development Tools, IT, Java, Oracle, Oracle E-Business Suite, PL/SQL
6 Comments
![Session on XML Publisher – The Successor to Oracle Reports?]({"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"} "Session on XML Publisher – The Successor to Oracle Reports?")
Last week, my colleague Marcos guided us through the still relatively new Oracle offering called XML Publisher. During a session of our Knowledge Center on Oracle Development Tools, we …
AJAX – What’s the buzz? Introduction and Workshop
Yesterday we had a workshop titled: Ajax, What’s the buzz? During this workshop, we discussed AJAX – Asynchronous JavaScript and XML, notable examples of Ajax implementations, the repercussions Ajax …
A truckload of new books
This week we had many new books arriving. Three boxes came in with over 30 books. Among them are:
Ten golden rules for SOA Design – Database Systems 2006 – part 2
The most provoking presentation I sat in on during the Database Systems 2006 conference was probably the one by Rick van der Lans, on 10 golden rules for SOA …
Oracle introduces free database development tool
Oracle recently released its first production version of a graphical database development tool called “SQL Developer†(version 1.0) – formerly project Raptor. If you have ever worked with Oracle …
Oracle Forms for games?!
Tired of writing only administrative applications? Try a Forms game.
Database Systems 2006 – Conference on Service Oriented Architectures
March 28, 2006
Data Warehousing & BI, Database, Databases, IT, Java, Oracle, Oracle WebLogic Server, SOA
No Comments
Today I attended – and presented at – the Database Systems 2006 conference – an annual Dutch conference on Database Architecture and Technology, Enterprise Integration and Service Oriented Architectures …
ODTUG 2006 Kaleidoscope (Washington) – We are on our way… – AMIS does 9 presentations!
March 28, 2006
AMIS, Data Warehousing & BI, Database, IT, Java, Oracle, Oracle WebLogic Server, PL/SQL
No Comments
We at AMIS have a fairly long tradition when it comes to having developers attend the annual ODTUG (Oracle Development Tools User Group) conference. My first conference – while …
Calling a Servlet in Java Code through a Post Request – or: how Service Oriented we Are
For one of our current Java development efforts – a Web application based on JSP, Struts, Oracle ADF technologies – we had to develop functionality to transforms HTML documents …
Profiling PL/SQL met het package dbms_profiler (dutch)
Oracle biedt sinds Oracle 8i via het package DBMS_PROFILER ondersteuning voor profiling. In dit artikel, dat ook in Optimise zal verschijnen, zal dit package onder de loep genomen worden …
Introduction to ASP.NET, ADO.NET – dead ringer for Oracle ADF?
After quite a few encounters with .NET in recent years, primarily up against Java/J2EE technology – and some with VB before the release of .NET in 2002 – yesterday …
Converting Word documents to XSL-FO (and onwards to PDF)
In the not too distant past, I have had to implement solutions for generating PDF documents, based on dynamic data and a document template to be defined by the …
Java 5 Annotations – Creating your own Annotation Type
One of the new features in Java 5 that clearly stands out is called: Annotations (JSR-175). Through Annotations, we can add metadata to our Java sources, not just as …
What a week – sessions on Advanced Java, SOA, BPEL and the AMIS Crossroads project
Some weeks are relatively quiet, some are more hectic. This past week leans towards the latter catagory. Apart from the normal every-day routine, there was our Knowledge Center session …
JDeveloper and Subversion
I am happy to see that a subversion extension is available for JDeveloper (10.1.3). Although it is still an early access version, it seems to work properly. Currently it …
More Jonathan Lewis
A little while ago, Jonathan Lewis presented a three day seminar in The Netherlands. You may have read other blogs on this site about this seminar. AMIS had sent …
Table must have one row minimum and 1 row maximum. (singularity check)
Imagine that you have to implement a table which must contain one row minimum and may not have more than one rows. So, on insert of a row you …
Integrate webforms application with InterConnect and BPEL
In the last months we have been busy building and extending a webforms application (10g rel 2) to integrate with Oracle InterConnect. The webforms application is a home-build application …
Design Patterns in PL/SQL – Interface Injection for even looser coupling
In a previous article, I discussed Dependency Injection (aka Inversion of Control and the Hollywood principle) and more specifically an implementation of Dependency Injection in PL/SQL. In that we …
Design Patterns in PL/SQL – The Template Pattern
These days I am working on a series of articles discussing Design Patterns and their implementation in PL/SQL. In previous articles, I have discussed Aspect Oriented Programming and Dependency …
A day with Jonathan Lewis
A little while ago, Jonathan Lewis presented a three day seminar in The Netherlands. You may have read other blogs on this site about this seminar. AMIS had sent …
Some musings on JCA (Java Connector Architecture)
J2EE contains a plethora of API definitions. From the Servlet API to the EJB API, from JMX to JMS. One of the APIs that I have had very little …
Dependency Injection in PL/SQL – Remove Hard Coded Dependencies from your code
Frequently our code has dependencies. Some are intrinsic dependencies, like the packages we need to invoke and the type definitions we rely on. Other dependencies are more like configuration …
Need an Oracle client? Do it instant!
Historically, when you wanted to connect to an Oracle database you could not get around downloading and installing a bulky Oracle client. Since 2 years already an alternative exists: …
Aspect Oriented Programming (AOP) in PL/SQL – Is it hot? Is it cool? Or utterly useless?
One of the hottest topics in Java programming right now is probably Aspect Oriented Programming. Made popular by frameworks such as AspectJ and Spring, AOP refers to a new …
Ever wondered how Soundex works?
It is not well-known how the Oracle built-in Soundex exactly works. This article explains the basics and also describes the Dutch variation of this algorithm.
Debugging PL/SQL met DBMS_DEBUG (dutch)
Oracle biedt sinds Oracle 8i via het package DBMS_DEBUG ondersteuning voor debugging. In dit artikel, dat ook in Optimise zal verschijnen, zal dit package onder de loep genomen worden …
Selenium IDE – plugin for FireFox – easy black box web application testing
March 1, 2006
Java, Oracle, Oracle WebLogic Server, Software Engineering, Tools, Web HTML5 CSS3
9 Comments
In a previous article, Introduction to Blackbox testing of Web Applications using Selenium I have introduced Selenium, a framework for Web Application testing – any HTML/JavaScript Web Application, regardless …
Oracle Application Express Roadmap
At the end of january, Oracle announced that Oracle HTML DB was renamed to Oracle Application Express. At the same time they published a roadmap for the next year. …
Jonathan Lewis Seminar – Optimising Oracle Performance by Design-
Last week I visited the Oaktable Seminar “Performance by Design” by Jonathan Lewis, held in Utrecht. I would like to share some of the topics of the seminar which …
Optimising Oracle (Performance by Design) – Day 1
From 21 February till 23 February the OakTable seminar Optimising Oracle (Performance by Design) by Jonathan Lewis was held. The seminar had been organised by Lex de Haan, who …
Introduction to Blackbox testing of Web Applications using Selenium
February 24, 2006
IT, Java, Oracle, Oracle WebLogic Server, Software Engineering, Tools, Web HTML5 CSS3, Web/Java
1 Comment
After my visit tot JavaPolis, in December 2005, I wrote a brief article on Selenium, a tool for testing Web Applications. For one of our internal Knowledge Center Sessions …
How we provide part of the Birkbeck University of London Curriculum – Component-Based Software Development on EJB 3.0
While I was reviewing today’s statistics of our weblog, I noticed a referrer in our top 10 that had guided 24 readers to one of our articles. I …
Getting started with the EJB 3.0 Query Language (EJBQL 3.0) using GlassFish reference implementation
This article is the sequel to EJB 3.0 Persistence – Introducing EJBQL 3.0, an introduction to EJB QL from an historical, strategic and functional perspective. In this post I …