Posts tagged soa
In the past few weeks, I have encountered a similar discussion in various organisations. Each organisation uses either SOA Suite (11g) or Oracle Service Bus (11g) at the core of their SOA infrastructure – either for integration purposes, for workflow and process orchestration or for both. In each organisation, the role of one or more databases is crucial and interaction between the SOA environment and the database is one of the most common and therefore important functions in their enterprise IT environment.
Given the importance, it is only logical that the way(s) chosen for linking the SOA component to the database is carefully selected – and evaluated every now and again. Technology may have progressed, experience may have taught us a lesson or two, the knowledge and skills may have evolved.
Interestingly enough, the number of ways for SOA Suite and OSB to communicate with the database is quite high. This article includes an illustration that shows over 20 different interaction channels that we can choose from with a fairly wild variation of attributes, required skills, productivity and performance characteristics.
Among the choices we face is the question of the communication More >
For a couple of months I have been discovering the Android platform. As an original Oracle developer I was wondering how an Android app can be connected to an Oracle database. For this purpose I developed an Android app that stores speed traps that users may hit while driving, into an Oracle database. The app also retrieves these speed traps from the database and draws them onto a Google map:
Oracle 11g SOA Suite â€“ Service-enable a Query Using the Database Adapterâ€™s Execute Pure SQL Option3
The Database Adapter is a powerful tool to expose data and PL/SQL code in your service applications. If you want to quickly service-enable a custom-made query, you definitely may want to explore the â€œExecute Pure SQLâ€ option of the Database Adapter.
This tutorial will show how to service-enable a query step by step using the Database Adapter with Pure SQL.Business Case: Retrieving Department Information
Assume you have written a query that retrieves information for departments in your database and you want to service-enable this query. The query optionally accepts two arguments: a department ID and a department name. Selection on a part of the department name is possible and selection is case-insensitive. If the arguments are both empty, all departments will be returned by the query.
The query we are talking about here does not only contain columns that are mapped 1-on-1 on database columns but also a concatenation expression and calculated columns using analytical functions. Therefore the â€œExecute Pure SQLâ€ option of the Database Adapter is a logical choice to expose this custom-made query.
After installing Oracle SOA Suite 126.96.36.199 en upgrade afterwards to 188.8.131.52 puts the soa-infra application on warning. You can see this in the WebLogic console under Deployments.
Why is this?
The soa-infra does its work normal, dispite of this state.
If you install upto patchset 2, some MDB’s are added to the soa-infra application:
BamActionMDB CubeActionMDB PeopleQueryMDB Solution is to create JMS Connection factories and topics Look atÂ Domain Structure >JMS Modules >SOAJMSModule. Inhere you should create the following objects
JMS connectionfactories en Topics: jms/bpm/PeopleQueryConnectionFactory jms/bpm/CubeCommandXAConnectionFactory jms/bpm/PeopleQueryConnectionFactory
After restarting WebLogic you soa-infra is ok.
Note: When installing the full BPM suite these objects will be created automatically.
Yesterday evening we had our annual Oracle Open World review at our office in Nieuwegein. Around eighty people attended and all were very involved with the session. Five AMIS employees were at Oracle Open World, and each one covered one area of interest.
Before dinner Lucas gave an overview of the trends and topics that were covered at Oracle Open World. Just to convey the sheer size of OOW, Peter illustrated this by facts (number of people attending, number of lunches served, etc) as well as by photos. I’m still very impressed that they covered a four lane street (Howard street) by a tent, just to serve lunch… amazing. Marco and myself gave an overview of what AMIS was doing at OOW, as well as the Oracle ACE Directors briefing right before OOW started.
There were a number of goodies that we took from Oracle Open World to give away this evening. We decided to do it a little different this year, we organized a BuzzWord Bingo. Each of the attendees was given a bingo sheet with some of the buzzwords that would be covered during our presentations. Before we went for dinner six people had bingo and got their goodies to take home.
This time we had a Mexican Style dinner, very lovely. More >
Oracle Open World 2010 presentation: Forms2Future: the ongoing journey into the future for Oracle based organizations0
Many organizations around the world have adopted Oracle technology for developing custom applications. Over the past two decades, they may have used PL/SQL, Reports, Forms, Designer, Portal or the Web PL/SQL Toolkit. Many of these organizations have come to face new challenges: more agility or functionality, new user groups or channels or more efficient maintenance. Or they fear getting stuck in the past, running out of support or qualified and motivated resources. What is the right way to approach the future? What mix of tools, how and when to adopt which new technology, how to build a business case? This session recounts various more and less successful warstories of organizations that embarked on a journey into the future.
Peter and I today did our session together about the road to the future for organization that heavily us Oracle software. It was a good session with a lot of interesting questions. It is quite clear to me how much confusion there is, how many organizations are struggling with defining their future plans. How many people hear mixed messages from for example Oracle sales people. And how they simply would like to get a clear, untainted and unbiased picture of More >