Menu
▾
▴
RE: [Hsqldb-developers] FW: 1.8.0.4 seems to have some problems.
|
From: Andy C. <ach...@vi...> - 2006-04-27 21:00:55
|
Fine I've read the manual now for a topic I'd previously read and understood.. I also read the readme prior to asking the questions - I don't recall seeing a " Everybody who has an existing application running in server mode needs to change their launch commands or not upgrade - please re-read the manual" I have it working. I would NOT expect it to not be backward compatible starting at a .04 revision when it was compatible up until 1.8.0.2 As you can see by my commandline below there is absolutely no reason the program couldn't have inferred that what was meant was: @.\jre\bin\java -Xmx128M -Xms32M -Djava.ext.dirs=.\lib org.hsqldb.Server -database file:./LocalRepository -dbname.0 LocalRepository From: hsq...@li... [mailto:hsq...@li...] On Behalf Of fredt Sent: Thursday, April 27, 2006 3:15 PM To: hsq...@li... Subject: Re: [Hsqldb-developers] FW: 1.8.0.4 seems to have some problems. Andrew, Please read the manual. In 1.8.0.x you have BOTH a database and an an alias (for EACH of the databases you want to load, as it does multiple databases). Fred ----- Original Message ----- From: Andrew Chandler <mailto:an...@ri...> To: hsq...@li... <mailto:hsq...@li...> Sent: 27 April 2006 21:02 Subject: RE: [Hsqldb-developers] FW: 1.8.0.4 seems to have some problems. Ok so instead of my former startup script @.\jre\bin\java -Xmx128M -Xms32M -Djava.ext.dirs=.\lib org.hsqldb.Server -database LocalRepository %1 %2 %3 %4 I can do something like @.\jre\bin\java -Xmx128M -Xms32M -Djava.ext.dirs=.\lib org.hsqldb.Server -database ./LocalRepository %1 %2 %3 %4 As long as its in the current directory? _____ From: hsq...@li... <mailto: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. You can specify the database path and alias on the command line to run the server. No installation is required. Fred ----- Original Message ----- From: Andy <mailto:ach...@vi...> Chandler To: hsq...@li... <mailto:hsq...@li...> Sent: 27 April 2006 20:26 Subject: RE: [Hsqldb-developers] FW: 1.8.0.4 seems to have some problems. 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) <snip> From: fredt <fredt@us <mailto:fredt@us> ...> Re: 1.8.0.4 seems to have some problems. 2006-04-23 15:31 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 </snip> 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----- From: hsq...@li... [mailto:hsq...@li... <mailto:hsq...@li...> ] On Behalf Of Nitin Uchil Sent: Tuesday, April 25, 2006 4:22 PM To: hsq...@li... Subject: Re: [Hsqldb-developers] FW: 1.8.0.4 seems to have some problems. I seem to have the same problem running 1.8.0.4 as a webserver on Windows platform (works in version 1.7). The same command works in a Linux environment for 1.8.0.4. On 4/25/06, Andrew Chandler <an...@ri...> wrote: > Reposting since my original post never seemed to come through the > list: > > > ________________________________________ > From: Andrew Chandler [mailto:an...@ri... <mailto:an...@ri...> ] > Sent: Sunday, April 23, 2006 5:24 PM > To: 'hsq...@li...' > Subject: 1.8.0.4 seems to have some problems. > > 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 > you have 1.8.0.4 This same schema will open in embedded mode in > 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 > the command line. The basic symptom with 1.8.0.4 in server mode is the > following: > > C:\testinstall\vna8>localrepository > [Server@1decdec]: [Thread[main,5,main]]: checkRunning(false) entered > [Server@1decdec]: [Thread[main,5,main]]: checkRunning(false) exited > [Server@1decdec]: Startup sequence initiated from main() method > [Server@1decdec]: Loaded properties from > [C:\testinstall\vna8\server.properties] > [Server@1decdec]: Initiating startup sequence... > [Server@1decdec]: Server socket opened successfully in 63 ms. > [Server@1decdec]: [Thread[HSQLDB Server @1decdec,5,main]]: > run()/openDatabases(): > [Server@1decdec]: Initiating shutdown sequence... > [Server@1decdec]: Shutdown sequence completed in 16 ms. > [Server@1decdec]: 2006-04-23 17:15:53.921 SHUTDOWN : System.exit() is called > next > > > Same command, same schema, same directory just copy jar back to 1.8.0.2 and > you get: > C:\testinstall\vna8>localrepository > [Server@1decdec]: [Thread[main,5,main]]: checkRunning(false) entered > [Server@1decdec]: [Thread[main,5,main]]: checkRunning(false) exited > [Server@1decdec]: Startup sequence initiated from main() method > [Server@1decdec]: Loaded properties from > [C:\testinstall\vna8\server.properties] > [Server@1decdec]: Initiating startup sequence... > [Server@1decdec]: Server socket opened successfully in 47 ms. > [Server@1decdec]: Database [index=0, id=0, db=file:LocalRepository <file:///\\LocalRepository> , alias=] > opened sucessfully in 312 ms. > [Server@1decdec]: Startup sequence completed in 375 ms. > [Server@1decdec]: 2006-04-23 17:18:02.968 HSQLDB server 1.8.0 is online > [Server@1decdec]: To close normally, connect and execute SHUTDOWN SQL > [Server@1decdec]: From command line, use [Ctrl]+[C] to abort abruptly > > > > ------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > 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> &kid0709&bid&3057&dat1642 > _______________________________________________ > hsqldb-developers mailing list > hsq...@li... > https://lists.sourceforge.net/lists/listinfo/hsqldb-developers <https://lists.sourceforge.net/lists/listinfo/hsqldb-developers> > -- Nitin Uchil (734)945-6463 ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=k <http://sel.as-us.falkag.net/sel?cmd=k&kid> &kid0709&bid&3057&dat1642 _______________________________________________ hsqldb-developers mailing list hsq...@li... https://lists.sourceforge.net/lists/listinfo/hsqldb-developers <https://lists.sourceforge.net/lists/listinfo/hsqldb-developers> |
