When doing integration testing or fixing a bug in a piece of Java code that uses Oracle as a database, being able to do quick exports and imports of your schema can be a big help. Sometimes just calling Oracle's imp/exp commandline tools from your code can be of help, but I was looking for something a bit more portable …

After reading my last blogpost on Anonimatron, you must have asked yourself "Great, but how do I actually use Anonimatron to de-personalize my database"? I tried my best to make basic Anonimatron configuration as self-explanatory as possible, just start it without any command line arguments and it will tell …

This year's Dutch Java Nerd event called J-Fall was held in Nijkerk, in a beautiful location called "Hart van Holland" . With plenty of sessions by speakers from all over the world it promised to be a great day for Java enthusiasts, at a great location for meeting friends and colleagues. I took a day off from …

At work, we have two applications which connect to the same database. For all kinds of business reasons, we need to make sure that only one of the applications accesses certain data at the same time. To do this, we use a row in a table as a semaphore. While working on the locking mechanism, we had a closer look at the …

If you're a SQuirreL SQL fan like me, and you use a Mac, you probably also want to know how to add a driver to the OSX version of the application. Most people just point to an external jar file, but you can also add drivers to the application bundle. There's not much to it, but it took me some time to discover that I …

At work, we've got two Oracle databases and a Java web application. One of the tasks of the web application is to copy tables over from one database to the other. Last week we ran into a funny problem which turns out to be an Oracle bug. I've posted a question about this last week on stackoverflow.com but it seems that …

Does Oracle complain about not being able to drop a table for a currently connected user, but you are sure you disconnected? Do the sessions "hang" in "inactive" state? Just log on as system, and execute the following query: SELECT 'ALTER SYSTEM KILL SESSION ''' || sid || ',' || serial# || '''; --', …