AMIS, Data Driven Blog – Oracle & Microsoft Azure
Getting value from IoT, Integration and Data Analytics
This pattern was ‘invented’ by our SOA-architects team integrating the Oracle SOA Suite and the Oracle e-Business Suite in an existing IT-landscape. The trickle-feed integration pattern can be used when distributed systems integrate with one another by means of asynchronous messaging. The messages are versioned to each other in such […]
0 
0 Introduction Is it possible to package java classes which are invoked through WSIF along with the BPEL Suitcase generated by bpelc? I’ve noticed that when generating and deploying the suitcase using JDeveloper (10.1.3.x) – the class files are compiled to the output directory and packaged in the suitcase, but when […]
0 0 The long expected patch set to upgrade the SOA Suite 10.1.3.1 to 10.1.3.3 is available on metalink (patchnr. 6148874).
0 0 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 […]
0 0 The last months I’ve been a frequent visitor of the SOA Suite forum on OTN. The reason for this is that I’ve been busy getting acquainted with new SOA Suite. And the forum was helpful in resolving some of the problems I’ve encountered during the learning track of this new […]
0 0 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 […]
0 0 Doemscenario voor de toekomst van Java? In five years, Java EE will be the CORBA of the 21st Century. People will look at it and say, ‘It had its time but nobody uses it any more because it was too complicated.’ (Richard Monson-Haefel Senior Analyst, Burton Group)
0 0 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 could route incoming messages based on the correlation ID. With help from Dave Berry on the OTN forum, he pointed me […]
0 0 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 […]
0 0 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 […]
0 0 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 […]
0 0 Today I attended a very nice workshop at Oracle Netherlands where some Oracle Partners could get acquainted with the beta 10.1.3 release of the Oracle Enterprise Service Bus (ESB).
0 0 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 […]
0 0 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 for registration and calculation of costs and benefits that are related to expliotation of building projects (in dutch: ‘grondexploitatie’) for the […]
0 0 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 can check if there’s already a row in the table by joining the table to itself, like the next statement select […]
0 0 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 for registration and calculation of costs and benefits that are related to expliotation of building projects (in dutch: ‘grondexploitatie’) for the […]
0 0 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 […]
0 0 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 […]
0 0 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 […]
0 0 Since last week the new SuSE Linux Professional version 9.3 is available for download. You can download it from a mirror in your vicinity and install it via FTP.
0 0 1. Intro
0 0 PL/SQL Tools vergelijkende warentest. Bij Amis gebruikten we jaren achtereen alleen maar TOAD, omdat er eigenlijk in het verleden geen ander goed alternatief was. Intussen lijken de zaken enigszins veranderd en bij sommige klanten wordt PL/SQL Developer gebruikt. Verder is de licentie van PL/SQL Developer goedkoper dan die van TOAD. […]
0 0 This post discusses how you can integrate WebUtil with Designer 10g to generate webforms using the webutil API’s with less post generation actions. Near 100% generation of webforms using Designer 10g is archievable. Specially if you have a good set of object libraries and templates. Integrating the WebUtil object library […]
0 0 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 […]
0 0 0 0 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 […]
0 0 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 […]
0 0 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 […]
0 0 XSL-T transformation for Oracle developers. When transforming XML with XSL-T stylesheets you should consider the performance of your transformation. Analog to tuning the Oracle database, XSL-T transformations can and should also be tuned to boost up the performance in both speed and memory.
0 0 Tijdens deze KC avond presenteert Lucas over Query Structuur. De stof komt uit 7Up en omvat ondermeer In-Line Views, Scalar Subqueries, Analytical Functions, Joins, nieuwe Connect By functies, rollup, cube en grouping sets. Ook zal er gelegenheid zijn om een en ander achter de PC uit te proberen middels een […]
0 0 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.
0 0 
