Getting Xplanner working

Xplanner is a project planning and tracking tool for agile development teams, which we’ve been recommended to use at work. The only problem is, no-one seems to have done any work on it since 2006, and it only officially works in jdk 1.4, and some old version of Tomcat. Our server runs PostgreSQL 8, Tomcat 5.5 and jdk 1.6. One of the main problems we had was that the automatic migration process did not seem to work for Postgres. This is what I did to get it to work:

  1. Downloaded version 0.7b4. Amended to point to the postgres database. Used ant to install the database.
  2. Downloaded version 0.7b7. Followed installation instructions.
  3. Patched the database myself. The scripts are in  WEB-INF\classes\patches. I had to amend them to work with Postgres (e.g. datetime -> timestamp, tinyint -> boolean). I only had to run the later ones.
  4. Deleted the patch scripts
  5. Deleted the file \WEB-INF\classes\com\technoetic\xplanner\upgrade\CleanUpNoteTableConstraints.class as it didn’t seem to like this either.
  6. Followed these instructions:

And after all that, it seems to work, phew!