The problem with running hsqldb inside coldfusion was object persistence. Running a pure java script inside a java web service may just allow objects to persist on a permanent basis.
The problem with java web services you can only get text back unless you use a classloader and pull the class inside coldfusion. The next test is saving objects inside hsqldb memory table remotely and seeing if these objects work locally on a shared host. I am not obsessed with anything. I just think of things and experiment, which we all should be doing. On 8/26/06, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > > 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:251148 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
