Re: [Hsqldb-developers] FW: 1.8.0.4 seems to have some problems.

[fredt]

Title: RE: [Hsqldb-developers] FW: 1.8.0.4 seems to have some problems.

Andrew,  I did say "Due to an unintended change in 1.8.0.4, ..". The reference to manual is necessary as your command line is not correct. You need "-database.0", not "-database". Secondly, if you want to use the same URL as before in your client, you need "-dbname.0" without the "LocalDepository" addition.   Fred ----- Original Message ----- From: Andy Chandler To: hsqldb-developers@lists.sourceforge.net Sent: 27 April 2006 21:58 Subject: RE: [Hsqldb-developers] FW: 1.8.0.4 seems to have some problems. 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of fredt Sent: Thursday, April 27, 2006 3:15 PM To: hsqldb-developers@lists.sourceforge.net 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 To: hsqldb-developers@lists.sourceforge.net 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of fredt Sent: Thursday, April 27, 2006 2:47 PM To: hsqldb-developers@lists.sourceforge.net 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 Chandler To: hsqldb-developers@lists.sourceforge.net 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 <[EMAIL PROTECTED]...> 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Nitin Uchil Sent: Tuesday, April 25, 2006 4:22 PM To: hsqldb-developers@lists.sourceforge.net 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 <[EMAIL PROTECTED]> wrote: >        Reposting since my original post never seemed to come through the > list: > > > ________________________________________ > From: Andrew Chandler [mailto:[EMAIL PROTECTED]] > Sent: Sunday, April 23, 2006 5:24 PM > To: '[EMAIL PROTECTED]' > 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 > [EMAIL PROTECTED]: [Thread[main,5,main]]: checkRunning(false) entered > [EMAIL PROTECTED]: [Thread[main,5,main]]: checkRunning(false) exited > [EMAIL PROTECTED]: Startup sequence initiated from main() method > [EMAIL PROTECTED]: Loaded properties from > [C:\testinstall\vna8\server.properties] > [EMAIL PROTECTED]: Initiating startup sequence... > [EMAIL PROTECTED]: Server socket opened successfully in 63 ms. > [EMAIL PROTECTED]: [Thread[HSQLDB Server @1decdec,5,main]]: > run()/openDatabases(): > [EMAIL PROTECTED]: Initiating shutdown sequence... > [EMAIL PROTECTED]: Shutdown sequence completed in 16 ms. > [EMAIL PROTECTED]: 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 > [EMAIL PROTECTED]: [Thread[main,5,main]]: checkRunning(false) entered > [EMAIL PROTECTED]: [Thread[main,5,main]]: checkRunning(false) exited > [EMAIL PROTECTED]: Startup sequence initiated from main() method > [EMAIL PROTECTED]: Loaded properties from > [C:\testinstall\vna8\server.properties] > [EMAIL PROTECTED]: Initiating startup sequence... > [EMAIL PROTECTED]: Server socket opened successfully in 47 ms. > [EMAIL PROTECTED]: Database [index=0, id=0, db=file:LocalRepository, alias=] > opened sucessfully in 312 ms. > [EMAIL PROTECTED]: Startup sequence completed in 375 ms. > [EMAIL PROTECTED]: 2006-04-23 17:18:02.968 HSQLDB 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 > > > > ------------------------------------------------------- > 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&kid0709&bid&3057&dat1642 > _______________________________________________ > hsqldb-developers mailing list > hsqldb-developers@lists.sourceforge.net > 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&kid0709&bid&3057&dat1642 _______________________________________________ hsqldb-developers mailing list hsqldb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hsqldb-developers