[Hsqldb-user] Server mode fials on Mac OS

Discussion:

Bayless Kirtley

2016-12-01 02:55:36 UTC

My program has run for over a year on Windows 7 and 10. Now the client wants to switch to Apples.
This is the food pantry I mentioned a year ago, my charity project. I have a hsqldb database, version
2.3.3, that runs in server mode. The computer is running the latest OS and Java 8u111. I try to start
the database with this command.

java âcp dist/lib/hsqldb.jar org.hsqldb.server.Server âdatabase.0 file:DBData/MDFP âdbname.0 Meals

This is identical to the command on Windows and the directory structure is correct and the same on both
computers. I get the following response.

[1] 3736
MDFPs-iMac:MDFP mdfoodpantry$ [***@5305068a]: [Thread[main,5,main]]: checkRunning(false) entered
[***@5305068a]: [Thread[main,5,main]]: checkRunning(false) exited
[***@5305068a]: Startup sequence initiated from main() method
[***@5305068a]: Could not load properties from file
[***@5305068a]: Using cli/default properties only
[***@5305068a]: Initiating startup sequence...
[***@5305068a]: [Thread[HSQLDB Server @5305068a,5,main]]: run()/operServerSocket():
java.net.bindException: Address already in use (Bind failed)
at java.net.PlainSocketImpl.socketBind(Native Method)
at java.net.AbstractPlainSocketImpl.bind(AbstractPlainSocketImpl.java:387)
at java.net.ServerSocket.bind(ServerSocket.java:375)
at java.net.ServerSocket<init>(ServerSocker.java:237)
at java.net.ServerSocket<init>(ServerSocker.java:128)
at org.hsqldb.server.HsqlSocketFactory.createServerSocket(Unknown Source)
at org.hsqldb.server.Server.openServerSocket(Unknown Source)
at org.hsqldb.server.Server.run(Unknown Source)
at org.hsqldb.server.Server.access$000(Unknown Source)
at org.hsqldb.server.Server$ServerThread.run(Unknown Source)
[***@5305068a]: Initiating shutdown sequence...
[***@5305068a]: Shutdown sequence completed in 4 ms.
[***@5305068a]: 2016-11-30 20:18:51.925 SHUTDOWN : System.exit() is called next

With that, the database is not running. I have a related database for the same client that runs embedded
and all seems to be fine with it. The programs were developed under Netbeans on a Windows computer
and transferred to the Mac. I also have recompiled under Netbeans on the Mac and get the same result.
I am not a Mac guru and donât have any idea what could be wrong here.

Any advice or help will be greatly appreciated.
Bayless
***@cox.net

Blaine Simpson

2016-12-01 03:32:39 UTC

Permalink

It says that something else is using the port, so check for something else
listening on port 9001.

Post by Bayless Kirtley
My program has run for over a year on Windows 7 and 10. Now the client
wants to switch to Apples.
This is the food pantry I mentioned a year ago, my charity project. I have
a hsqldb database, version
2.3.3, that runs in server mode. The computer is running the latest OS
and Java 8u111. I try to start
the database with this command.
java âcp dist/lib/hsqldb.jar org.hsqldb.server.Server âdatabase.0
file:DBData/MDFP âdbname.0 Meals
This is identical to the command on Windows and the directory structure is
correct and the same on both
computers. I get the following response.
[1] 3736
checkRunning(false) entered
java.net.bindException: Address already in use (Bind failed)
at java.net.PlainSocketImpl.socketBind(Native Method)
387)
at java.net.ServerSocket.bind(ServerSocket.java:375)
at java.net.ServerSocket<init>(ServerSocker.java:237)
at java.net.ServerSocket<init>(ServerSocker.java:128)
at org.hsqldb.server.HsqlSocketFactory.createServerSocket(Unknown Source)
at org.hsqldb.server.Server.openServerSocket(Unknown Source)
at org.hsqldb.server.Server.run(Unknown Source)
at org.hsqldb.server.Server.access$000(Unknown Source)
at org.hsqldb.server.Server$ServerThread.run(Unknown Source)
With that, the database is not running. I have a related database for the
same client that runs embedded
and all seems to be fine with it. The programs were developed under
Netbeans on a Windows computer
and transferred to the Mac. I also have recompiled under Netbeans on the
Mac and get the same result.
I am not a Mac guru and donât have any idea what could be wrong here.
Any advice or help will be greatly appreciated.
Bayless
------------------------------------------------------------
------------------
_______________________________________________
Hsqldb-user mailing list
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

