HSQLDB

[Abder-Rahman Ali]

Hello,

For doing O/R mapping, I'm using for creating the tables "HSQLDB".

I have started up HSQLDB GUI by typing:[b] java -cp hsqldb.jar org.hsqldb.util.DatabaseManager[/b]

And the settings as follows:

Type: HSQL Database Engine Standalone
URL: jdbc:hsqldb:../../hsqldb/hibernateDB

And created two tables "A" and "B"

On the other hand, I started the server using the following command:

java -cp hsqldb.jar org.hsqldb.Server -database hibernateDB

So, that I run the server, and this is the message that I got at my DOS command prompt window:
 
server.properties not found, using command line or default prop
Opening database: hibernatetutorial
HSQLDB server 1.7.1 is running
Use SHUTDOWN to close normally. Use [Ctrl]+[C] to abort abruptl
Fri Sep 25 20:52:33 EEST 2009 Listening for connections ...

And, after that I laynched the HSQLDB GUI once again, but changed the "Type" setting to the following:

HSQL Database Engine Server

And, provided that the "Server" is still running, I'm expected to view the tables that I created at the left hand side of the HSQLDB GUI window, but that did NOT happen, why is that?

Thanks.

[Fred Toussi-2]

In the firs stage, after you have created the database and the two
tables, use the SQL command: "SHUTDOWN". It will work, provided the
database directory is the same as directory where you start the server.
Check the directory for the database files.

But in fact, you don't need the extra first step. (1) start the server
(there is no database) (2) connect to server with DatabaseManager and
create the two tables (3) check the tables exist (4) you can now run the
hibernate stuff. (5) Use DatabaseManager to check the contents of the
database and issue SHUTDOWN. (6) Next time you start the server, the
database will contain the data

FRED

On Fri, 25 Sep 2009 11:18 -0700, "Abder-Rahman Ali"
<abder.rahman.ali@...> wrote:

>
> Hello,
>
> For doing O/R mapping, I'm using for creating the tables "HSQLDB".
>
> I have started up HSQLDB GUI by typing:[b] java -cp hsqldb.jar
> org.hsqldb.util.DatabaseManager[/b]
>
> And the settings as follows:
>
> Type: HSQL Database Engine Standalone
> URL: jdbc:hsqldb:../../hsqldb/hibernateDB
>
> And created two tables "A" and "B"
>
> On the other hand, I started the server using the following command:
>
> java -cp hsqldb.jar org.hsqldb.Server -database hibernateDB
>
> So, that I run the server, and this is the message that I got at my DOS
> command prompt window:
>  
> server.properties not found, using command line or default prop
> Opening database: hibernatetutorial
> HSQLDB server 1.7.1 is running
> Use SHUTDOWN to close normally. Use [Ctrl]+[C] to abort abruptl
> Fri Sep 25 20:52:33 EEST 2009 Listening for connections ...
>
> And, after that I laynched the HSQLDB GUI once again, but changed the
> "Type"
> setting to the following:
>
> HSQL Database Engine Server
>
> And, provided that the "Server" is still running, I'm expected to view
> the
> tables that I created at the left hand side of the HSQLDB GUI window, but
> that did NOT happen, why is that?
>
> Thanks.
> --
> View this message in context:
> http://www.nabble.com/HSQLDB-tp25616734p25616734.html
> Sent from the HSQLDB - User mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry® Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9-12, 2009. Register
> now!
> http://p.sf.net/sfu/devconf
> _______________________________________________
> Hsqldb-user mailing list
> Hsqldb-user@...
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user