Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

HSQL DATABASE FILE FORMAT

1 view
Skip to first unread message

maddy

unread,
Jan 2, 2007, 4:25:03 AM1/2/07
to
Hi,
i would like to know the how data stored in a hsql database of various
form like
a) text dat
b)picture data
c)non structured data

Arne Vajhøj

unread,
Jan 2, 2007, 8:46:46 PM1/2/07
to

HSQL is open source, so why not just download the source
and look.

(my guess is that it is a rather complex format)

Arne

IchBin

unread,
Jan 2, 2007, 9:00:21 PM1/2/07
to

That is what makes databases so great. You do not have to worry about
the physical format. It is a Database. If you did know what would it
matter? You will only be able to access via the HSQLDB driver. It could
reside in memory, cache or flat file. This is all transparent to the
programmer outside of defining the database tables.

--
Thanks in Advance... http://ichbinquotations.awardspace.com
IchBin, Pocono Lake, Pa, USA http://ichbin.9999mb.com
______________________________________________________________________
'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)

Ian Wilson

unread,
Jan 3, 2007, 5:48:19 AM1/3/07
to

There are at least two different ways to interpret your question:

1)
What disk or file formats does HSQL use when writing various data types
to disk?

2)
What Java statements do I write in order to save the following data
types into a HSQL database?


The answer to 1 is as given by the other respondents. The answer to 2 is
to study the examples provided with HSQL and to learn about JDBC

I am unfamiliar with HSQLDB so I cannot directly answer question 2.
By feeding Google with "Java JDBC Blob" and "hsql Java" I was rewarded
with <http://www.javangelist.de/space/JDBC/Blob>
<http://hsqldb.org/web/hsqlFAQ.html#START> and numerous other examples.

0 new messages