AMIS is puting more and more emphasis on IT architecture. That is one of the reasons why I am doing my Masters in IT architecture and why AMIS is starting a knowledge center about IT architecture. The following paper is written for one of the masterclasses (Applying Architecture) that I […]
Andre Crone
How to call a WS-Security secured web service from Oracle BPEL
Introduction I have been investigating Oracle’s Web Service Manager recently. WSM is shipped with the new SOA Suite. The WSM is a service gateway. Existing services can be placed behind the gateway. Security and authentication of the services will be done by the service gateway. WSM also provides a lot […]
How to build an Oracle Forms application on BPEL/WF
Why Oracle Forms and BPEL? Old style Forms applications normally don’t hold much workflow functionality. Sure there is an order in which the forms should be used. The workflow of the application is in the mind and knowledge of the user. For my current project I am investigating, together with […]
How to send large attachments?
You all know the problem. You want to send that large file to someone, but how? Many email systems restrict the maximum attachment size. I have to send large attachments of several hundreds of megabytes to magazines all over the world quite frequently. There are some services that you could […]
IN or EXIST or doesn’t it matter
In my previous post about package constants I mentioned the application I am working on right now. They gave me the task to speed up the application since performance was getting worse and worse. I analyzed the statspack results together with a DBA and we found two queries that together […]
Google releases AJAX toolkit
Google has released their Google Web Toolkit (GWT). This toolkit can be used to develop AJAX applications in Java. Google describes the toolkit as follows: Google Web Toolkit (GWT) is a Java development framework that lets you escape the matrix of technologies that make writing AJAX applications so difficult and […]
Wrong use of constant packages
On my recent project we have a large package holding constants values. From a design point of view this is a very elegant solution because this way the constants are all defined in a centralized way. But the usage of this package lead to enormous performance issues. This post tells […]
Generate a native Excel file with SQLX
I wanted to generate an Excel file with data coming from an Oracle database. One of the best ways to do this is to generate an Microsoft Excel XML file. Starting from Office 2003 this XML format is supported. This way you are able to generate a native Excel file […]
How to use weak ref cursors and bulk collects into a table of objects to clean up data
The problem I was facing was simple. You have a table with data. The data in that table should be validated. Invalid rows should be deleted. For each deleted row an entry in a logfile should be created. The validation of the rows could be performed by expensive queries. The […]
Oracle Lite Part 2, how to get started (continued)
Yesterday I had a few mind boggling experiences with Oracle Lite. Together with our customer and my colleague Arjaan, I tried to install Oracle Lite. This is a very important project with 300 Oracle Lite snapshots in the future. Again I experienced what I wrote in my previous post. It’s […]
Sending CLOB data from Tibco (Java) to PL/SQL stored procedures
On my current assignment I am working on interfaces between Tibco and Oracle PL/SQL applications. Tibco is a middleware solution that implements a messaging based interface solution between different software systems. For the interfaces I have implemented a generic bridge between Tibco and Oracle. This PL/SQL implementation provides one stored […]
Steve Adams is in town – Oracle with a calculator
Today I attended the workshop that Steve Adams is giving in the Netherlands this week. We were with a group of four AMIS employees. The day started in a strange way. We all got a calculator. The reason why became clear during the day. Steve really showed us the internals […]
SQLX How to easily generate XML
I recently had the need to generate XML files based on data stored in relational tables. This was done via an XML DOM implementation on the project I am currently working on. This works fine, but it’s difficult to maintain. Modifications have to be made simple because the XSD’s are […]
Oracle Lite Part 1, how to get started
This post is the first one of a set that I will write about Oracle Lite. I have been working with Oracle Lite and I am impressed. Not by the level of documentation, but by the functionality of the package. Oracle Lite gives you the ability to create data snapshots […]
How to use the BPEL file adapter to load data into Oracle
This post shows a simple example about how to use Oracle’s BPEL server to load and parse a datafile. The data in the file is then inserted into a database table. We use the file adapter and the database adapter to accomplish this task. The nice thing of this BPEL […]
Oracle wants more database support in Eclipse
uk.builder.com reports that Oracle wants more database support in the Eclipse IDE. Oracle is going to develop database support for Eclipse. This software will be released and donated to the Eclipse project as open source. The tool will fully support the EJB 3.0 specification. Oracle is hoping that this EJB […]
Create logging data in the same table
Suppose you want to log every update on a table. You want the log records to be in the same original table. You cannot do this in a simple update trigger because this will have a the famous mutating table problem as a result. This post will describe a simple […]
W3C considering binary XML standard
Just read on news.com that the W3C consortium is considering a binary XML standard. This could really speed up a lot of transactions. The mayor drawback of course will be the fact that these messages are not human readable. I believe this could be a good thing to speed up […]
Book review: Business Process Execution Language
Title: Business Process Execution Language Author: Matjaz B. Juric, Benny Mathew, Poornachandra Sarang Published by: Packt Publishing ISBN: 1-904811018-3 Publication Date: 2004 Details: 270pages, $59.99; www.packtpub.com I recently read this nice book about the growing BPEL standard. The book gives a fairly good overview about what BPEL (Business Process Execution […]
PHP goes Pro
Just read on http://uk.builder.com/webdevelopment/scripting/0,39026636,39238117,00.htm that IBM is officially going to support PHP (Personal Home Page). The agreement between IBM and Zend also means that IBM will dedicate a part of it’s developers website to PHP. IBM will also implement new features for PHP. This agreement will be good for the […]
First impression of Oracle jDeveloper BPEL Beta2
The last few days a colleague and I have been looking into a beta release of Oracle’s BPEL designer for jDeveloper. This tool enables you to orchestrate single web services into complete enterprise workflows using the Business Process Execution Language. First we went through a tutorial that was written for […]
Tom Kyte part II. Using what we have learned
In this post we will tune a query from being hopelessly slow to fast. We will use “explain plan” to analyze the query plan. We will see how Oracle prevents you from doing stupid things. We will also see that preventing hard parses of queries will really speed up your […]
Tom Kyte about Things we "know"
Last week I attended the Tom Kyte seminar in Utrecht. This was a very impressive seminar held by a real Oracle database Guru. Tom says he still thinks of himself as being a developer and not a DBA. This is strange since most of this seminar was meant for DBA’s […]
W3C Recommendations Enhance SOAP Performance
Read this today on http://w3.org: The World Wide Web Consortium today released three W3C Recommendations to improve Web services performance by standardizing the transmission of large binary data. “Web services have just become faster and more usable,” said Yves Lafon (W3C). In short this means that binary data should be […]
Effective Oracle by Design
Title: Effective Oracle by Design – Design and Build High-Performance Oracle Applications Author: Thomas Kyte Published by: Oracle Press ISBN: 0-07-223065-7 Publication Date: 2003 Details: 664 pages, $59.99; www.OraclePressBooks.com I recently read this nice book written by Thomas Kyte. In this book Kyte addresses a lot of different design issues […]
GNU utilities for Win32
Windows is not shipped with a lot of tools for the developer. Simple tools like grep, sed, make are not provided. Today I installed UnxUtils. A set of GNU utilities for Win32. You could use Cygwin to do have the same utilities, but the nice thing about UnxUtils is that […]
Paris for the Designer
Today I looked into a pre release of Oracles Warehouse Builder 10gR2 (Paris). This comprehensive tool can be used to create complex data warehoused holding data from many different data sources like tables (in different databases), files etc. I was really pleased by the very good reverse engineering capabilities of […]
OpenVPN: How to safely access a database behind a firewall
OpenVPN is an open source VPN implementation which can be found on http://www.openvpn.net With OpenVPN, you can: tunnel any IP subnetwork or virtual ethernet adapter over a single UDP or TCP port, configure a scalable, load-balanced VPN server farm using one or more machines which can handle thousands of dynamic […]