Re: Server mode fials on Mac OS

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 <[email protected]> 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$ [Server@5305068a]: [Thread[main,5,main]]: checkRunning(false) entered
  [Server@5305068a]: [Thread[main,5,main]]: checkRunning(false) exited
  [Server@5305068a]: Startup sequence initiated from main() method
  [Server@5305068a]: Could not load properties from file
  [Server@5305068a]: Using cli/default properties only
  [Server@5305068a]: Initiating startup sequence...
  [Server@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)
  [Server@5305068a]: Initiating shutdown sequence...
  [Server@5305068a]: Shutdown sequence completed in 4 ms.
  [Server@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
  [email protected]

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

  _______________________________________________
  Hsqldb-user mailing list
  [email protected]
  https://lists.sourceforge.net/lists/listinfo/hsqldb-user





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



--------------------------------------------------------------------------------
_______________________________________________
Hsqldb-user mailing list
[email protected]
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

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

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user