Hi Thomas, Just a quick note - I configured the Hypersonic SQL WebServer to use port 81 on the orion host, reconfigured orion to connect to the Hypersonic SQL WebServer URL - it worked no problem - then started the DatabaseManager, connected, no problem. Terrific. I have CCd the Orion-Interest list coz this should be interesting for them too. Kind Regards Neville Burnell Business Manager Software > -----Original Message----- > From: Neville Burnell > Sent: Friday, 31 December 1999 10:58 AM > To: 'Thomas Mueller' > Subject: RE: hSql DatabaseManager & Orion Server > > > Hi Thomas, > > www.orionserver.com is [was?] the correct url - but they seem > to be off the air right now. Y2K biting perhaps?. > > With regards to the Hypersonic SQL WebServer: > > - can I configure the port the hsql webserver is using ? I > would like to run the orion server and the hypersonic server > on the same machine if possible - but I would like orion to > manage the standard http/s ports. > > - can I use the orion web server for the http handling, and > pass the appropriate hsql messages onto the hsql engine in > process ? I know that orion can be configured to pass cold > fusion requests over to the allaire cold fusion engine. > > Kind Regards > > Neville Burnell > Business Manager Software > > > > > -----Original Message----- > > From: Thomas Mueller [mailto:[EMAIL PROTECTED]] > > Sent: Friday, 31 December 1999 10:04 AM > > To: Neville Burnell > > Subject: Re: hSql DatabaseManager & Orion Server > > > > > > Hi Neville > > > > I will check out orionserver, thanks for the information. > But I can't > > find 'www.orionserver.com'; maybe it's another website? > > > > If I understand you correct, then your use case should already > > work, using the client / server mode of Hypersonic SQL. > > > > - Run Hypersonic SQL WebServer on some computer in > > the LAN (for example on 'dbserv') > > - Run Orionserver somewhere in the lan, connect to the database > > using the URL jdbc:HypersonicSQL:http://dbserv > > - Run DatabaseManager (or any other db admin tool) and connect > > also to the URL jdbc:HypersonicSQL:http://dbserv > > > > The WebServer mode is a bit slower than the In-Memory or > > the Standalone mode, should not give a performance problem. > > > > Please tell me if I missunderstood you. > > Thanks > > Thomas > > > > > > Neville Burnell schrieb: > > > > > Hi Thomas, > > > > > > Something out of left field - although I am sure more > > people will want > > > to do this - I have installed orion (www.orionserver.com) > > and configured > > > hsql as a datasource - no problems. What I would like to do > > is run the > > > hsql Database Manager, either as an application or an > > applet, connect to > > > the orion server, and manage a hsql datasource online, > while the ejb > > > services etc are still up. This would enable hot fixes to > > the data while > > > a user was insession, as opposed to either 1) building an > > adhoc app to > > > do adhoc maint, or 2) taking the database off line and using the > > > Database Manager. > > > > > > What do you think ? > > > > > > BTW, well done with hsql - we built an SQL dbengine + gui > tools to a > > > legacy database once, and its demanding work - hsql is > > quite impressive. > > > > > > Kind Regards > > > > > > Neville Burnell > > > Business Manager Software > > >
