StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>The default port for hsqldb is 9001 </p> <p>Run <code>netstat -an</code> check to see if there is something is LISTENING on port 9001</p> <p><code>netstat -an | grep LISTENING</code> to check for all servers listening for incoming connections</p> <p><code>netstat -an | grep 9001</code> to check for a specific port number.</p> <p>If there is something already there then the new of hsqldb that you are trying to start will fail to <a href="http://en.wikipedia.org/wiki/Berkeley_sockets#Socket_API_functions" rel="nofollow noreferrer">bind a socket</a> to the 9001 port.</p> <p>On Windows 7 you can run <a href="http://technet.microsoft.com/en-us/sysinternals/bb897437" rel="nofollow noreferrer">TCPView</a> to see what process is currently listening on the "overcrowded" port. Then it's a matter of deciding to terminate that process which is using 9001 or reconfiguring hsqldb and your client application to use a different (unused) port. </p> <p>It is possible to change the port that hsqldb listens on using the --port XXXX, where XXXX is the new port number. </p> <p>Also from the <code>java -cp ./lib/hsqldb.jar org.hsqldb.Server --help</code> output...</p> <pre><code>The server looks for a 'server.properties' file in the current directory and loads properties from it if it exists. Command line options override those loaded from the 'server.properties' file. </code></pre> <p>There are other possible causes of this error so it would be useful to know what operating system the hsqldb is running on.</p> <p>Failure to bind to a socket is a problem that can afflict <strong>any server application</strong> so you can review the answers provided for other server software that return this error such as the question asked about JBOSS here ...</p> <p><a href="https://stackoverflow.com/questions/3947555/java-net-socketexception-unrecognized-windows-sockets-error-0-jvm-bind-jboss">java.net.SocketException: Unrecognized Windows Sockets error: 0: JVM_Bind (JBOSS)</a></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload