Databases
StackOverflow2013
Postsdbo
POCreating a connection with hsqldb
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCreating a connection with hsqldb
    text
    copied!<p>I have to connect a database to a java program. I'm using HSQLDB on OS X 10.7.4 with Eclipse Helios and SQLExplorer plugin.</p> <p>This is the content of the runServer.sh file:</p> <pre><code>#!/bin/bash cd ../data java -classpath ../lib/hsqldb.jar org.hsqldb.server.Server -database.0 file:mantenimiento -dbname.0 mantenimiento </code></pre> <p>You can find it in:</p> <p><a href="http://i45.tinypic.com/jfw6tw.png" rel="nofollow">http://i45.tinypic.com/jfw6tw.png</a></p> <p>When I executed the script this is what I get:</p> <pre><code>MacBook-Pro-de-Luis:bin luis$ ./runServer.sh : No such file or directory ../data [Server@6016a786]: [Thread[main,5,main]]: checkRunning(false) entered [Server@6016a786]: [Thread[main,5,main]]: checkRunning(false) exited [Server@6016a786]: Startup sequence initiated from main() method [Server@6016a786]: Could not load properties from file [Server@6016a786]: Using cli/default properties only [Server@6016a786]: Initiating startup sequence... [Server@6016a786]: Server socket opened successfully in 7 ms. ] opened sucessfully in 505 ms.dex=0, id=0, db=file:mantenimiento, alias=mantenimiento [Server@6016a786]: Startup sequence completed in 513 ms. [Server@6016a786]: 2012-05-18 10:54:51.396 HSQLDB server 2.2.8 is online on port 9001 [Server@6016a786]: To close normally, connect and execute SHUTDOWN SQL [Server@6016a786]: From command line, use [Ctrl]+[C] to abort abruptly </code></pre> <p>I have problems with cd ../data and then it creates the database and says its working but it is created in /bin and not in /data.</p> <p>When I try to reate the conexion in Eclipse with SQLexplorer I get this:</p> <p><a href="http://i45.tinypic.com/21d3cl2.png" rel="nofollow">http://i45.tinypic.com/21d3cl2.png</a></p> <p>And the terminals says:</p> <pre><code>[Server@6016a786]: [Thread[HSQLDB Connection @60f47bf5,5,HSQLDB Connections @6016a786]]: database alias=mantenimiento does not exist </code></pre> <p>Anyone knows what am I doing wrong?</p> <p>Thank you.</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