From the monthly archives:

October 2008

URI “file:./” is not hierarchical

October 26, 2008

Just recently I came across the following exception when deploying a simple Grails application to Tomcat:
URI “file:./” is not hierarchical
The application was so simple and ran locally on tomcat-6.0.16 - it had to be something environmental. Comparing the differences between machines showed that it was the JVM that was different.
The JVM that produced the error [...]

Read the full article →

Somewhere to put the code

October 20, 2008

I’ve written a lot of code in the past, and lost a lot of code over the years too. To prevent losing anymore and to help organise things, I’ve set up a repository at http://code.google.com/p/javathinking/source/browse/#svn/trunk.
There’s not a lot there at the moment, just a linux script to extract the audio from an MP4, and a [...]

Read the full article →

ST_Intersects performance

October 18, 2008

I was just using a query which made use of the ST_INTERSECTS function:

select * from table1 where st_intersects(st_point( ?, ?, 1),shape)=1

With the data I had, this query took 30 seconds! Before launching into an investigation to find out why, I just decided to swap the parameters - this made all the difference:

select * from table1 [...]

Read the full article →

Finding table differences in Oracle

October 10, 2008

Often there is a need to compare two databases and see the differences. I come across this a lot when releasing a new build into an existing environment - the new code runs on the development database, but the test environment needs a schema upgrade before the code will run.
There are tools that will compare [...]

Read the full article →