Menu
▾
▴
Re: [Hsqldb-developers] FW: 1.8.0.4 seems to have some problems.
|
From: fredt <fr...@us...> - 2006-04-27 20:15:34
|
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 -----=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.
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
|
