> What I'd like to see is if someone managed to run hsql along with the web > applications, inside *one* VM, instead of running the two VMs. You can actually run hsql inside one VM, although with some caveats. For development, I run hsql in client-server mode. If my 'test' database was in c:\test, I'd start it up like: runServer -database c:\db\test and would connect to it using the following jdbc connection string: jdbc:HypersonicSQL:hsql://localhost The nice thing about running it in client-server mode is that I can make multiple connections to the database (ie orion and the DatabaseManager) Or, you can run hsql in the same VM as Orion, if you run it in standalone mode. You can use the exact same database as above, but change the jdbc connection string to: jdbc:HypersonicSQL:c:\db\test Note that there can only be one connection to hsql when it is running in standalone mode, so if you want to run the DatabaseManager, you'll have to shut down Orion. HypersonicSQL is a pretty useful database for basic applications. Anything serious and I'd move to Oracle, but for simple apps it does the job. Darren. -- Darren Gibbons [EMAIL PROTECTED] OpenRoad Communications ph: 604.681.0516 Internet Application Development fax: 604.681.0916 Vancouver, B.C. http://www.openroad.ca
