KC Oracle Development Tools

Looking back at ODTUG Kaleidoscope 2010

In case you missed it (how is that possible?) last week was the annual ODTUG conference, Kaleidoscope in Washington DC. In this post I will share some of, what I consider, the highlights of this event.
I always enjoy going to this conference, it’s nice to see old friends and make some new ones. Read the rest of this entry »

Laatste “Plug” – Cuddly Toys Not Included – Een AMIS Query met Doug Burns

Donderdag as. is de AMIS Query van Doug Burns over SQL Tuning, gebruikmakend van de Oracle Enterprise Manager (Tuning en Diagnostics pack). Misschien verwachten velen een hoog “DBA” gehalte, maar niets is minder waar…

Deze presentatie bevat bijna geen enkele slides en is echt een aanrader om bij te wonen. Het gaat over kleuren, indelingen, interpretaties van grafieken en er zit een goeie scheut droge Schotse humor in deze presentatie verwerkt. Waarschijnlijk zal Doug ook nog de Real Time SQL Monitoring tool in kleur en geur uitleggen.

Met andere woorden geen moeilijke “DBA” achtige presentaties, maar stof om over na te denken als het gaat over SQL Tuning en de tooling, De Oracle Enterprise Manager (de bij de database meegeleverde DB Console) in dit geval de Oracle 11gR2 variant, die Oracle hiervoor steeds meer navoren drukt op alle mogelijke tiers waar zich Oracle en andere software bevind.

Voor extra info over Real Time SQL Monitoring zie ook de volgende blogpost: Real Time SQL Monitoring

Het is nog mogelijk om je aan te melden (zodat we o.a. een inschatting hebben t.a.v. de hoeveelheid eten) voor deze AMIS Query op Donderdag 17e Juni om 18:00 uur via:

Groet, Marco

PS.

De “Cuddly Toys Excluded” titel slaat op zijn haat/liefde verhouding met “Polly and the Boys” die bij tijd en wijle zijn blogsite overnemen (“The Cuddly Toys Liberation Front” – CTLF) of weer eens een puinhoop maken van zijn hotel kamer tijdens conferenties, als ze te veel vrijheid krijgen van Doug…

Meer info hier: http://oracledoug.com/blog/

;-)

ODTUG Preview: mini conferentie (APEX, Database en SOA)

Voor het vierde achtereenvolgende jaar organiseert AMIS de “ODTUG Preview” sessie op 8 juni 2010 bij AMIS in Nieuwegein. ODTUG Kaleidoscope 2010 is een conferentie voor Oracle ontwikkelaars, dit jaar vanaf 27 juni in Washington DC. Deze conferentie trekt van oudsher veel Nederlandse deelnemers, waaronder een flinke afvaardiging van AMIS. Tijdens de ODTUG Preview sessie laten Nederlandse presentatoren hun presentatie voor de conferentie in Washington horen aan een ‘thuispubliek’, als een soort try out of sneak preview. Voor iedereen die niet in gelegenheid is er in Washington bij te zijn, is dit een mooie gelegenheid om een aantal interessante presentaties van topsprekers bij te wonen.

De ODTUG preview omvat negen presentaties, in drie verschillende tracks:

  • APEX en Oracle Development
  • Oracle Database & Middleware
  • SOA en Fusion Middleware

De sprekers en presentatie-titels:

Tijd APEX / Oracle Development SOA en Fusion Middleware Oracle Database en Middleware
16:30 – 17:00 Ontvangst
17:00 – 18:00 Iloon Ellen-Wolf
APEX 4.0
Marco Gralike XML Database – Design Concepts for XML Applications that will Perform! Toon Koppelaars Semantic Query Optimization
18:00 – 19:00 Diner
19:00 – 20:00 Alex Nuijten Analytic Functions Revisited Peter Ebell OSB meets Database – and they lived happily ever after Lucas Jellema Edition-Based Redefinition for Developers and DBAs
20:00 – 21:00 Anjo Kolk Accessing the Oracle Database from Google (Apps, App Engine, Spreadsheets) Lonneke Dikmans Portals: The Way to Realize User Experience in a Service-Oriented Architecture? Jacco Landlust Comparing Oracle Application Server (OAS/IAS/OC4J) and WebLogic Server

Wil je bij deze sessie aanwezig zijn, meld je dan aan via http://www.amis.nl/de-agenda?eventId=5&task=event_register&type=reg_individual.

