Posts tagged soa suite 11g
Some time ago I decided to take a look at virtualbox. After using some downloadable appliances I decided to install one for myself from scratch to have it configured just the way I want. This blog describes what I did to achieve this. I am still quit pleased with virtualbox. Somebody pointed out to me that the CPU Utilization is quit high though. Some browsing on the internet and looking in the manual gave me the solution. I will talk about this later.
Installing virtualbox is very simple. Just download the installer and run it. Follow the wizard and do aÂ next/next/finish installation. If you have a dual core PC or laptop (who hasn’t nowadays) please have a look at the end of this blog…. You might have to do some additional settings.
Installing Oracle Enterprise Linux is also very simple. First I created an empty virtual machine with a single disk of at least 15 Gb. I selected two processors and switched on all virtualization acceleration as my hardware supports that. I both tried the PIIX3 and ICH9 chipset. I could install OEL with both only with PIIX3 OEL actually booted. In total these settings resulted in a 10-20% CPU utilization when my guest is idle. Not great but More >
In an earlier blog my colleague Peter Ebell (link) explained how you can create an extension ofÂ collaxa.cube.engine.ext.BPELXExecLet to do your coding in a regular Java environment so you have code completion and validation. In 11g no improvements have been implemented and the Java embedded activity is still a pretty dumb text editor. So the same approach is still valid. But there are some differences between the 1o en 11 version.
The class you need to extend has been moved to a different package: com.collaxa.cube.engine.ext.bpel.v1.nodes.BPELXExecLet. You need at least to include the SOA Workflow library in your project. If you want it to run you need additional packages.
Most of the methods of the 10 version still exist. Only the method getLocator is gone. You now need to get an instance of the locator bean through a factory.
Oracle 11g SOA Suite â€“ Service-enable a Query Using the Database Adapterâ€™s Execute Pure SQL Option2
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.
VMware player has been my number one virtualization solution for quite some time. Recently I became curious about Oracleâ€™s virtualBox (formally Sunâ€™s virtualization solution). Could this be a nice alternative? Especially because Oracle recently released a pre-built virtualBox virtual machine (vm) with the SOA and BPM Suite 11g running on Oracleâ€™s Enterprise Linux 5.
In this post I’ll summarize what I had to do to get this vm running. I wanted to see if I was easily able to reach the next without having to read endless manuals:
- Getting the vm to run the first time
- Network & Shares (Connectivity)
- Working with snapshots
Ever wondered what to find in which directoy, in for example an Oracle SOA Suite 11g installation? (patchset 2)
Well, hereÂ´s the general rule:
- TheÂ toplevel layerÂ –> Called the Middleware home; toplevel of all components, usually something like /app/oracle/weblogic/Middleware (or make your own choice)
- The WebLogic Server layer–> Location of typical WebLogic binaries, scripts, configurations, NodeManager. Would be Middleware home/wlserver_10.3
- The Oracle management layer –> Oracle generalÂ components like Enterprise manager, ADF runtime libaries, usually called oracle_common
- The Oracle product layer –> Oracle product specific components like BPEL, Mediator, OSB. Usually called Oracle_<name_of_product>
The WebLogic Domain specific files end up in a directory called user_projects/domains, normaly one level beyond the Middleware home. Feel free to change these locations in more reasonable ones,like:
- one filesystem for your domain configuration
- one filesystem for your server and applicationlogfiles
- one filesystem for you software binaries
JavaOne started this morning with the first many dozens sessions and the Java Pavilion & Exhibition hall. The official kick off so to speak took place tonight, with Thomas Kurian’s keynote, in which he unfolded Oracle’s plans for Java. He wants to make it abundantly clear how important Java is to Oracle, how important the unity of the community around Java is and how urgent it is for him (almost on a personal level) to see the Java platform and community regain momentum, after a period of FUD and near stand-still. His keynote contained a number of very concrete statements and plans that Oracle intends to execute. He did not necessarily say this out loud – but between the lines I clearly read that Sun had fantastic ideas but not necessarily the capacity (and at some point obviously the budget) to deliver on them and that Oracle intends to bring its ability to execute and deliver (see for example the acquisition and subsequent integration of BEA and others) to the table and get Java moving once more.
His announcements included:
- Java SE 7 will be available in the Summer of 2011 -provided JCP joins in and approves.
- Java SE 8 will follow in 12-18 months after SE 7 – provided JCP….
- the More >