Dave Johnson on open web technologies, social software and software development
« JavaOne! | Main | Python development... »
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:
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.
Dave Johnson in Roller
01:30PM Jun 23, 2004
Comments [4]
Tags:
Roller
« JavaOne! | Main | Python development... »
This is just one entry in the weblog Blogging Roller. You may want to visit the main page of the weblog
Below are the most recent entries in the category Roller, some may be related to this entry.
Posted by Glen Stampoultzis on June 25, 2004 at 01:06 AM EDT #
Hi Dave, I've been trying to do something very similar today, unfortunately I couldn't find your HSQLDBUtility anywhere under the Roller CVS.. might have saved a little legwork. I used a slightly more generic context listener; it's a bit rough around the edges esp. the delay before creating the schema but by the book I've only today left to finish this project. Any ideas? glaring mistakes?
- RichardPosted by Richard Osbaldeston on June 25, 2004 at 04:19 PM EDT #
Posted by Herman on July 05, 2004 at 12:55 PM EDT #
Posted by blackbird on July 06, 2004 at 06:51 PM EDT #