Bayless Kirtley

2016-12-01 14:01:13 UTC

Permalink

Thanks Blaine. Thatâs what I suspected. This is a clean Mac with only the OS and what software came with it.
Since I donât really know anything about Mac OS, can I tell hsqldb to use another port?

Bayless

From: Blaine Simpson
Sent: Wednesday, November 30, 2016 9:32 PM
To: User discussions about HyperSQL Database Engine.
Subject: Re: [Hsqldb-user] Server mode fials on Mac OS

It says that something else is using the port, so check for something else listening on port 9001.

On Wed, Nov 30, 2016 at 9:55 PM, Bayless Kirtley <***@cox.net> wrote:

My program has run for over a year on Windows 7 and 10. Now the client wants to switch to Apples.
This is the food pantry I mentioned a year ago, my charity project. I have a hsqldb database, version
2.3.3, that runs in server mode. The computer is running the latest OS and Java 8u111. I try to start
the database with this command.

java âcp dist/lib/hsqldb.jar org.hsqldb.server.Server âdatabase.0 file:DBData/MDFP âdbname.0 Meals

This is identical to the command on Windows and the directory structure is correct and the same on both
computers. I get the following response.

[1] 3736
MDFPs-iMac:MDFP mdfoodpantry$ [***@5305068a]: [Thread[main,5,main]]: checkRunning(false) entered
[***@5305068a]: [Thread[main,5,main]]: checkRunning(false) exited
[***@5305068a]: Startup sequence initiated from main() method
[***@5305068a]: Could not load properties from file
[***@5305068a]: Using cli/default properties only
[***@5305068a]: Initiating startup sequence...
[***@5305068a]: [Thread[HSQLDB Server @5305068a,5,main]]: run()/operServerSocket():
java.net.bindException: Address already in use (Bind failed)
at java.net.PlainSocketImpl.socketBind(Native Method)
at java.net.AbstractPlainSocketImpl.bind(AbstractPlainSocketImpl.java:387)
at java.net.ServerSocket.bind(ServerSocket.java:375)
at java.net.ServerSocket<init>(ServerSocker.java:237)
at java.net.ServerSocket<init>(ServerSocker.java:128)
at org.hsqldb.server.HsqlSocketFactory.createServerSocket(Unknown Source)
at org.hsqldb.server.Server.openServerSocket(Unknown Source)
at org.hsqldb.server.Server.run(Unknown Source)
at org.hsqldb.server.Server.access$000(Unknown Source)
at org.hsqldb.server.Server$ServerThread.run(Unknown Source)
[***@5305068a]: Initiating shutdown sequence...
[***@5305068a]: Shutdown sequence completed in 4 ms.
[***@5305068a]: 2016-11-30 20:18:51.925 SHUTDOWN : System.exit() is called next

With that, the database is not running. I have a related database for the same client that runs embedded
and all seems to be fine with it. The programs were developed under Netbeans on a Windows computer
and transferred to the Mac. I also have recompiled under Netbeans on the Mac and get the same result.
I am not a Mac guru and donât have any idea what could be wrong here.

Any advice or help will be greatly appreciated.
Bayless
***@cox.net

------------------------------------------------------------------------------

_______________________________________________
Hsqldb-user mailing list
Hsqldb-***@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

--------------------------------------------------------------------------------
------------------------------------------------------------------------------

--------------------------------------------------------------------------------
_______________________________________________
Hsqldb-user mailing list
Hsqldb-***@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

--------------------------------------------------------------------------------

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2016.0.7924 / Virus Database: 4664/13513 - Release Date: 11/30/16

Blaine Simpson

2016-12-01 14:21:53 UTC

Permalink

See server.port setting at
http://hsqldb.org/doc/2.0/guide/listeners-chapt.html#lsc_server_props

Thanks Blaine. That’s what I suspected. This is a clean Mac with only the OS and what software came with it.
Since I don’t really know anything about Mac OS, can I tell hsqldb to use another port?
Bayless
It says that something else is using the port, so check for something else listening on port 9001.

