HSQLDB WebServer Component for Coldfusion 'n four steps Q & A

 The service assumes you are on a shared host and have no control, so I would go   
 ahead and add the jar file to any lib folder and refresh coldfusion. 

hsqldb.jar

1. The interface just talks to the CFC. 
2. You can manage on any number of levels via the cfml page inside 
   < cfquery tag or via an applet or CF administrator 

 Once you done talking to the CFC you can add a datasource CF 
 administrator by picking “other” and fill in the info 

 The CFC adds hsqldb.jar at runtime to the classpath and can add a datasource   
 just like the CF administrator.  

  The CFC creates a new Web Server which can contain the applet to manage   
  database.  

For example I just created a new webserver which points to a folder above 
the coldfusion web root. 

C:\CFusionMX7\wwwroot\hsqldb\

  Inside that folder contains 4 files test_database.lck,  
  test_database.properties,test_database.log and default.html 
  which is just a text file which has 

<
applet name="DatabaseManagerSwing" 
       code="org.hsqldb.util.DatabaseManagerSwing"   
       archive="hsqldb.jar"
       codeBase="http://localhost:YOUR_NEW_PORT/" height="500" width="700"      
       align="Left">

  After that its pure SQL the rest of the way. 


Dan Plesse
dan . plesse @ gmail . com