Menu
▾
▴
Re: [Hsqldb-developers] FW: 1.8.0.4 seems to have some problems.
|
From: fredt <fr...@us...> - 2006-04-27 22:14:48
|
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.=20
Fred
----- Original Message -----=20
From: Andy Chandler=20
To: hsq...@li...=20
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:
=20
=20
@.\jre\bin\java -Xmx128M -Xms32M -Djava.ext.dirs=3D.\lib =
org.hsqldb.Server -database file:./LocalRepository -dbname.0 =
LocalRepository
=20
=20
=20
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.
=20
Andrew, Please read the manual.
=20
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).
=20
Fred
----- Original Message -----=20
From: Andrew Chandler=20
To: hsq...@li...=20
Sent: 27 April 2006 21:02
Subject: RE: [Hsqldb-developers] FW: 1.8.0.4 seems to have some =
problems.
=20
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
-------------------------------------------------------------------------=
---
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 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=20
> 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=20
> 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=20
> 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, 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=20
> =
http://sel.as-us.falkag.net/sel?cmdlnk&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&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
|
