I get a lot of questions on how to select all rows in a table. In this post I describe how you can do that. A common use case for this is when you want to apply changes on a set of records, for instance change the status of all records in a table. You [...]

Something new? Eh? Should you do this? Eh? In all, probably not, but for me this was a good exercise towards some more updated demo scripting for my “Boost your environment with XMLDB” presentation or hopefully more clearer relabeled Oracle Open World name for the almost same presentation called “Interfacing with Your Database via Oracle XML [...]

On the JDeveloper ADF forum there are many questions on how to change the look and feel of components. In this post I’ll explain three ways to do that. Setting skin Selector property For this we need to define a custom skin. <?xml version="1.0" encoding="ISO-8859-1"?> <skins xmlns="http://myfaces.apache.org/trinidad/skin"> <skin> <id>mySkin.desktop</id> <family>MySkin</family> [...]

‘Oracle Team Productivity Center (TPC) is an Application Lifecycle Management (ALM) tool that enables software development teams to collaborate and work productively together when developing applications using JDeveloper.’ (OTN TPC page) TPC provides unified access to different ALM repositories from within JDeveloper and it allows to define relations between the so-called work-items in these (separate) repositories. [...]

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. During the Sunday [...]

In a recent post I described how we can use the EJB Binding in SOA Suite 11g PS2 to invoke a SOA Composite application through RMI as a remote EJB. This interaction can be fully based on Java interfaces – no WSDL or XML required. However convenient that is, I have not yet been able [...]

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 [...]

With the recent (April 2010) SOA Suite 11g R1 Patch Set 2 (11.1.1.3.0), several new capabilities have been added to the SOA Suite. One these is the EJB Binding. Or rather, an enhanced version of this binding. In previous releases, this binding was available to provide interaction with SDO enabled EJBs – based on a [...]

I am currently reworking Chapter 12 for the SOA Suite 11g Handbook. This chapter describes various types of interaction SOA Composite Applications can have with Java applications and components. Since the initial creation of this chapter – some 6 months ago – we have had the Patch Set 2 release of the SOA Suite. This [...]

Some days ago a collegue of mine asked if I could made something for him to unzip a Microsoft Word 2007 docx file. And of course in the database and without using Java. As it turns out, a docx file is just a ordinary zipfile, with some xml-files stored in it. And because I already had [...]

As of Oracle 10g it’s possible to recover (or wind forward) a RMAN disk copy of the database to a specific time in the past. This type of backup is quite suitable for big databases (> 100GB), because you have to perform a time consuming full backup only once. All other backups to disk will [...]

Op Donderdag 17 juni, vanaf 18:00 uur, zal Oracle Database Expert en Oracle ACE Director Doug Burns(Schotland), een kennisavond vullen met live demo’s op basis van de Oracle Enterprise Manager Diagnostic en Tuning Pack. Deze bijzondere avond, geheel zonder slides, met de naam “How I Learned to Love Pictures – Oracle 10g/11g Performance Analysis Using [...]

Van maandag 7 tot en met vrijdag 11 juni verzorgen Luc Bors en Lucas Jellema een 5-daagse ADF 11g training – in het kantoor van AMIS in Nieuwegein. Deze training is bedoeld voor ontwikkelaars die met ADF 11g aan de slag zijn of willen gaan en behandelt alle onderdelen van het framework: ADF Business Component, [...]

Recently we had a great session at AMIS about Maven, presented by Jason van Zyl, founder of the Apache Maven project and CTO of Sonatype. He gave us an overview of the new Maven 3 and other projects they are working on. In addition he gave us an insight in the world of Maven. For [...]

The Oracle JCA database adapter enables the communication between a web service and a database object, for instance a stored procedure. With the adapter configuration wizard, part of JDeveloper 11g, meta data is generated design time and used run-time to control the behaviour of the database adapter. In this hands-on we show how to set [...]

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 [...]

On the 18th of June I am very happy to have arranged an internal mini masterclass for my DBA colleagues and some AMIS customer DBA peers. The evening before on the Thursday the 17th of June (btw. no important World Cup soccer games going on during this Thursday evening) Doug agreed to present his “How [...]

The use of XML documents is common practice nowadays and so is XML schema (XSD) to validate XML documents. XML validation is often needed to ensure structure, content and relations. However XSD validation covers only a small part. XSD can describe the basic XML structure (valid elements and order) and basic content validation of a [...]

Zoals al aangekondigd in een eerdere blogpost heeft AMIS in samenwerking met Miracle Benelux, Masterclass trainingen, de mogelijkheid om vlak voor de twee daagse Masterclass in Utrecht van Oracle ACE Director en Oracle Security expert Pete Finnigan uit Engeland, een AMIS Query te organiseren. Beveiliging van je data en de focus hierop is vaak een [...]

Last night we organized the “Ode to the Task Flow” session at AMIS. After a short presentation introducing the Bounded Task Flow it was time for the hands-on lab: “Build your first taskflow”. In this lab many of the attendees created their first taskflow, learning the basics of ADF taskflows. This first taskflow receives a [...]