Weblog for the AMIS Technology corner
Posts tagged Oracle
Automatic testing Oracle Service Bus using Hudson, maven and SoapUI
Feb 23rd
A lot of current projects are implementing some sort of service based architecture. Testing in this architecture becomes more complex. When implementing an OSB project with Scrum you test-automation is imperative. Scrum will require more frequent testing of your system. This is only feasible (in time and money) when you automate as much as possible.
Using soapUI you are able to create visually SOAP tests on your OSB implementation and running them against the defined infrastructure (develop, test, acceptance). SoapUI enables with easy tools to implements verification and validation of the responses of your OSB implementation. When running the test you are also able to set limits in SLA response times on all the calls. This way you are able to monitor depreciation of performance in older parts of your OSB implementation when adding new services.
You can record and edit your SOAP test easy with the soapUI interface and edit it later. When you maven-enable your project it is quite easy running your tests when you implement the “maven-soapui-plugin” (see my other posting http://technology.amis.nl/blog/3061/automated-soap-testing-with-maven). In the meantime version 3.0 of this plugin is released.
When implementing this with Hudson you do not have to convert the results.xml into a Surefire report. Hudson will manage this for you. Hudson will also enable you with an historical overview of all your test results.
AMIS Query – Verslag van Oracle Open World 2009 – dinsdag 27 oktober (uitnodiging)
Oct 23rd
Vorige week was in San Francisco het hoogtepunt van het Oracle jaar: Oracle Open World 2009, de grootste IT conferentie ter wereld. Tijdens deze conferentie ontvouwde Oracle haar strategie en visie voor de komende periode, lieten product managers de nabije toekomst zien van bestaande en nieuwe producten, deelden honderden specialisten hun ervaringen en toonden leveranciers en Oracle engineers op de demo-grounds de nieuwste snufjes. Ca. 40.000 bezoekers waren aanwezig in het hart van San Francisco om zich vijf dagen lang te laten overvoeren met Oracle weetjes.
Als je er bij was vind je het misschien leuk nog eens herinneringen op te halen en ervaringen te bespreken. Als je er niet bij was ben je misschien geinteresseerd in de belangrijkste aankondigingen, de mooiste demo’s en wetenswaardigste feiten. Dat kan, aanstaande dinsdag op de AMIS Query – Verslag van Oracle Open World 2009. In deze (gratis) sessie doet de AMIS-delegatie naar OOW (Marco Gralike, Peter Ebell en Lucas Jellema) verslag van de conferentie. Je bent van harte welkom om daarbij aanwezig te zijn. Vanaf 17.30 serveren wij een diner, om 18.30 start de sessie die duurt tot pakweg 21.00 uur. Om je aan te melden, ga naar: registreren AMIS Query OOW 2009.
In deze sessie komen onder andere de volgende onderwerpen aan bod:
OOW 2009: The killer feature of Oracle Database 11gR2 – Edition Based Redefinition (or database object versioning)
Oct 13th
Today I presented on what is possibly the hottest story on the Oracle Database 11gR2 release: Edition Based Redefinition (EBR). EBR allows us to add a whole new dimension to the database – the Edition (that complements the existing dimensions of schema and object type). Every database object (well, almost every database object – not tables!) can have different implementations/incarnations/versions in various editions. The object versions are all in the same schema – they only differ in the Edition they are created in.
The Edition Based Redefinition has us create Editions in the database – cross database object spaces where new versions of existing database objects can be created – and others can just be inherited from previous editions. We can construct an Edition in isolation – no one is impacted by us creating new objects and versions of objects; objects can be invalid in that edition and no one will know anything about it. Only once the edition is complete, valid and tested can we make it available to new user sessions to work against. Using a simple alter session set edition statement, sessions can specify which edition they want to run against. That is: after the user has been granted access to that particular edition.
There are some mechanics that you should know about of course.
The AMIS team reports from Oracle Open World – big and small announcements, guidance and tips
Oct 4th
Last night, the AMIS crew that visited the Oracle Open World conference reported their findings in a 3.5 hour session. In segments on SOA & BPM, Middleware, Database, Oracle Applications (AIA) and Development technology, we presented the highlights from close to 1900 sessions – no small feat. And utterly incomplete of course. However, all in all, for people who did not attend the "red party" the evening gave a very useful overview of what Oracle is doing and where it is heading.
Oracle Open World 2008 – the show is about to begin – what are this year’s stars?
Sep 21st
It’s a very early Sunday morning in San Francisco. Over the past few days, thousands upon thousands of people arrived into the city – all connected to Oracle in some way – many of whom who were not in the least connected to Oracle only a short time ago (BEA comes to mind, among others). Today is the start of Oracle Open World 2008. With 45.000 or more attendees one of the biggest company parties in the world. A sea of red, flooding the city center.
Ever since I got on the plane with dozens of like minded souls and increasingly since I have arrived here in downtown Frisco, the big question was: what will be the major announcement of the show? Where is the spotlight going to shine? Not much gossip seems to have come out of Redwood Shores. And there are no obvious candidates really. 11gR2 is still on the drawing board it seems, the beta program not yet on its way. BEA was acquired some months ago and all plans with regard to BEA were announced in the beginnen of July. There could be another rabbit pulled out of a high hat – like Oracle Enterprise Linux in 2006 and Oracle VM in 2008.
Read the rest of this entry »
Oracle & JDBC – Passing a ‘table of custom object type’ to a stored procedure – implementing efficient single round trip data exchange (part two of an ADF application on a PL/SQL API)
Jul 16th
One very efficient way of passing data from the Java application to the database is through the use of custom Oracle Types. Even when we want to send a heterogeneous data set, for example a data set with master and details records, custom type based objects can provide a powerful exchange of data. However, also one that is not extremely straightforward to get started with. In this article an example of how to send a TABLE OF MY_TYPE objects as an input parameter to a stored PL/SQL procedure. Read the rest of this entry »
Juggling met SQL Types in SQL and PL/SQL – fading borders between Collection and Table
Jul 14th
While preparing for a whole different topic, I had to create a few demonstrations of using custom SQL Types and Collections in both SQL and PL/SQL. While nothing spectacular – and for anyone who attended our 7Up class pretty familiar stuff – I thought an example of these small demos of how to create and use Type and Table of Type with for example the TABLE operator (to cast the Table of Type Collection into a relationally accessible construct) and the Merge operation as well as the Collect aggregator for producing quickly a Collection from the result of a simple SQL Query, might be useful. If for no one else, than for me – as I always tend to forget the exact syntax.
Note: all scripts are in a file you can download at the end of this article. Read the rest of this entry »
Latest Oracle Pricing List – new suites and options give interesting insights
Jul 8th
Oracle recently published the most recent version of their global price list. I am not sure how it translates to local transactions (for example if and how the currency exchange rates are applied). And I cannot say I understand all the options listed. But some of the entries are interesting nevertheless. See http://www.oracle.com/corporate/pricing/technology-price-list.pdf for the detailed list. Read the rest of this entry »
