IT-eye

After completing a migration of a GIS Application to 11g database i was wondering how difficult it could be to integrate Oracle Maps on a APEX page.

I have installed the following components:

• Oracle 11g Database
• OC4J Container 10.1.3.5.0
• Oracle Fusion Middleware MapViewer 11.1.1.2
• Oracle Spatial Demo Data Set

upgraded the SQL Developer to version 2.1 and installed the GeoRaptor plugin to visualize oracle spatial data

Step 1: “Validate Demo Data and working of GeoRaptor”
Step 2: “Validate Working of MapViewer jsp client”
Step 3: “Validate Working of MapViewer JavaScript client”
Step 4: “Include the JavaScript client in APEX page”
Read the rest of this entry »

Today i was using utl_http package on my 11g db and I encountered the following error:

ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1577
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at line 1

His is the result of the improved security in 11g. When you want to create a connection to a remote server with one of the util packages: TCP,HTTP,SMTP besides the privileges on the package you need to configure the connection in a Access Control List (ACL). In a ACL you can configure in detail the allowed connections by entering the following parameters:

• Server name or IP
• Port number range
• Database user/role
• Start date
• End date

The package DBMS_NETWORK_ACL_ADMIN enables you to create and configure ACL’s.

The ACL is a nice security feature but when migrating applications to 11g it’s something you will encounter.

More information:

• dbms_network_acl_admin documentation
• Article writen by Arup Nanda

The configuration of the fault management Framework for a SCA component has been made more flexible than it was in 10g. We can configure fault policies not only on composite level but also on component level. This enables us to configure retry policies not only on an error type and filter but also on specific components. To do this you just need two files:

• fault-policies.xml, fault-policies.xsd
• fault-bindings.xml, fault-bindings.xsd

You have to enable the fault policy by adding the files to your sca component, or you can add a reference in the sca component to hem, for example when they are placed in the mds.

fault-bindings.xml
Examples of fault-bindings.xml files can be found in oracle’s documentations:

• Fault policy on composite level, the chapter is called fault-buildings.xml but they are talking about fault-bindings.xml don’t let this confuse you
• Fault policy on component level

fault-policies.xml
An detailed fault-policies.xml file can be found here.

Mediator
The Fault Management Framework is only applicable for mediators that processes their rules parallel, see documentation Fault Policies Mediator. If an error is matched in the fault policy an possible predefined fault action in the mediator will be ignored. Be aware of this when you are defining your fault policies and error handling.

Example
I have made a simple sca component to show the working of the framework. This sca component has two components {BPEL and Mediator} which are exposed as services to the outside world.
Read the rest of this entry »

Today i took a look at the test framework withing the 11g suite. I encountered a strange problem in the test framework of the SOA Suite but before i go into details i will explain the case.

I have made the following sca component that returns a greeting. The input is quite simple a name and a greeting type (‘Hello’ or ‘Bye’). The message is routed depending on the greeting type to a BPEL which response the greeting with a return greeting.
Read the rest of this entry »

View IT-eye’s contribution to SOA Magazine, where Mike van Alst (IT-eye) & Dave Berry (Oracle) talk about preventing failures by implementing good governance.

As many of you may know, I’m a big fan of collaboration. I think we all have enough challenges building solutions for our customers, that we all benefit from any kind of collaboration. One such collaboration is the WAAI project. The WAAI acronym is formed by using the first letter of each participating company, being: Whitehorses, Amis, Approach Alliance and – of course – IT-eye.

The way we work is quite simple: every quarter we decide upon what questions we want to have answered. As you can imagine, SOA Suite 11g is quite prominent there. Each and every question has to be answered by delivering a workshop, white paper or presentation. These are collected and presented to an audience consisting of people from the participants. That way we not only build the knowledge, but spread it within our companies as well. And, all of us can use that material to train others, both inside and outside of the companies.

Usually the results are qualitatively really good. Some are extremely good. Such a one has just been posted on OTN, which is a nice feat anyway. You can find the article Jumpstart for OSB development here. We look forward to share a lot more results in the future.

Today I had some troubles to debug a Java class in Eclipse.
The debugger didn’t stop at my breakpoints.
To solve this issue I have editted my debug configuration in eclipse.

Put the following in your vm arguments to increase the initial and max heap size.

-Xms512M -Xmx512M

Other ideas are Welcome!!

Probably, most people have by now at least heard of BPMN, the Business Process Modeling Notation standard from OMG that is supposed to be the process-modeling standard. I’ve been following news for the last 2 years or so but, admittedly, never really dug deep until I started using it at a client. Even then, it was mostly sales-pitch level and learning a bit of the notation from cheat sheets like the BPMN poster. The past few months, however, I have learned more about the standard – what its possibilities and semantics are and how it can be used. I’ve had training from both a more technical perspective (in an Oracle partner training) as well as from a purely modeling-oriented training (by one of the contributors to the BPMN 2.0 specification, Bruce Silver). And I must say, digging deeper has made me quite enthusiastic about the standard!

Read the rest of this entry »

My last blog about common information models (CIMs) gave a general idea about common information models. By now you might wonder what is purpose of using common information models is, so I will try to address this by explaining the strategic importance of standardization in digital information exchange, either business to business (B2B) or application to application (A2A). Read the rest of this entry »

Currently I’m working on my master of science thesis about designing an approach or recipe on how to use IEC CIM based messages in a top-down approach, starting with a business process chain and working my way down to information services and IT systems. As part of this thesis I recently visited the CIM User group Conference in Genval, Belgium, near Brussels. During this bi-anual conference, I learned a lot about how utility organizations in both Europe and North-America are performing digital information exchange using common information models. Read the rest of this entry »