Interesting alert from Oracle Business Rules – Gap Analysis
Seems like stating the obvious: if they are are missing, they are not likely to be found, now are they? Makes you wonder what the alternative would be. Something …
Author: Lucas Jellema
Do it yourself Transaction Recorder – when standard auditing is not available
In the recently published blog article Database Transaction Recorder – Adding Who to When and What to make Flashback take over from Journalling tables (https://technology.amis.nl/blog/10911/database-transaction-recorder-adding-who-to-when-and-what-to-make-flashback-take-over-from-journalling-tables) I have discussed how …
Ways to instantiate a variable in Oracle Service Bus based on a static XML document
Today we had an interesting exploration into the many ways available in the Oracle Service Bus to load a piece of XML into a variable in a message flow …
APEX plugins contributed to the APEX community by AMIS developers
![APEX plugins contributed to the APEX community by AMIS developers]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "APEX plugins contributed to the APEX community by AMIS developers")
I have to admit that, even though I have tried on several occasions to dive head first into APEX, so far I have only wet my feet. I have …
Database Transaction Recorder – Adding Who to When and What to make Flashback take over from Journalling tables
In previous articles, I have suggested that the arrival of the Flashback Data Archive in Oracle RDBMS 11g allowed us to finally say goodbye to journalling tables. Keeping track …
The Talking Database – on putting query results into words – soundbiting from SQL?
In my investigations into the role the Oracle RDBMS can play in application architectures and especially how Java applications can leverage the database, I have ventured into some strange …
No JDBC based data retrieval in Java applications – RESTstyle, JSON formatted HTTP based interaction from Java to Database
This article demonstrates how Java application can query data from relational databases (well, in this case more specifically the Oracle RDBMS) without the use of plain old JDBC but …
Integrating resources from UCM Content Server in ADF Web Applications using the Open WCM tags
January 23, 2011
Oracle, Oracle Application Development Framework, Oracle WebLogic Server, SOA, WebCenter
5 Comments
There are several ways available to integrate content from UCM in Web Applications. The best known one is probably through the WebCenter Document Services (taskflows that can directly be …
Configuring WebCenter 11g R1 PS3 with remote UCM Content Server
January 22, 2011
Oracle, Oracle Application Development Framework, Oracle WebLogic Server, SOA, WebCenter
1 Comment
It took me a while. I have read through at least a dozen different articles. Probably did many things that in hindsight were not necessary. But at last I …
Having users create Polls in your (and their) ADF/WebCenter application – at run time
The Patch Set 3 release of Oracle Fusion Middleware hit the streets a few days back. For many of the FMW components, this release is one that fixes bugs, …
SOA Suite 11gR1 PS3 – Some new BPEL features
The Patch Set 3 for SOA Suite 11g R1 that was released last weekend brings bug fixes, stabilization, further integration between components and a bunch of new features. Most …
WebCenter 11gR1 PS3 – Design Time at Run Time with a Vengeance – introducing run time Data Controls and Data Visualizations
January 16, 2011
Oracle Application Development Framework, Oracle WebLogic Server, SOA, WebCenter
2 Comments
The concept of design time @ run time that empowers application administrators and even end users to influence the application after it has been deployed has been gaining traction …
Adding a custom method in an ADF BC Service Interface – update of a single attribute in a selected row
The article “Quickly creating, deploying and testing a WebService interface for ADF Business Components” (https://technology.amis.nl/blog/9726/quickly-creating-reploying-and-testing-a-webservice-interface-for-adf-business-components) that I recently published describes a way of very rapidly creating the HRService Web …
Quickly creating, deploying and testing a WebService interface for ADF Business Components
December 29, 2010
Continuous Delivery, Java, Oracle, Oracle Application Development Framework, SOA
3 Comments
As you probably already know, ADF Business Components can very easily be exposed through a WebService interface. An Application Module can be configured with a Service Interface, ordinary ViewObjects …
Anti-Search patterns – SQL to look for what is NOT there – Part Two
It is a strange thing really: querying the database to find missing data. Queries usually report on what is there. Not the queries in this article (and its prequel): …
Retrieving the values for domains in SQL queries in the Oracle RDBMS – months, days, numbers and custom value sets
It happens quite frequently that in our database applications – in queries or in PL/SQL packages – we need to use the values from more or less standard domains …
Querying ISO Country names and codes from SQL – exposing standard domains based on dynamic internet retrieval
The other day, I came across a press release – www.iso.org/iso/pressrelease.htm?refid=Ref1383 – from the ISO organization, announcing that they had issued new country codes for the islands in the …
Extreme Decoupling in SQL – Select and DML against a table that is not a table at all
One of the key objectives – though not ulterior motives – in Service Oriented Architecture is decoupling. By decoupling currently mutually dependent agents, we introduce more opportunity for flexibility, …
Anti-Search patterns – SQL to look for what is NOT there – Part One
Usually in SQL queries, you will try to retrieve information from a database by reading specific records from the relevant tables. However, there are situations where what you want …
Masterclass for Java Developers – Make that Database Work for You! 17th December 2010
Really getting the most out of your database. That would be nice, given wat databases can do (and what you may have paid for them). Few serious Java Applications …
Java Developers: Make the Database Work for You!
This article accompanies the similarly named article in the Dutch Java Magazine. It provides additional resources, some source code and an invitation to the 4 February Masterclass by Lucas …
Convert PDF or Images through Optical Character Recognition to text (in Google Docs)
In the email that informed me that in a few months time my Google Groups will no longer be supported or even available (ouch, that hurts) – I noticed …
PL/SQL (and APEX) highlight of the year: OPP Conference in Brussels, 27-28th October
PL/SQL Developer Tools Session Brussels (Belgium) will be the PL/SQL Hotspot of the world during the two-day OPP 2010 (ODTUG’s Oracle PL/SQL Programming) conference – that is co-located with …
AMIS presenteert "Verslag van Oracle Open World en Java One 2010'
Voor het vijfde achtereenvolgende jaar organiseert AMIS deze openbare bijeenkomst waarin uitgebreid verslag wordt gedaan van de belangrijkste conferenties van het jaar: Oracle Open World en JavaOne. Op woensdag …
Oracle Develop Keynote – Ted Farrell Showing Off ADF in a big big way!
September 22, 2010
Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, SOA
No Comments
A few moments ago, Ted Farrell completed his demonstration of ADF 11g – the premier framework for developing rich, multi-channel applications. In 30 minutes he ran the audience through …
JavaOne 2010 presentation: Why and how to engage a Complex Event Processor from a Java Web Application
Complex Event Processors are capable of handling large volumes of events – by filtering, aggregating or detecting patterns. Java Applications use a CEP to pre-process incoming signals. These applications …
Xenogenetics for PL/SQL: Infusing with Java Best Practices and Design Patterns (presentation at OOW 2010)
Xenogenetics for PL/SQL: Infusing with Java Best Practices and Design Patterns – Alex Nuijten and Lucas Jellema PL/SQL is a venerable programming language that is both vital and very …
JavaOne 2010 – Keynote by Thomas Kurian – Java Strategy and Directions
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 …
Oracle Open World 2010 presentation: Forms2Future: the ongoing journey into the future for Oracle based organizations
September 21, 2010
Data Warehousing & BI, Database, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA, Web HTML5 CSS3
No Comments
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 …
SOA Suite 11g Handbook – Chapter Complements
After struggling a bit with various infrastructures that kept falling down (Oracle Wiki, Google Groups) I hope to have found a more stable environment to publish the resources that …
More than five years later – we are finally there: Larry Elison announcing Fusion Applications
September 20, 2010
IT, Java, Oracle, Oracle E-Business Suite, Oracle WebLogic Server, SOA
No Comments
Larry Ellison: We set out to deliver the next generation of business applications. Our task: Take all of the best features from Oracle’s major application products – including E …
Larry Ellison – Opening Keynote of Oracle Open World 2010 – announcing Exalogic, the cloud in a box.
September 20, 2010
Database, Engineered Systems, IT, Java, Oracle, Oracle WebLogic Server, SOA
No Comments
The first major keynote of this year’s Oracle Open World conference was last night – Larry Ellison announcing the Oracle Exalogic machine, the “cloud in a box”. A high …
JavaOne under construction – roads closed down, tent being erected, attendees flying in
San Francisco on the eve of JavaOne 2010. Various preparations are underway in the city. Posters and banners, even on the sidewalks, mark the largest Java show on the …
Oracle Advanced Queuing and JMS – bridging from AQ to JMS and vice versa
September 18, 2010
Database, Databases, Java, Oracle, Oracle WebLogic Server, PL/SQL, SOA
No Comments
In preparation for our Oracle Open World session ‘Xenogenetics for PL/SQ – Infusing with Java Best Practices and Design Patterns’ – I have been doing a little work on …
Event based Decoupling in PL/SQL – your first Advanced Queue adventure
Back in 2004 when we started with the AMIS Technology Blog, my main objective was to record the things I infrequently do in order to have notes describing the …
What questions to get answered at Oracle Open World 2010
The sun is setting in Redwood Shores. The sky is red; the Oracle HQ towers are silhouetted against this dramatic red backdrop. Red, the color San Francisco is about …
What questions to get answered at Java One 2010
It is a very early morning in Redwood City. I am currently in a hotel with a great view on the imposing towers of Oracle’s Head Quarters (although it …
Invoke SOA Composite application through RMI as remote EJB (using binding.adf)
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 …
Publish SOA Composite application as EJB to be invoked from Java applications using EJB Binding
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. …
Calling an EJB from a SOA Composite Application using the EJB Binding based on Java Interface
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. …