How to trace a java application through a connection pool using DBMS_MONITOR

Much has been written on how to trace database sessions through a java application in all sort of different techniques. Since Oracle 10g a new technique is added to the tracing stack: DBMS_MONITOR. This blog briefly describes with code examples how you could use DBMS_MONITOR to trace database sessions via […]

Funny ESB?

Harm Verschuren 3

Hi all, I’ve used my ESB system – installed on SuSE9, connected to a 10.2 E.E. on the same machine – for a few months now, so I thought it would be interesting to take a look at what’s going on in my database schema created by my esb system […]

Guaranteed delivery not obvious for ESB.

Harm Verschuren 3

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 process I ran into some issues which for me raised the question “Are messages processed by the Oracle ESB delivered to […]

Automatic continuous compilation of webforms on linux/unix

Automatic continuous compilation of webforms on linux without X-terminal In the webforms world you it is not uncommon to compile a webforms application on a linux/unix application server, after you’ve build a forms module on your Window development environment. Modules compiled on Windows typically will not run on another operating […]

Pivot using BPEL

Harm Verschuren

Purpose During the past weeks my collegues at Amis (Anton and Lucas) are pivotting using SQL and PL/SQL, so why not also do some pivotting in BPEL, just for the fun of it. The pivotting problem is not so much part of a known business process but an exercise to […]

KC SDPL – InterConnect Pagoni

Harm Verschuren

Interessante sessie over hoe Interconnect gebruikt wordt op een project voor een klant van Amis. Hier staat de presentatie en de source files De conclusies: iStudio is geen multi-user tool, gezien de foutmeldingen etc. Vaak – na elke handeling – het project reloaden lijkt het motto. blijkbaar is er niet […]

How to amaze yourself with your own old tools

Harm Verschuren 5

About a year ago I designed and developed a “JDAPI-toolbox” while migrating a medium sized (ca. 600 modules) Oracle Forms 6i application to webforms 10g for a customer in The Netherlands. I started the migration project using the Oracle Forms Migration Assistant. I found out that the tool only covered […]

KC SDPL – Enterprise Integration

Harm Verschuren

Gisteravond werd in een druk bezochte KC Server Development bijeenkomst het onderwerp Applicatie Integratie behandeld. Tijdens de avond werd uitgelegd hoe je applicaties kan integreren door gebruik te maken van de middelen die Oracle InterConnect en BPEL bieden. Naast een inhoudelijke presentatie en demo’s van de producten werden beide producten […]

Migrating Oracle Reports – JDAPI style

Presenting at ODTUG can lead to unexpected things to happen. For instance people actually reading my paper and seeking advice with their migration issues. Whaw! In my paper – titled Practical JDAPI – I discussed how I the Java Development API (JDAPI) helped in migrating a forms 6i client-server application […]

AskTom Live with Tom Kyte! – day three

Harm Verschuren

This is a brief summary of the third day of the very interesting seminar AskTom Live with Tom Kyte! . During the morning flashback features in 10g were presented as the Timothy Leary release database. Flashing back queries, tables or row history is the ability to see (select) data that […]

Comment from Steven Feuerstein

Harm Verschuren 1

In the Oracle Magazine of januari/februari 2005 Steven Feuerstein wrote an excellent article about Refactoring for PL/SQL Developers. In this article he uses technologies known in the Java community: Refactoring of code, and reapplies these in PL/SQL. Both languages are programming languages so it is perfectly OK to interchange the […]

JDAPI misteries

Harm Verschuren 5

After working some weeks with JDAPI strange features are emerging. JDAPI seems to be unable to save PLL modules! Trying this results in This module type does not currently support saving to filesystem exception. Compiling PLL modules seems also sort of “not supported” by the jdapi. An exception This module […]

Webforms Help page on OTN

Harm Verschuren

Here is an excellent web page about Oracle webforms. It covers the Forms Server, lots of general stuff, how to implement java (PJC and beans) in your webform and an excelent how-to for using the JDAPI (with a class diagram of the JDAPI package). The nice thing about this page […]

KC SDPL planning

Harm Verschuren 1

In the next 6 to 12 months Knowledge Center Server Development & Programming Languages intends to deal with the themes listed below. The aim is to present at least a large part of those themes in various attractive ways such as presentations, work shops and discussions.