Hello there,
I am new to this forum.
I have been searching for a java database with two features.
I like the concept of a single filed database (the way MS Access is),
but would
like it to also have "out of the box" referential integrity.
So far my research has led me to look at these databases.
1. "SQLite" : is single filed, but no Referential integrity(also not
Java based)
2. "HSQLDB" : has referential integrity, but it has about 3-5 files on
disk, one file is the main
datafile, but cannot be transports like Access
due to dependencies on other files.
(it is Java based database)
3. "Firebird (embedded)" : this one is one of the best. It has both of
what I am looking for. But it is not Java based, and documentation is
confusing, difficult to find out which files are required to get it up
an running in Embedded Mode. I was able to get it running in Server
mode.
SO these were the three that I was looking at before.
So how does H2 database compare in regards to my requirements.
Questions
I read that H2 supports somehow to set it to run as a single filed
database on disk, is this true?
But I read that it does some index stuff in a separate file?
Does it have proper referential integrity like MS Access?
If this database does have these features in embedded mode then I will
crown this database
as the best database(for embedded) ever!
Hope someone can answer my questions.
Regards,
Paluee
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
