Knowledge Center on Web & Java
AMIS has several Knowledge Centers, each around a technology theme. The current themes are: Web & Java (Oracle) Server Development & Programming Languages Oracle Development Tools Database Administration and …
Category: Oracle
TheServerSide.com – Hibernate vs. Rails: The Persistence Showdown
An interesting article comparing two OO/R frameworks: Hibernate and RAILS. It gives a good indication of what you should look for when investigating OO/R mapping/persistency frameworks. TheServerSide.com – Hibernate …
Updateable External Tables
Introduction External tables were first introduced in Oracle 9i. They provide easy access, by means of SQL, to data stored in files on the file system (i.e.: outside the …
Refreshing a ViewObject on view in JHeadstart
Imagine this situation: you have created several tables and a view that queries several columns in these tables. Using BC4J you’d create a ViewObject on the view. The ViewObject …
Strangely well timed article on ADF BC: Most Commonly Used Methods in ADF Business Components
Just found this paper: Most Commonly Used Methods in ADF Business Components by Steve Muench (15 March 2005) on OTN. This paper provides a high-level description of the key …
BPEL and Service Oriented Analysis and Design (SOAD)
Recently I read an interesting Article about BPEL related analysis and design issues. BPEL stands for Business Process Execution Language and is the world standard to describe “Business Processes” …
New article for OGH Visie on ADF and ADF JHeadstart – (sorry it is in Dutch)
For the April issue of OGH Visie, the magazine of the Dutch Oracle User Group, I have written an article on Oracle 10g JDeveloper ADF and JHeadstart 10.1.2 for …
How to migrate Domains and Table Definitions with the JHeadstart 10.1.2 Designer Generator
The JHeadstart 10.1.2 release for ADF and JDeveloper 10.1.2 – published late February 2005 – includes a substantial number of improvements over the previous 9.0.5.x releases of June 2004 …
Oracle Warehouse Builder 10g Paris Release … Oh ja, ook voor Data Warehouses! (article on the OWB 10gR2 Paris Release)
This article is about a very interesting Oracle tool: Warehouse Builder. A tool that is much more versatile than its name suggests. OWB can be used for diverse activities …
Eindgebruikers zijn Olifanten – Driedaags seminar ‘Effective Oracle by Design’door Oracle-fenomeen Ask-Tom Kyte (article from Optimize, March 2005)
The March 2005 issue of Optimize, the Dutch Oracle Developer Magazine, contains a review of the Tom Kyte seminar AskTom-Live. This seminar has been discussed in many details on …
Create logging data in the same table
Suppose you want to log every update on a table. You want the log records to be in the same original table. You cannot do this in a simple …
Anton heralded by Steven Feuerstein as very creative PL/SQL developer
![Anton heralded by Steven Feuerstein as very creative PL/SQL developer]({"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"} "Anton heralded by Steven Feuerstein as very creative PL/SQL developer")
Steven Feuerstein, one of the world’s leading PL/SQL experts, runs a series of column on OTN (Oracle Technology Network). One of the repeating elements of his column is the …
Oracle BPEL Process Manager 10.1.2 Beta 3 available for download
I just received word from Sandor Nieuwenhuijs that the next Beta (B3) release of Oracle BPEL Process Manager has just been made available for download on OTN. Go for …
Introducing Materialized Views as mechanism for Business Rule implementation (complex declarative constraints)
Put on the trail by Tom Kyte – and after many useful discussions with my colleague Andre, we will take a look in this article at implementing complex business …
Oracle10g Lite, scratching the surface
Over the last few days I scanned trough documentation about Oracle10g (Oracle 9i) Lite the get a overview of the possibilities. Furthermore I tried to install the product on …
Book review: Business Process Execution Language
March 17, 2005
Book reviews and Publications, IT, Oracle, Oracle WebLogic Server, Web HTML5 CSS3
1 Comment
Title: Business Process Execution Language Author: Matjaz B. Juric, Benny Mathew, Poornachandra Sarang Published by: Packt Publishing ISBN: 1-904811018-3 Publication Date: 2004 Details: 270pages, $59.99; www.packtpub.com I recently read …
New Books Shipment in – March 2005
The first half of the March shipment has arrived. Some books are in the library, others immediately went home with some of my esteemed colleagues. Some of the books …
Creating your own advanced search engine for any website – using Oracle Text – Searching the AMIS Technology Weblog
The Oracle 7Up workshop that I teach every few months introduces many Oracle 8i, 9i and some 10g features to experienced SQL and PL/SQL developers with a firm footing …
Calling into the Oracle BPEL Engine from Java
We have discussed in several previous posts how you invoke Java services from BPEL processes, either through embedded Java or through a WSIF interface. Another interesting option with the …
Integrating WebUtil with Designer 10g
This post discusses how you can integrate WebUtil with Designer 10g to generate webforms using the webutil API’s with less post generation actions. Near 100% generation of webforms using …
Declarative Implementation of Mandatory Master-Detail relationship (Order must have Order Lines)
Since at least 1996, I have been involved with specifying and implementing business rules. Whenever possible, business rules are implemented in the database using declarative constraints. Triggers are the …
Generate External Tables from an Excel Spreadsheet Using Jakarta POI
An interesting article on OTN by Casimir Santeros, bringing the worlds of Java and Oracle together. The assignment: loading data from multi-sheet Excel documents into Oracle database tables. Technologies …
Bring in the decorators – SiteMesh!
March 7, 2005
AMIS, IT, Java, Oracle, Oracle WebLogic Server, Tools, Web HTML5 CSS3, Web/Java
No Comments
There are several approaches to keep a consistent look and feel for your web application. Lots of times the site will contain a navigation bar, a heading maybe a …
XmlHttpRequest – blast from the past or future
In several places XMLHttpRequest sprung up this week. XmlHttpRequest is a JavaScript object allowing browser clients to communicate with a server without refreshing the current page. This object originated …
How to drive your colleagues nuts – dbms_advanced_rewrite (Oracle 10g)
If you really want to have some fun – and have your co-developers start wondering whether they are losing it altogether – you could consider spending a few minutes …
More on BPEL
The last couple of weeks we’ve been playing around with the BPEL Designer plugin for JDeveloper 10.1.2. As BPEL is mostly used to integrate existing webservices, that’s what we …
Registering non-default XMLDB HTTP/WebDAV and FTP ports on a non-default Oracle Listener port
Yesterday, I had to install XMLDB on an already very heavy used system. On this UNIX system, an old Oracle IAS is installed, OAS 10g (version 9.0.4) and an …
Oracle Forms Documentation Utility
I noticed (tipped of by Duncan Mills) Oracle Forms XML Explorer, a useful utility – comparable to FoReDoclet, see Alex’ post Oracle Open Source : FoReDoclet – for generating …
JHeadstart 10.1.2 for ADF can be downloaded from OTN
Since late Tuesday, the new JHeadstart 10.1.2 release for ADF features on the Homepage of OTN! The full software package can de downloaded from the JHeadstart Home on OTN …
Book Review: Mastering Oracle SQL
Title: Mastering Oracle SQL, 2nd Edition Authors: Sanjay Mishra, Alan Beaulieu ISBN:0-596-00632-2 Publication Date: June 2004 More info can be found at website of O’reilly. There’s also a sample …
Migration from MySQL to Oracle – using Oracle Migration Workbench
All statistics on the visits to the posts in the AMIS Technology Weblog are gathered in a MySQL database that sist underneath WordPress. We would like to do some …
BC4J (ADF Business Components) logging and debugging – great blog from Sandra!
The JHeadstart Blog just published a very good blog by my former colleague Sandra Muller: ADF Business Components Diagnostics. Previously, I knew to find a few remarks on this …
Little Gold Nugget: SQL*Plus COPY Command
Although not a “new” command in SQL*Plus, it’s very cool. Recently I had to move some data from one table to another in a different database. The Source table …
Tom Kyte a true Oracle Guru.
My impressions from the Oak table seminar with Tom Kyte. I knew Tomas Kyte only from the book ‘Effective Oracle by Design’ and was interested to hear from him …
Pipelining 10g Database Export and Import
A very interesting feature in the Oracle 10g Data Pump I becase recently aware of is the option to link an Export job in one database to an Import …
First impression of Oracle jDeveloper BPEL Beta2
The last few days a colleague and I have been looking into a beta release of Oracle’s BPEL designer for jDeveloper. This tool enables you to orchestrate single web …
Debugging JavaScript – article from DevShed – Introducing Venkman
Debugging JavaScript code – an all too familiar nightmare. Yesterday I was told about Venkman for FireFox, today I found this article in DevShed: Debugging in Javascript, Contributed by …
Oracle 10gR2: .Net stored procedures (C#, Visual Basic .Net, Visual C++)
This weekend I read a small article in a local Dutch IT-magazine that took me by surprise. I suppose I should have seen it before, but for some reason …
Book review: More Eric Meyer on CSS
Those who have layed out a web page or application with CSS should be familiar with the name Eric Meyer. He has a web page with many well known …
new JHeadstart Team blog Announces production release
February 19, 2005
AMIS, IT, Java, Oracle, Oracle WebLogic Server, PL/SQL, Web HTML5 CSS3, Web/Java
2 Comments
Oracle’s JHeadstart team does a double whammy, not only do they release the production version of ADF JHeadstart but they announce it on their brand new weblog. As already …