Blogging Roller

I'm messing around with HSQLDB because I need to create an easy-to-install demo-only version of Roller. I want to bundle everything needed to run Roller and make it drop-dead simple to try Roller on your own machine. All that you, the potential Roller user, will have to do is to unzip the distribution file and run a startup script.

To make this work I need Roller, a database, and a Web app server, all bundled together into one downloadable file. That is easy to do: I start with a Tomcat distribution and drop Roller into the webapps directory. When Tomcat starts, Roller will start. Roller won't function without a database, so I need to add the tiny pure-Java HSQLDB database to the mix. I need to get HSQLDB started before Roller starts. This part is not so easy: after looking at the HSQLDB docs I found that I have at least three options:

1. Use the "in-memory" version of HSQLDB. With this approach, no HSQLDB starter is necessary. If you use a JDBC connect string of the form jdbc:hsqldb:filepath instead of the normal jdbc:hsqldb:hsql://host:port form, then HSQLDB will start itself inside your process (is that cool - or what!). The problem with this approach is that it requires the person who installs my demo to edit a file - they have to set the path to the HSQLDB, or I have to rely on an unreliable relative path. Another problem is that, in this mode, HSQLDB will not accept JDBC connections from other clients - such as the HSQLDB database manager.


2. Add a ServletContextListener to Roller that starts the "standalone" server version of HSQLDB on it's own thread when my Web app starts, on contextInitialized(), and shuts down when my Web app stops, on contextDestroyed(). There are a couple of problems with this approach. First, I don't want to add anything to Roller. Second, I want the database to be available for other Web apps - like JSPWiki which I will include in the demo - to do authentication. Finally, after some experimentation I could not get HSQLDB starting ServletContextListener to start before the other parts of Roller that need a database connection.


3. Add a LifecycleListener to the Tomcat server.xml to start the "standalone" server verion of HSQL on it's own thread when Tomcat starts. To enable this, I also add some -D startup parameters to catalina.sh to tell my listener where the database file is and what port to use.

import org.apache.catalina.Lifecycle;
import org.apache.catalina.LifecycleEvent;
import org.apache.catalina.LifecycleListener;
import org.roller.util.HSQLDBUtility;

public class TomcatHSQLDBPlugin implements LifecycleListener {
   public void lifecycleEvent(LifecycleEvent event) {		
      if (event.getType().equals(Lifecycle.START_EVENT)) {
         HSQLDBUtility.start();
      }
      else if (event.getType().equals(Lifecycle.STOP_EVENT)) {
         HSQLDBUtility.stop();
      }
      else {
         System.out.println(getClass().getName()+": Not handling LifecycleEvent: "+event.getType());
      }
   }
}

To plug-in to the Tomcat startup and shutdown process, I had to do two things. First, I placed a jar with my TomcatHSQLDBPlugin and HSQLDBUtility classes in a jar in tomcat/server/lib. Second, I added the following XML to the tomcat/conf/server.xml file along side the listeners already in the file:

    <Listener className="org.roller.tomcat.TomcatHSQLDBPlugin" debug="0"/>

That's that. I've got this stuff working now. Next up: JSPWiki integration and then I'll make Roller-Demo available for download on SourceForge.

I'll be at JavaOne this year, my first time ever. I haven't been to a real conference or to San Franciso in a couple of years, so I am pretty excited about the whole deal. I'm looking forward to meeting the Java bloggers, too. For example, I've never met Matt Raible or Russell Beattie or Simon Brown, or any of the other Java bloggers and I hope to change that next week. I also hope to hook up with some of the Sun Bloggers to talk about Roller at Sun. Along those lines: Atlassian is organizing a meetup that looks to be interesting.

I noticed that MyEclipse now supports Eclipse 3.0 RC1, so I downloaded both last night. I must say, I'm impressed. Eclipse looks and feels much better than before on the Mac. Font sizes are reasonable and the theme looks better in some way, but I can't quite put my finger on exactly what it is. Code folding is sweet!

I found an interesting article on Embedding HSQLDB in Eclipse, but what I really want to do is to embed HSQLDB in Tomcat. Is there an easy way to add a "lifecycle" plugin to Tomcat so that HSQLDB is started by Tomcat startup and shutdown by Tomcat shutdown .

Testing Roller 0.9.9.1.

Joel Spolsky Microsoft took over the browser market fair and square by making a better product, but they were so afraid that Web-based applications would eliminate the need for Windows that they locked the IE team in a dark dungeon and they haven't allowed improvements to IE for several years now.