Category: Databases
Today I was configuring a message driven bean to listen to an AQ queue. The tutorials and examples I found had me create the queue like this: dbms_aqadm.create_queue_table( queue_table=>'MY_QUEUE_TABLE' …
This is definitly a post worthy as one of the members of the BAAG. The work was extensive (setup, config, install, checking) and afterwards the outcome could have been …
With JPA, there finally is an ORM standard and every major IDE has support for it. Today I will show you how to map your data with IntelliJ IDEA. …
Some months ago, Oracle announced its plans to donate the high end Object Relational Mapping Framework TopLink to the open source community. To be more specific: under the EclipseLink …
Now straight into the more interesting Oracle 11g features. Let's start using the SQL performance Analyzer and doing so make use of Replay. The Performance section of the DBConsole …
Probably one of the oldest database scripts around is the sql.bsq file. First comments described in the heading of this file date from 1994 (“anori – 11/17/94 – ADT …
From different posts on this blog it should be clear by now: the ODTUG Kaleidoscope conference has taken off. I am writing this post as I am attending the …
Oracle and Java are two of the main areas of our (at AMIS) expertise. They come together in many different ways, but particularly in Oracle Toplink. Peter Ebell, a …
I often need a database to perform some quick tests. I usually start my Oracle instance. This takes some time and for most things it’s overkill. So a database …
With the series on SQL based Charts, I can now safely commit any crime in the firm knowledge that an insanity plea will undoubtedly be accepted. After spending way …
I may be at JavaOne 2007, the important work still has to go on. Hence the latest in a series of SQL powered charts and graphs: the Gauge or …
The Spring DataBinder is not only useful to bind request parameters, you can also use the DataBinder on other parameters, like command line arguments, JSON objects coming from an …
Brace yourself for yet another pretty useless demonstration of the unexpected wonders of SQL as well as my apparent lack of meaningful things to do with my life. Undoubtedly, …
I just came out of – well actually, as I am writing this down I am still in it – a very good session on the Oracle JDBC drivers …
Last night we had the annual Oracle ACEs dinner at a very nice San Francisco restaurant. The food and wine were excellent, but the company even more inspiring. I …
Building applications in our corner of the world typically revolves around databases. The most important bit about an application is not the application, but rather the data it creates …
The Whoops experience again. While preparing demos for OOW 2006, I did one update – or rather one commit – too many. I had assigned all employees to the …
While preparing an article for JDJ as well as a presentation for Oracle Open World next week, I finally got round to finding a proper solution for a challenge …
If you change the password of the repository owner in Oracle Warehouse Builder 10g Release 2, the Control Center Service will fail to start. It is unusual that Oracle …
Database Performance Analysis and Tuning of queries and Database Design have never been my specialty. As of late, I have been reading a lot in this area, on Wait …
Recently I had to extract data from 5 Access databases and 4 Excel files and merge the data into an Oracle table. One method was to export the data from Access to Oracle via …
Lucene is a text search engine written in Java. It’s very easy to use (for both developers and users) and fast. The creator of Lucene (Doug Cutting) started with …
Theserverside is offering a free copy of Mastering EJB3.0. Published in July 2006, the best selling book Mastering EJB is now in its fourth edition and has been updated …
While preparing a Lucene presentation and workshop I came across Spring Modules. It’s a small set of libraries that does things the Spring-way. It isn’t included in Spring because …
JSpring vond net als JFall van afgelopen jaar weer plaats in de Reehorst in Ede, een mooie locatie en vooral goed bereikbaar met de auto. Er stonden weer diverse …
Routeplanners have always been somewhat magical in my eyes. Finding the quickest route from A to B in a graph of thousands of points and connections. I have tried …
In my previous post about package constants I mentioned the application I am working on right now. They gave me the task to speed up the application since performance …
In summer 2000 I started in the Field Service development team of Oracle’s eBusiness Suite (http://www.oracle.com/applications/service/srvonl_cont.html). The web form Dispatch Center contains four Java applets. One of them is …
I just noticed the Toplink Essentials JPA (java Persistence API or EJB 3.0 Persistence) homepage on OTN: http://www.oracle.com/technology/products/ias/toplink/jpa/index.html . As you probably already know, Oracle has open sourced a …
With all those fancy plug-ins for Microsoft tools release 2 of Oracle Grid Control 10g seems to be a must-have. However, according to many postings on the internet, installation …
Yesterday we had a very enjoyable and I think interesting workshop on EJB 3.0 Persistence. After a very nice dinner on our terrace – it was lovely weather – …
Do you still think the only way to retrieve data from the database is to use the java.sql.ResultSet? Try the new (hum) javax.sql.RowSet. One of the coolest features is …
It is not terribly important. But since I found the solution, I thought I’d share it with you anyway. During our Oracle 7Up workshop on SQL last week we …
Every once in a while you run into a SQL challenge that seems extremely simple at first glance and turns out to be not so very simple when you …
Query Rewrite is an increasingly more important feature of the Oracle database. Linked intimately to Materialized Views, Query Rewrite is used by the CBO to make queries leverage intermediate …
In preparation for the Oracle 7Up Workshop as well as the Oracle Quiz – The Water is Still Burning (presentation and paper) with Alex for the ODTUG 2006 conference …
With the advent of the Oracle 7 RDBMS – 1993 – a new era dawned. Many of the key database functions and facilities, such as (Enforced) Integrity Constraints, Stored …
… well, at least than I thought. Specifying default values for columns in our database tables seems like a pretty simple and straightforward task. The default is either a …
Next in my series on Design Patterns and their implementation in PL/SQL – also see previous articles on Dependency Injection of Values, Dependency Injection of Interfaces and the Template …
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 …