Technical Preview of ADF Mobile Client has arrived !

The Technical Preview of ADF Mobile Client now is generally available!

Ted Farrell, Chief Architect and Sr. Vice President of Tools and Middleware introduced the latest break-through in mobile application development at the BlackBerry User Conference (WES). ADF Mobile extends Oracle Application Development Framework to mobile users. Using Oracle JDeveloper, application developers can rapidly develop mobile applications that support mobile users accessing critical business data through either on-device mobile client or mobile. ADF Mobile Client supports a complete on-device client framework that works and performs consistently regardless of connectivity. The framework enables developers to develop one application that can be deployed to multiple mobile device platforms.

I wrote the OTN article to support the introduction of ADF Mobile Client: “Developing for BlackBerry Smartphones using Oracle JDeveloper and ADF Mobile”. According to Joe Huang (Senior Principal Product Manager Mobile Platform, ADF/JDeveloper) this article will contribute to getting ADF Mobile Client out to the market.

Click to go to the ADF Mobile Homepage, where you find all the resources.

Have fun working with ADF Mobile Client.

Upcoming session by Steven Davelaar on migrating Forms to ADF with JHeadstart 11g

My former collegue and JHeadstart Team member Steven Davelaar will join us at AMIS on wednesday May 19th, at 18:00, to present on a particular feature of the new JHeadstart 11g release: the JHeadstart Forms2ADF Generator (JFG). Forms to Java and/or ADF migration tools have been around for a long time – for instance, VGO Software has been doing this for quite some time now with their EVO tool, and their latest release also offers ADF 11g as a possible “target” technology. But there are many more. And with every Forms2Jave migration tool, the critical issue is always: “What about the PL/SQL logic??”. Read the rest of this entry »

Bookreview: Oracle Fusion Developer Guide

Oracle Fusion Developer Guide: Building Rich Internet Applications With Oracle ADF Business Components And Oracle ADF Faces

In December 2009 some 750 pages of ADF examples and ADF how-to’s were released in a great book: “Oracle Fusion Developer Guide: Building Rich Internet Applications With Oracle ADF Business Components And Oracle ADF Faces” by Frank Nimphius and Lynn Munsinger.

I ordered the book at amazon (this is the direct link) and received it by mail a few weeks later. In this post I share my first impressions with you. Read the rest of this entry »

Part of the Puzzle: Oracle XMLDB NFS Functionality

This story is long overdue and no its NOT about the Oracle Database 11g Database File System (DBFS). Its about an “undocumented” NFS functionality that, maybe someday, will be serviced by the XMLDB XDB Protocol Adapter. This post is “long overdue” because the actual attempts to try to figure it out were done during the bank holidays between X-mas and new year 2009.

So what is it all about. I once discovered in the Oracle 11gR1 documentation a small entry in the xmlconfig.xsd XML Schema regarding NFS elements that look like that they are or will be used for enabling NFS functionality based on the Oracle XMLDB Protocol Server architecture. In those days, when Oracle 11gR1 was just of the shelve, I made a few attempts, based on the xdbconfig.xsd XML Schema to adjust the corresponding xdbconfig.xml file that controls the XDB Protocol Server functionality, to see what would happen. At that time I only was able to get this far (see the picture) and I promised myself that I should look deeper into it trying to figure out if I could get it working and/or what the concepts were that made it tick in the XMLDB architecture but somewhere down the line I just didn’t come to it and it got “forgotten” by me due to my daily DBA workload.

NFS Protocol Server functionality enabled manually

Read the rest of this entry »

Automatic testing Oracle Service Bus using Hudson, maven and SoapUI

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.

Sneak Peek and what can come of it

WebButtonLast Tuesday we did a Preview of the upcoming OPP (Oracle PL/SQL Programming) Conference which will be held in Atlanta, Georgia soon.

This preview took place in our office in Nieuwegein, The Netherlands. About 17 people attended this free preview. At regular intervals we do free "Knowledge Center" presentations. Keep a close eye on our Agenda to see future events.

Read the rest of this entry »

ADF DataBinding: Yet another thing it does for you.

Today I encountered something that I have seen frequently. While developing an ADF application developers tend to invoke methods on an application module directly, instead of invoking them via the bindings framework. You might get some unexpected results and some additional work too…

Correcting this behavior afterwards can be very annoying and time-consuming. In this blog, just to let developers know, I describe what you could do to prevent this error. Read the rest of this entry »