OpenOffice 3.3 with HSQLDB via JDBC

I had developed an application that stored some metrics in a HyperSQL database for offline processing and reporting with OpenOffice. It seemed simple enough - OpenOffice would connect to the database via JDBC, with the JDBC URL and driver class..trouble was, no matter what I did, the driver class would not be recognised! After endlessly searching on the web for a solution, I realised the piece of the puzzle I was missing - the version of the hsqldb jar file. The version 2.0.0 jar appears to be incompatible with OpenOffice 3.3 - Reverting back to 1.8.0.10 solves the problem, and the JDBC driver class is recognised. So I'll publish the process in full here, just in case anyone else runs into the same problem!

»
Author's profile picture Will Dampney on applications

A Quick Spring Security Lock-Down

My new shiny web application is fantastically useful, but only to a certain group of people (i.e. my team), and should only be accessible by them.

»
Author's profile picture Will Dampney on software-development and web-development

Continuous Deployment: Deploying to Glassfish with Maven and TeamCity

The sooner we can deploy a tested and verified piece of software, the better! Here I'm describing an automated deployment process that uses Maven to deploy to a Glassfish application server. TeamCity facilitates the build and test stages, with an additional deployment of the packaged web application. Using the glassfish plugin for maven 2, we can integrate the application server deployment into the continuous integration cycle, and provide a constantly up-to-date development/test environment.

»
Author's profile picture Will Dampney on software-development and continuous-integration

How to load properties files into Spring and expose to the Java classes

The issue:

»
Author's profile picture Will Dampney on software-development

A cyclical dependancy anti-pattern: Identity Theft

Anti-patterns:

In software engineering, an anti-pattern (or antipattern) is a design pattern that appears obvious but is ineffective or far from optimal in practice.1 Or as I like to think of it, the type of code that makes you want to rip your eyes out, like in that movie Event Horizon...

»
Author's profile picture Will Dampney on software-development and code-quality

A simple example of using behavior-driven development with JBehave

In a previous post introducing BDD I outlined a simple bus ticket application. Since then I've been looking at JBehave, and thought I'd try building a simple version of the bus tickets application, using JBehave to support behavior-driven development of the application.

»
Author's profile picture Will Dampney on software-development and code-quality

A brief introduction to Behaviour-Driven Development

Behaviour-Driven Development (BDD) is a methodology developed by agile developer Dan North in 2006.

»
Author's profile picture Will Dampney on software-development and code-quality

Using decimal and numeric input fields in Android

Say I have a measurement field in my app that takes a decimal: android-decimal

»
Author's profile picture Will Dampney on software-development and android