An interesting problem we were working on some time ago is the following: a JHeadstart application – release 18.104.22.168 created with UIX, BC4J and Struts, JDeveloper 9.0.3 – has many Find pages. These pages contain many search-criteria. Our users would like to have their own default values provided for some/many/most […]
Title: Oracle Database 10g New Features – Oracle10g Reference for Advanced Tuning and Administration Authors: Daniel Liu, Don Burleson, Madhu Tumma, Mike Ault Published by: Rampant Tech Press ISBN: 0-9740716-0-9 Publication Date: 01 December, 2003 Details: 530 pages, $34.95; code depot at: http://rampant.cc/new.htm SummaryIt is not a reference, it is […]
In this post we discuss pivoting of records in SQL – either splitting or merging records. Typically this is done using PL/SQL based Table Functioins, UNION (for splitting records) and fairly complex, tricky SQL statements. In Oracle 10g, using the MODEL clause, there is a clean, fairly straightforward way to achieve elegant pivoting – even nested pivoting – in single SQL statements. This post shows the pivot operation using the Model clause.
Last Friday we enjoyed one of the special privileges we have in our partnership with Oracle in The Netherlands – we have a private session on one of Oracle’s latest products Enterprise Planning and Budgeting (announced as early as 2002 as successor to OFA and OSA – Oracle Financials and […]
In this post I explore the parallel execution of Table Functions. I was told it could be done, I have seen the examples and now I have tried it myself, using my single CPU machine running XP and Oracle 10g Database (Enterprise Edition). Parallel Execution proves to be an enormous performance boost – in certain circumstances.
Last Thursday evening was special. On the occasion of Chris Date’s visit to The Netherlands, the product marketing department of Oracle Netherlands had gathered some 25 odd (could also be spelled with dash 25-odd) Oracle experts at The Rijksmuseum in Amsterdam. This remarkable group represented over four centuries of specialist […]
Yesterday we had a technical session at Amis on ADF. In one discussion a concern was raised on how all the ADF metadata and the abstractionlayers would affect performance. Quite coincidently Steve Muench posted a presentation on Improving ADF performance he gave at Oracle Open World yesterday. A very good […]
Today I discovered the 22.214.171.124 maintenance release for Oracle Designer 10g on MetaLink. It has been released on November 18th, so this is not hot news. The 126.96.36.199 is not yet available on OTN’s Designer Software Page, there you will still find 188.8.131.52. If you have an existing Designer/SCM 10g […]
Not too long ago my colleague Zeger Hendrikse gave this presentation on Open Source Databases. Part of this presentation are the Tools available. One of the Tools he mentioned also has an Oracle Plugin available. So, continuing the story on Oracle and Open Source, may I present to you: SQuirreL
You may seen some enthousiastic ramblings on Table Functions in earlier posts I have written. This is another one. With approximately 50 lines of code, you can select crude graphs for any query. For example, a graph that indicates the total salary sum for the three departments in the SCOTT […]
During my current project, i encountered jWebUnit, a unittesting framework based on jUnit and HttpUnit. Old news for some, new for me. Since we already had some posts on jUnit and HttpUnit, i thought this might be of interest. An example of its conciseness (as found on the jWebUnit homepage):
Last week we received another shipment of books for our evergrowing library. Among this shipment were these titles:
The Oracle JDeveloper release 10.1.3 Developer preview release can be downloaded from OTN. See JDeveloper Homepage “The Oracle JDeveloper 10g (10.1.3) release adds many new features, including a new look and feel, a greatly improved coding environment, extensive refactoring options, J2EE 1.4/J2SE 5.0 support, and visual JSF development.” I took […]
Name JHeadstart 10g – Productive J2EE application development without coding Java date Thu, 25 Mar 2004 Article in ODTUG Technical Journal (March 2004) The ODTUG Technical Journal is the most important international technical magazine for Oracle developers. This article describes in 21 pages the productivity and ease of development that […]
For one of our projects, we wanted to copy the contents of our production database to the test database. Both databases are accessible via JDBC. After an investigation of available tools, I had to revert to my own solution.
There is a simple way to use the Expression language you use in JSTL expressions in your JSP’s, in ADF’s DataAction. Actually anywhere you can get hold of a LifeCycleContext (or any subclass) you can use SPEL. What you need is the class oracle.adf.controller.lifecycle.Evaluator. You can obtain one like this […]
Every once in a while for no apparent reason a JDeveloper ADF/Struts project gets corrupted. When compiling the project I get an error that a certain class cannot be found. Most of the time it ‘s a struts HTML tag class. When I check my libraries and paths everything seems […]
There seems to be a problem in the PHP code of the Wp-Dstats2 statistics plug-in for WordPress. The problem occurs when your number of unique visitors (unique IPs) grows large, typically somewhat less that 30.000.
On OTN there is an excellent online seminar (replay) on the TopLink Object-to-XML support. This feature, which will be available in the upcoming 10.1.3 release, allows converting XML files into Java objects and vice versa. For those allready working with TopLink’s Object-relational mapping, the following will sound very familiar. It […]
On February 8, 9 and 10, Tom Kyte will present a seminar – just around the corner, in Utrecht. See Seminar Details for details. The event is organized by fellow Oak Table member Lex de Haan (you may know him from the HR schema in the Oracle database – select […]