Do HSQLDB databases always require more than one file.

View: New views
4 Messages — Rating Filter:   Alert me  

Do HSQLDB databases always require more than one file.

by Ken McDonald :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

 From the beginner's reading I've done, it seems that an HSQLDB  
database always consists of at least two files, one storing the data,  
and the other storing info about the database. Is it necessary to  
always have at least two files, or can a database be stored in a  
single file? I'm thinking of distributing information, and if I have  
to do it as pairs (or more) of files, it's inevitable that things are  
going to become mismatched by users. If I can store the entire db as a  
single file, this problem disappears.

Thanks,
Ken

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

Re: Do HSQLDB databases always require more than one file.

by Clayton Carter-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I have a similar situation.  Anyone have any insight on this?

Clayton


On Tue, May 6, 2008 at 10:16 PM, Kenneth McDonald
<kenneth.m.mcdonald@...> wrote:

>  From the beginner's reading I've done, it seems that an HSQLDB
> database always consists of at least two files, one storing the data,
> and the other storing info about the database. Is it necessary to
> always have at least two files, or can a database be stored in a
> single file? I'm thinking of distributing information, and if I have
> to do it as pairs (or more) of files, it's inevitable that things are
> going to become mismatched by users. If I can store the entire db as a
> single file, this problem disappears.
>
> Thanks,
> Ken
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
> Don't miss this year's exciting event. There's still time to save $100.
> Use priority code J8TL2D2.
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> _______________________________________________
> Hsqldb-user mailing list
> Hsqldb-user@...
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

Re: Do HSQLDB databases always require more than onefile.

by fredt :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

You need at least the two files.

Fred
----- Original Message -----
From: "Clayton Carter" <crcarter.giveout@...>
To: "HSQLdb user discussions" <hsqldb-user@...>
Sent: 28 May 2008 01:33
Subject: Re: [Hsqldb-user] Do HSQLDB databases always require more than
onefile.


I have a similar situation.  Anyone have any insight on this?

Clayton


On Tue, May 6, 2008 at 10:16 PM, Kenneth McDonald
<kenneth.m.mcdonald@...> wrote:

>  From the beginner's reading I've done, it seems that an HSQLDB
> database always consists of at least two files, one storing the data,
> and the other storing info about the database. Is it necessary to
> always have at least two files, or can a database be stored in a
> single file? I'm thinking of distributing information, and if I have
> to do it as pairs (or more) of files, it's inevitable that things are
> going to become mismatched by users. If I can store the entire db as a
> single file, this problem disappears.
>
> Thanks,
> Ken
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
> Don't miss this year's exciting event. There's still time to save $100.
> Use priority code J8TL2D2.
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> _______________________________________________
> Hsqldb-user mailing list
> Hsqldb-user@...
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user 


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

Re: Do HSQLDB databases always require more than one file.

by Marc Ravensbergen :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I've gotten around this by just creating a zip of the files and distributing the zip. (just in case you didn't know, java has excellent support for zipping and unzipping archives progamattically)

Marc



On Tue, May 27, 2008 at 8:33 PM, Clayton Carter <crcarter.giveout@...> wrote:
I have a similar situation.  Anyone have any insight on this?

Clayton


On Tue, May 6, 2008 at 10:16 PM, Kenneth McDonald
<kenneth.m.mcdonald@...> wrote:
>  From the beginner's reading I've done, it seems that an HSQLDB
> database always consists of at least two files, one storing the data,
> and the other storing info about the database. Is it necessary to
> always have at least two files, or can a database be stored in a
> single file? I'm thinking of distributing information, and if I have
> to do it as pairs (or more) of files, it's inevitable that things are
> going to become mismatched by users. If I can store the entire db as a
> single file, this problem disappears.
>
> Thanks,
> Ken
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
> Don't miss this year's exciting event. There's still time to save $100.
> Use priority code J8TL2D2.
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> _______________________________________________
> Hsqldb-user mailing list
> Hsqldb-user@...
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
LightInTheBox - Buy quality products at wholesale price