BI Beans and Export to Excel
BI Beans only provides export to CSV to be imported into Excel, at least up to the 9.0.4 release: News from the BI Beans product team: In the 9.0.5 …
Author: Lucas Jellema
Organization of BC4J – Domain (EO) and Business (VO) package
A topic that seems to come up again and again is the issue of reusing BC4J packages across applications and projects. And along the same lines structuring the BC4J …
Hidden PL/SQL Gem in 10g: DBMS_FREQUENT_ITEMSET for PL/SQL based Data Mining
Data Mining in PL/SQL applications – Supplied Package DBMS_FREQUENT_ITEMSET (new in 10gR1) Resource: Oracle 10g Supplied Packages – dbms_frequent_itemset. This package exposes some part of the Data Mining capability …
JHeadstart Recipe for Display Only Boilerplate List of Value base items (release 9.0.5.x)
During this week’s JHeadstart workshop it turned out that our recipe for Display Only LOV fields did not support JHeadstart 10g (release 9.0.5.x). I have changed the recipe to …
Make texts (and cells) hyperlink-active using CSS
This brief article by Frank Manno from the Developer Shed describes a pretty, elegant way to create strings that act as hyperlink – where not just the string but …
Spacer for JHeadstart Generation
During the JHeadstart workshop I am teaching this week there as a question: How can I – in a two-column layout – force two adjacent fields to be positioned …
Collect and share interesting bookmarks
I came across an interesting site: del.icio.us . It describes itself as “a social bookmarks manager. It allows you to easily add sites you like to your personal collection …
DDL Wizard – freeware to extract DDL from Export-files (dump-files)
![DDL Wizard – freeware to extract DDL from Export-files (dump-files)]({"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"} "DDL Wizard – freeware to extract DDL from Export-files (dump-files)")
Thanks to Mark Rittman’s blog: The Oracle Export File DDL Extract Wizard What Does the DDL Extract Wizard Do? The DDL Extract Wizard will reverse engineer Oracle Export files …
HttpUnit 1.6 Released
From this thread on The Server Side: HttpUnit 1.6 released. HttpUnit 1.6, the first new production release in over a year, is now available. HttpUnit emulates the relevant portions …
A single POJO persistence model to replace JDO and take over much of EJB??
Java and persistence are hot. And continue to be hot. If I read things correctly, Sun – through Linda DeMichiel and Craig Russell Specification Leads, JSR-220 and JSR-243 – …
Analytical SQL Functions – theory and examples – Part 2 on the Order By and Windowing Clauses
To understand how Analytical Functions are used in SQL statements, you really have to look at the four different parts of an Analytical ‘clause’: the analytical function, for example …
Java 5.0 (Tiger) – MetaData and Annotations – Introduction and thoughts on application
I have given the meta-data features in the J2SE 5.0 Tiger Release some more thought. Reading – in this order – through the following articles, I rather quickly had …
Java 1.5 == 5.0 ==Tiger is loose (Sun releases J2SE 5.0)
All the news etc. starts here: J2SE 5.0 Home For new features see here (new features). and here (release notes). Then there is the article: Java 5.0 in a …
Analytical SQL Functions – theory and examples – Part 1 on the Partition Clause
To understand how Analytical Functions are used in SQL statements, you really have to look at the four different parts of an Analytical ‘clause’: the analytical function, for example …
Introduction to Analytical Functions – Use of Analytics as alternative for Simple Aggregations
I will attempt to introduce analytical functions in a step-by-step manner. A first step into Analytical country could be the following, starting from a very simple aggregation query, exploring …
Trick for multiple and flexible parameter passing with MOD_PLSQL and Web PL/SQL toolkit
This tip comes from a very interesting paper by John Flack. It is titled MVC Development in PL/SQL and appeared in the August issue of the ODTUG Technical Journal …
Struts, JDBC and Data Guard – Oracle Open World Amsterdam – Friday 24th September – Impressions
In this post I will tell you about some of the sessions  notably on Struts support in JDeveloper, Java/JDBC support with Oracle 10g and the Data Guard option of …
Eating your own dogfood – use of Oracle Development tools within the Oracle Applications development group
During the Amsterdam stage of the Oracle Open World Tour, I had a great opportunity to interview John Wookey Senior Vice President, Applications Development at Oracle Corporation. John is …
BPEL is great and so is Oracle BPEL
Probably many of you have at least a vague notion of what BPEL (Business Process Execution Language) is all about. Now, thanks to a very good presentation by Oracle’s …
AMIS Query: The Future of Oracle Designer (and other tools)
Yesterday, we had another AMIS Query session titled The Future of Oracle Designer. It discussed the future of Oracle development tools, more specifically Oracle Designer and Forms as well …
Oracle Designer – a tip for Generation of Forms – Enforce Post Generation
During our session on the Future of Oracle Designer yesterday I had a conversation with Josef Megens of Oracle Consulting and told me of a trick conceived by Mark …
The future of CDM RuleFrame – the Oracle framework for server-side business rules
In this post I will discuss some thoughts I have on the further development of CDM RuleFrame (the Framework for implementing Business Rules). It seems to me that a) …
New open source databases: Cloudscape (Apache Derby) and Ingres
Recently, IBM announced the open-sourcing of their Cloudscape database. a lightweight, Java-based relational database with a footprint of just 2MB. It’s significantly less resource-intensive than enterprise databases like IBM’s …
Expert Session on Persistency Framework: Toplink
Yesterday we had an excellent meeting on Java persistency frameworks, in particular Toplink. Oracle Consultant and Java expert Peter Ebell presented on his experiences with Toplink on a very …
Great document on Java/J2EE Guidelines
I found a very interesting document (300 pages) with standards on Java/J2EE guidelines, Technical Paper: Java – J2EE Conventions and Guidelines Release 1.0.2 Stephan Janssen The JCS Team (2004). …
PLDoc release 0.8.2 Available
At 21st July 2004, release 0.8.2 of the PLDoc open source project for generating JavaDoc style documentation for PL/SQL Code (and now also Tables and Views) was published. PLDoc …
Sneak preview of ADF JHeadstart
Yesterday we (Hans, Harm, Rob, Wiene and myself) had a session with the Oracle JHeadstart team (Steven and Peter) where they demonstrated the upcoming ADF JHeadstart release. We also …
JSP and JSTL experiences
This post describes some of my recent experiences in using JSP and JSTL. For many probably highly trivial.
AppFuse – To get a J2EE project going…
An interesting article on java.net on AppFuse: AppFuse: Start Your J2EE Web Apps by Matt Raible. AppFuse tries to make it as simple as possible to build, test, and …
Article on ANT 1.6 – features for Task Writers
An interesting article appeared on OTN today: ANT 1.6 for Taskwriters. This article will show you that Ant 1.6 has also changed internally and how you can take advantage …
Enhancements for JHeadstart Generator/Consolidation of best practices
This post describes a list of JHeadstart Application Generator enhancements and also provides a progress report on the implementation of the features mentioned
End of an era (for me): Oracle SCM State of Direction
It does not come as a great surprise, yet I feel sad. Oracle’s Statement of Direction on Oracle SCM declares the product ‘dead as a dodo’. Well, not quite. …
Oracle Designer/Oracle SCM Meta Model
This post – or rather its comments – contain some investigations into the Designer 9i/10g Meta Model and Meta Meta Model. That is: the tables that contain the definitions …
Tools for Automated Checking of Java Coding Standards
Automated Quality Audit or Standards Enforcement There is a number of tools available for automated standards checking. These tools parse Java source code and determine which standards have been …
Research into Java Development standards
Yesterday I started research into the current state of affairs with regard to coding standards for J2EE development. We are looking for an up to date set of low …
ADF Toystore Demo
Steve Muench published his ADF version of the Toystore Demo: see http://otn.oracle.com/products/jdev/collateral/papers/10g/adftoystore.html. I have not yet tried it out but it should be a comprehensive example of using ADF …
KC Session on ANT
On Tuesday we had a very good session with the Knowledge Center for Web & Java on ANT, the Jakarta “make”-tool. We started with the usual roundup of everyones …
Oracle Data Cartridge – Extending the Database
Oracle Data Cartridge is a technology component, part of the Oracle RDBMS (ever since the 8i release), that allows developers to extend the functionality of the database. One area …
QNXO – Tool for High Quality, high productivity PL/SQL Development
During one of Steven Feuerstein’s presentations at the ODTUG 2004 conference, he demonstrated his new tool call QNXO (pka SWYG). This tool promises higher quality, higher producvity for PL/SQL …