You are obsessed with hsqldb :-)
"This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Dan Plesse To: CF-Talk Sent: Sat Aug 26 10:44:26 2006 Subject: hsqldb webserver inside a coldfusion jws example The general idea is that if the process is started inside jws then it's outside the application and session scopes so it will not time out. <cfset MyWebServerTest = CreateObject("webservice", " http://localhost:8500/MyWebServerTest3.jws?wsdl")> <cfset MyWebServerTest.MyWebServerTest3()> JWS hsqldb statup [EMAIL PROTECTED]: [Thread[web-62,5,web]]: setTrace(true) [EMAIL PROTECTED]: [Thread[web-62,5,web]]: checkRunning(false) entered [EMAIL PROTECTED]: [Thread[web-62,5,web]]: checkRunning(false) exited [EMAIL PROTECTED]: [Thread[web-62,5,web]]: setAddress(localhost) [EMAIL PROTECTED]: [Thread[web-62,5,web]]: setSilent(true) [EMAIL PROTECTED]: Initiating startup sequence... [EMAIL PROTECTED]: Server socket opened successfully in 31 ms. [EMAIL PROTECTED]: Database [index=0, id=0, db=file:C:\CFusionMX7\wwwroot\hsqldb\test_database, alias=optical_alert_jws] opened sucessfully in 1297 ms. [EMAIL PROTECTED]: Startup sequence completed in 1328 ms. [EMAIL PROTECTED]: 2006-08-26 03:34:01.609 HSQLDB web server 1.8.0 is online [EMAIL PROTECTED]: To close normally, connect and execute SHUTDOWN SQL [EMAIL PROTECTED]: From command line, use [Ctrl]+[C] to abort abruptly It looks like I get a get a few more threads if I start it up inside JWS. MyWebServerTest3.jws import org.hsqldb.WebServer; public class MyWebServerTest3 { public WebServer MyWebServer = null; public String MyWebServerTest3() { WebServer MyWebServer = new WebServer(); MyWebServer.setTrace(true); MyWebServer.setAddress("localhost"); MyWebServer.setSilent(true); MyWebServer.setPort(5220); MyWebServer.setDatabaseName(0,"Optical_Alert_JWS"); MyWebServer.setWebRoot("C:\\CFusionMX7\\wwwroot\\hsqldb\\"); MyWebServer.setDefaultWebPage("default.html"); MyWebServer.setDatabasePath (0,"file:C:\\CFusionMX7\\wwwroot\\hsqldb\\Optical_Alert_JWS"); MyWebServer.setNoSystemExit(true); MyWebServer.setRestartOnShutdown(false); MyWebServer.start(); return "ok"; } } ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251134 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4