|
From: Andrew C. <an...@ri...> - 2006-04-27 20:05:33
|
Ok so instead of my former startup script=20 @.\jre\bin\java -Xmx128M -Xms32M -Djava.ext.dirs=3D.\lib = org.hsqldb.Server -database LocalRepository %1 %2 %3 %4 =20 I can do something like=20 @.\jre\bin\java -Xmx128M -Xms32M -Djava.ext.dirs=3D.\lib = org.hsqldb.Server -database ./LocalRepository %1 %2 %3 %4 As long as its in the current directory? =20 =20 _____ =20 From: hsq...@li... [mailto:hsq...@li...] On Behalf Of = fredt Sent: Thursday, April 27, 2006 2:47 PM To: hsq...@li... Subject: Re: [Hsqldb-developers] FW: 1.8.0.4 seems to have some = problems. =20 You can specify the database path and alias on the command line to run = the server. No installation is required. =20 Fred ----- Original Message -----=20 From: Andy <mailto:ach...@vi...> Chandler=20 To: hsq...@li...=20 Sent: 27 April 2006 20:26 Subject: RE: [Hsqldb-developers] FW: 1.8.0.4 seems to have some = problems. =20 Fred seems to have replied but I didn't get it for some reason (Hsqldb mailing lists are sometimes very sporadic - I saw this through the web interface) =20 <snip>=20 From: fredt <fredt@us...>=20 Re: 1.8.0.4 seems to have some problems. =20 2006-04-23 15:31=20 =20 Due to an unintended change in 1.8.0.4, you need to specify both the = path and the alias for the database in the server.properties file. Fred=20 </snip>=20 =20 This is problematic for me as we do not "install" hsqldb - it just runs = from the current directory when we start it up. Why would the physical path = be needed in the server.properties file? Why isn't "." good enough? -----Original Message-----=20 From: hsq...@li... [mailto:hsq...@li...] On Behalf Of = Nitin Uchil Sent: Tuesday, April 25, 2006 4:22 PM=20 To: hsq...@li...=20 Subject: Re: [Hsqldb-developers] FW: 1.8.0.4 seems to have some = problems.=20 I seem to have the same problem running 1.8.0.4 as a webserver on=20 Windows platform (works in version 1.7).=20 The same command works in a Linux environment for 1.8.0.4.=20 On 4/25/06, Andrew Chandler <an...@ri...> wrote:=20 > Reposting since my original post never seemed to come through = the=20 > list:=20 >=20 >=20 > ________________________________________=20 > From: Andrew Chandler [mailto:an...@ri...]=20 > Sent: Sunday, April 23, 2006 5:24 PM=20 > To: 'hsq...@li...'=20 > Subject: 1.8.0.4 seems to have some problems.=20 >=20 > Hi folks - I seem to have run into a snag. We have a empty hsqldb = database > that works fine with 1.8.0.2 but doesn't start up properly in server = mode if=20 > you have 1.8.0.4 This same schema will open in embedded mode in=20 > dbvisualizer just fine and also in server mode in .1.8.0.2. Finally it = > will start in server mode in 1.8.0.4 as log as I add the "-trace" = option to=20 > the command line. The basic symptom with 1.8.0.4 in server mode is the = > following:=20 >=20 > C:\testinstall\vna8>localrepository=20 > [Server@1decdec]: [Thread[main,5,main]]: checkRunning(false) entered=20 > [Server@1decdec]: [Thread[main,5,main]]: checkRunning(false) exited=20 > [Server@1decdec]: Startup sequence initiated from main() method=20 > [Server@1decdec]: Loaded properties from=20 > [C:\testinstall\vna8\server.properties]=20 > [Server@1decdec]: Initiating startup sequence...=20 > [Server@1decdec]: Server socket opened successfully in 63 ms.=20 > [Server@1decdec]: [Thread[HSQLDB Server @1decdec,5,main]]:=20 > run()/openDatabases():=20 > [Server@1decdec]: Initiating shutdown sequence...=20 > [Server@1decdec]: Shutdown sequence completed in 16 ms.=20 > [Server@1decdec]: 2006-04-23 17:15:53.921 SHUTDOWN : System.exit() is called=20 > next=20 >=20 >=20 > Same command, same schema, same directory just copy jar back to = 1.8.0.2 and=20 > you get:=20 > C:\testinstall\vna8>localrepository=20 > [Server@1decdec]: [Thread[main,5,main]]: checkRunning(false) entered=20 > [Server@1decdec]: [Thread[main,5,main]]: checkRunning(false) exited=20 > [Server@1decdec]: Startup sequence initiated from main() method=20 > [Server@1decdec]: Loaded properties from=20 > [C:\testinstall\vna8\server.properties]=20 > [Server@1decdec]: Initiating startup sequence...=20 > [Server@1decdec]: Server socket opened successfully in 47 ms.=20 > [Server@1decdec]: Database [index=3D0, id=3D0, = db=3Dfile:LocalRepository <file:///\\LocalRepository> , alias=3D]=20 > opened sucessfully in 312 ms.=20 > [Server@1decdec]: Startup sequence completed in 375 ms.=20 > [Server@1decdec]: 2006-04-23 17:18:02.968 HSQLDB server 1.8.0 is = online=20 > [Server@1decdec]: To close normally, connect and execute SHUTDOWN SQL=20 > [Server@1decdec]: From command line, use [Ctrl]+[C] to abort abruptly=20 >=20 >=20 >=20 > -------------------------------------------------------=20 > Using Tomcat but need to do more? Need to support web services, = security?=20 > Get stuff done quickly with pre-integrated technology to make your job easier=20 > Download IBM WebSphere Application Server v.1.0.1 based on Apache = Geronimo > http://sel.as-us.falkag.net/sel?cmdlnk <http://sel.as-us.falkag.net/sel?cmdlnk&kid> = &kid=120709&bid&3057&dat=121642=20 > _______________________________________________=20 > hsqldb-developers mailing list=20 > hsq...@li...=20 > https://lists.sourceforge.net/lists/listinfo/hsqldb-developers=20 >=20 =20 --=20 Nitin Uchil=20 (734)945-6463=20 =20 -------------------------------------------------------=20 Using Tomcat but need to do more? Need to support web services, = security?=20 Get stuff done quickly with pre-integrated technology to make your job easier=20 Download IBM WebSphere Application Server v.1.0.1 based on Apache = Geronimo=20 http://sel.as-us.falkag.net/sel?cmd=3Dk <http://sel.as-us.falkag.net/sel?cmd=3Dk&kid> = &kid=120709&bid&3057&dat=121642=20 _______________________________________________=20 hsqldb-developers mailing list=20 hsq...@li...=20 https://lists.sourceforge.net/lists/listinfo/hsqldb-developers=20 |