Weblog for the AMIS Technology corner
Andre Crone
This user hasn't shared any biographical information
Posts by Andre Crone
The influence of the experience economy on IT architecture
23/7/2008 - 9:31 am
Posted in IT Architecture, Software Engineering | 3 comments
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 have followed so far.
IntroductionCompanies that [...]
How to call a WS-Security secured web service from Oracle BPEL
1/2/2007 - 8:33 pm
Posted in General, SOA & Oracle Fusion Middleware, XML | 14 comments
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 of logging facilities. Call to services [...]
How to build an Oracle Forms application on BPEL/WF
19/1/2007 - 4:46 pm
Posted in Devel. + PL/SQL tools, General, J(2)EE/Java, Oracle, SOA & Oracle Fusion Middleware | No comments
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 my colleague Peter Ebell, ways how [...]
How to send large attachments?
26/6/2006 - 7:41 pm
Posted in General | 5 comments
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 use for this purpose.
My best [...]
IN or EXIST or doesn’t it matter
24/5/2006 - 7:20 pm
Posted in Databases, General, Oracle, Oracle Development Tools | 7 comments
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 took 40% of the logical [...]
Google releases AJAX toolkit
22/5/2006 - 7:14 pm
Posted in General | 2 comments
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 error prone. With GWT, you can [...]
Wrong use of constant packages
22/5/2006 - 5:05 pm
Posted in Database, General, Oracle, Oracle Development Tools | 18 comments
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 why we had these problems [...]
Generate a native Excel file with SQLX
20/1/2006 - 12:00 pm
Posted in Database, General, Oracle, XML | 8 comments
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 in stead of a CSV [...]
How to use weak ref cursors and bulk collects into a table of objects to clean up data
30/12/2005 - 11:26 am
Posted in Database, General, Oracle, Software Development | No comments
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 simple solution would like:
[...]
Oracle Lite Part 2, how to get started (continued)
30/11/2005 - 2:12 pm
Posted in Database, Devel. + PL/SQL tools, General, Oracle | 6 comments
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 a nice product with a lot [...]