Post by Bayless Kirtley
My program has run for over a year on Windows 7 and 10. Now the client wants to switch to Apples.
This is the food pantry I mentioned a year ago, my charity project. I have a hsqldb database, version
2.3.3, that runs in server mode. The computer is running the latest OS and Java 8u111. I try to start
the database with this command.
java –cp dist/lib/hsqldb.jar org.hsqldb.server.Server –database.0 file:DBData/MDFP –dbname.0 Meals
This is identical to the command on Windows and the directory structure is correct and the same on both
computers. I get the following response.
[1] 3736
java.net.bindException: Address already in use (Bind failed)
at java.net.PlainSocketImpl.socketBind(Native Method)
at java.net.AbstractPlainSocketImpl.bind(AbstractPlainSocketImpl.java:387)
at java.net.ServerSocket.bind(ServerSocket.java:375)
at java.net.ServerSocket<init>(ServerSocker.java:237)
at java.net.ServerSocket<init>(ServerSocker.java:128)
at org.hsqldb.server.HsqlSocketFactory.createServerSocket(Unknown Source)
at org.hsqldb.server.Server.openServerSocket(Unknown Source)
at org.hsqldb.server.Server.run(Unknown Source)
at org.hsqldb.server.Server.access$000(Unknown Source)
at org.hsqldb.server.Server$ServerThread.run(Unknown Source)
With that, the database is not running. I have a related database for the same client that runs embedded
and all seems to be fine with it. The programs were developed under Netbeans on a Windows computer
and transferred to the Mac. I also have recompiled under Netbeans on the Mac and get the same result.
I am not a Mac guru and don’t have any idea what could be wrong here.
Any advice or help will be greatly appreciated.
Bayless

------------------------------------------------------------------------------
_______________________________________________
Hsqldb-user mailing list
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------

Bayless Kirtley

2016-12-01 14:31:23 UTC

Permalink

Thanks again. Sorry to be a pest. I should have found that on my own.

-----Original Message-----
From: Blaine Simpson
Sent: Thursday, December 01, 2016 8:21 AM
To: User discussions about HyperSQL Database Engine.
Subject: Re: [Hsqldb-user] Server mode fials on Mac OS

See server.port setting at
http://hsqldb.org/doc/2.0/guide/listeners-chapt.html#lsc_server_props

Thanks Blaine. That’s what I suspected. This is a clean Mac with only the
OS and what software came with it.
Since I don’t really know anything about Mac OS, can I tell hsqldb to use
another port?
Bayless
It says that something else is using the port, so check for something else
listening on port 9001.

Post by Bayless Kirtley
My program has run for over a year on Windows 7 and 10. Now the client
wants to switch to Apples.
This is the food pantry I mentioned a year ago, my charity project. I
have a hsqldb database, version
2.3.3, that runs in server mode. The computer is running the latest OS
and Java 8u111. I try to start
the database with this command.
java –cp dist/lib/hsqldb.jar org.hsqldb.server.Server –database.0
file:DBData/MDFP –dbname.0 Meals
This is identical to the command on Windows and the directory structure
is correct and the same on both
computers. I get the following response.
[1] 3736
checkRunning(false) entered
java.net.bindException: Address already in use (Bind failed)
at java.net.PlainSocketImpl.socketBind(Native Method)
at
java.net.AbstractPlainSocketImpl.bind(AbstractPlainSocketImpl.java:387)
at java.net.ServerSocket.bind(ServerSocket.java:375)
at java.net.ServerSocket<init>(ServerSocker.java:237)
at java.net.ServerSocket<init>(ServerSocker.java:128)
at org.hsqldb.server.HsqlSocketFactory.createServerSocket(Unknown
Source)
at org.hsqldb.server.Server.openServerSocket(Unknown Source)
at org.hsqldb.server.Server.run(Unknown Source)
at org.hsqldb.server.Server.access$000(Unknown Source)
at org.hsqldb.server.Server$ServerThread.run(Unknown Source)
called next
With that, the database is not running. I have a related database for the
same client that runs embedded
and all seems to be fine with it. The programs were developed under
Netbeans on a Windows computer
and transferred to the Mac. I also have recompiled under Netbeans on the
Mac and get the same result.
I am not a Mac guru and don’t have any idea what could be wrong here.
Any advice or help will be greatly appreciated.
Bayless

------------------------------------------------------------------------------
_______________________________________________
Hsqldb-user mailing list
Hsqldb-***@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2016.0.7924 / Virus Database: 4664/13513 - Release Date: 11/30/16

------------------------------------------------------------------------------