Category: Databases
Today I attended – and presented at – the Database Systems 2006 conference – an annual Dutch conference on Database Architecture and Technology, Enterprise Integration and Service Oriented Architectures …
In a previous article, I discussed Dependency Injection (aka Inversion of Control and the Hollywood principle) and more specifically an implementation of Dependency Injection in PL/SQL. In that we …
Frequently our code has dependencies. Some are intrinsic dependencies, like the packages we need to invoke and the type definitions we rely on. Other dependencies are more like configuration …
One of the hottest topics in Java programming right now is probably Aspect Oriented Programming. Made popular by frameworks such as AspectJ and Spring, AOP refers to a new …
This article is the sequel to EJB 3.0 Persistence – Introducing EJBQL 3.0, an introduction to EJB QL from an historical, strategic and functional perspective. In this post I …
For one of our Java projects, I wanted to help a colleague getting started with unit testing. Due to high time pressure, there was a real risk that – …
It becomes stranger and stranger. After bying the open source company InnoBase, Timesten, and others, Oracle now also bought SleepyCat. Oracle also released its own freeware in the form …
It was a rumour – actually one of three: JBoss, SleepyCat and Zend PHP, see our article Is Oracle buying JBoss? Or Zend PHP? Or SleepyCat? Or all of …
This article Oracle’s Open-Source Shopping Spree in Business Week Online suggests that Oracle is involved in serious discussions with JBoss, Zend and SleepyCat about a take over – for …
EJB 3.0 Persistence is a topic that is high on our list. We have written a substantial number of blog articles on it after doing quite some research as …
Gisteren, donderdag 9 februari, hadden we een uitstekende bijeenkomst rondom EJB 3.0 Persistence API. Met z’n 16-en – waarvan twee geïnteresseerde externen – hebben we in goed drie uur …
This article describes a quick route to starting out with the relatively new EJB 3.0 Persistence API from the Eclipse 3.1 IDE. In a subsequent article, I will discuss …
While investigating the relatively new EJB 3.0 Persistence API, I came under the impression that the specification does not cater for Stored Procedures. In general, there seem to be …
EJB QL or Enterprise Java Beans Query Language has been introduced in the EJB 2.0 Specification, back in 2001. For some reason, it never grew on me. I did …
The proper way to start OC4J is sparsely documented by Oracle: To start OC4J in a standalone environment, issue the following command from the j2ee/home/ directory: Â Â Â java -jar …
One of the annotations available to us when specifying the EJB 3.0 Persistence metadata for our Entities is the @Version annotation. The specification states: “The Version annotation specifies the …
I have done a fair bit of Entity Relationship Modeling. It’s one of the things I probably like most about my job. And one of the things in ERD …
Project Raptor, announced and demonstrated at Oracle Open World, this Fall, has now been released (sort of, as it is still an early adopter release). A free download (60Mb) …
Just browsing through my RSS feeds-reader, I stumbled across three very interesting announcements: JSR-220, the Enterprise JavaBean 3.0 specification, has reached Proposed Final Draft status. Programmers should expect that …
There are some major waves in J(2)EE territory captivating much of the focus of the audience at this year’s JavaPolis – and beyond. One undoubtedly is Java Server Faces. …
After the announcement of Oracle XE I got really curious about the possibilities of a free Oracle10g database. OK, it is limited to 4GB and it doesn’t allow things like …
I would not be offended if you were to decide to quickly skip this article. It ain’t much. However, for my current project it proved pretty important, this apparent …
Released on 25th October 2005, Oracle Database 10g Express Edition (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base that’s …
Oracle lite is a very interesting product. As the name indicates, is it a lite version of the Oracle database and thus capable of running on a PDA, laptop …
Today I attended the workshop that Steve Adams is giving in the Netherlands this week. We were with a group of four AMIS employees. The day started in a …
Interesting news on Friday: the Oracle acquisition – the eleventh this year – of Innobase. Innobase? You may very well have never heard of it. Unless you are a …
Yesterday just prior to our AMIS Query on ADF Faces I was talking to Toon Koppelaars about quite something else: the end_date column in tables that contain contiguous records …
Years ago I have read about the package dbms_application_info for the first time. This is a standard supplied package, shipped with every Oracle Database. It can be used to …
It is not yet a production release, but hey: who cares when you see what it contains in terms of new functionality. Apart from the UIX design time support …
Many applications built in the Client/Server era made use of the fact that every end user had his or her own Database User Account and every Database Connection and …
Today one of my colleagues asked me “What again was your query for finding overlaps in a table with periods, demarcated by start_date and end_date. I think he was …
The other day, we had a very interesting debate about the role of the database in (our) Java/J2EE projects and architectures. Should you limit the use of the database …
Spring consists of a number of modules, such as the IoC Container, AOP, MVC, Persistence, DAO and Remoting. These modules are relatively losely coupled: some can be used without …
Sometimes you want to search for Oracle database messages, their meaning or you are in search of specific database event settings. For instance, a long time ago i was …
I just read in a Dutch IT magazine (Computable) about the release of Bizgres 0.7. Bizgres is an open source project: The Bizgres Project (www.bizgres.org), a Greenplum-sponsored, community-supported, open …
My two previous posts discussed presenting data in a tree-like fashion and filtering hierarchical data sets on certain query conditions while still returning a tree-like result set. This post …
Running sql (scripts) from ant using the ant task is quite easy and straight forward. Unfortunately, the ant sql task is not really suited for running pl/sql, e.g. exec …
Just noticed the Windows download of the Oracle 10g Release 2 database (lagging the Linux release by almost a month!). And: it is still a developer preview, not even …
I was triggered by the news item on OC4J on OTN’s homepage, ” Download Oracle Application Server 10g (10.1.3) Developer Preview 4 – including … Oracle Rules” to resume …
Oracle UltraSearch is a web-based search application based on Oracle Text. It can be used to index a wide variety of datasources like websites, databases, files etc. and to …
![Death of the End Date – How LAG and LEAD help fight redundancy]({"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"} "Death of the End Date – How LAG and LEAD help fight redundancy")