XML Data – To be stored or not to be stored, and beyond…
It is nagging… I got an email from that you are able to download the handouts from ODTUG until half September (download them now, 1/2 September they will be …
Category: Databases
Enqueuing AQ JMS Text Message from PL/SQL on Oracle XE
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' …
Used port numbers by the Oracle OEM agent
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 …
Getting started with JPA mapping : How IntelliJ can map your data with a few clicks
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. …
EclipseLink – Youngest Open Source Project provides venerable Java Software – TopLink’s enterprise level Object Relational and Object XML mapping now open source
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 …
DBConsole 11g (part 2) – Using the SQL Performance Analyzer
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 …
Oracle 11g: New sql.bsq structure
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 …
Four Dutch Experts in ODTUG Kaleidoscope Expert Panel Session
June 19, 2007
AMIS, Databases, Development Tools, IT, Java, Oracle, Software Development, Tools, Web HTML5 CSS3
No Comments
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 …
AMIS Technical Session: A closer look at Oracle Toplink (aka EclipseLink) – donderdag 7 juni, 18.00 uur
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 …
Getting started with Derby – The java database bundled with Java 6
May 24, 2007
Databases, DBA Oracle, Java, Software Development, Tools, Web HTML5 CSS3, Web/Java
1 Comment
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 …
Made to order: Eirik’s Hi-Lo Chart in SQL – extending the SQL Chart Palette (Pie, Stacked Bar Chart, Gauge, Gantt,…)
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 …
Gauge charts in SQL or How to produce the world's ugliest speedometers
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 …
Using the Spring DataBinder to map Strings to objects
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 …
Writing a Word Search puzzle solver in SQL
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, …
Worst practices when using Oracle JDBC Drivers – great presentation by Douglas Surber
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 …
A room full of Oracle ACEs…
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 …
On the false sense of security with PL/SQL based implementation of business rules – and what to do about it
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 …
Unspoiling the demo – Flashback Table and Flashback Query
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 …
EJB 3.0 Java Persistence API – "Refresh After Insert": Using EntityListeners to absorb the effects from Database Triggers
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 …
OWB 10g R2Changing the repositories password disables the Control Center
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 …
Testing Knowledge of Database Performance – Is this a good Execution Plan?
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 …
Using an Oracle database link to connect to Excel
August 4, 2006
Data Warehousing & BI, Database, Databases, Development Tools, Oracle, PL/SQL
5 Comments
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 …
Getting started with Lucene 2.0 A powerful java search engine
July 23, 2006
Databases, Java, Software Development, Tools, Web HTML5 CSS3, Web/Java, XML
4 Comments
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 …
Mastering EJB3.0 – Free PDF Book Download
July 18, 2006
Databases, IT, Java, Oracle WebLogic Server, Software Development, Tools, Web/Java
59 Comments
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 …
Using Lucene with Spring Introduction to Spring Modules
June 26, 2006
Databases, Java, Oracle WebLogic Server, Software Development, Tools, Web HTML5 CSS3, Web/Java
7 Comments
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 …
Verslag van JSpring 2006
June 16, 2006
AMIS, Databases, IT, Java, Software Development, Tools, Web HTML5 CSS3, XML
No Comments
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 …
Building a Route Planner with Oracle SQL – Finding the quickest route in a graph
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 or EXIST or doesn’t it matter
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 …
Map Adventures with Google, Oracle and Spring
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 …
Oracle Toplink goes open source – launch of the Community Edition
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 …
Installing Oracle Grid Control 10 release 2 on SuSE 9.3 ES
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 …
Workshop on EJB 3.0 Persistence – Download Resources
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 – …
JDBC Rowset
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 …
The Next Value – How much higher is my salary than the next in (Dense) Rank – Oracle Analytical Functions
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 …
Find the number of descendant nodes in a SQL query – how many employees work (indirectly) for me? And what do they earn on average?
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 …
Cost Based Optimizing through time travel? – the value of meta-data for enabling Query Rewrite
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 …
Aggregating in SQL across multiple levels and along several dimensions using ROLLUP and GROUPING SETS
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 …
Oracle 7Up to 10g – How time flies… Training for seasoned Oracle SQL and PL/SQL Developers
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 …
Defining Defaults – there is more to it than you think
… 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 …
Design Patterns in PL/SQL – Implementing the Observer Pattern
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 …