1. HypersonicSQL (now hsqldb) is not dead or deceased...it is very much
alive at http://hsqldb.sourceforge.net. We're about to do another point
release to both the HypersonicSQL and hsqldb engine (as well as add new GUI
tools and db analyses (ala CocoBase - although not yet with ALL that O-R
functionality)) on the 16th of June.
2. Today, however, you can download the latest releases if you follow the
links to the SourceForge Project Page (or go there directly - the URL is
http://sourceforge.net/projects/hsqldb and the file download area is at
http://sourceforge.net/project/showfiles.php?group_id=23316 . By the way,
we're looking for developers to help us move into the next era of Hypersonic
goodness (multi-threading, full SQL-92 and JDBC 3 compliance, JDO, J2EE and
J2ME (CLDC and MIDP), a more robust and extensible architecture, and a bit
more user-choice on compile and on run-time). If you're interested, you can
post in the Open Discussion area of the Project at
http://sourceforge.net/forum/forum.php?forum_id=73673 with a description of
where you would like to help - we need testers, developers, translators,
tech writers and users's feedback. (NOTE: PLEASE SIGN IN WITH A SOURCEFORGE
ID BEFORE POSTING OR LEAVE AN EMAIL ADDRESS - THANK YOU.)
3. On to your question. Since Orion has not yet updated to the hsqldb
engine, the best bet is for you to go to your Orion root and the docs
sub-directory and look for a file called ' hsql-howto.html . ' Instead of
where this document tells you to download from, do your download from the
files area, above (not necessary, if you have Orion after 1.4, I believe).
The thing you want to change, though, is the database schema in '
database-schemas/hypersonic.xml '
4. Also, there is extensive documentation in the Sourceforge hsqldb Project
download area about HypersonicSQL and hsqldb. Finally, there are citations
for Orion in many files. Just grep or do a find on the Orion root for the
text 'hsql' I believe that the first file you'll see (in either default
sort) is 'changes.txt' where the Orion folks specify the version of
hsql/HyperSonicSQL they shipped and how it is implemented in your version.
I've tested Orion for usability with the newer versions of hsqldb (through
our current beta cut) and it works fine. You just have to understand that
the Orion folks just wanted a free, non-license fee requiring data source
for the Orion Engine, not necessarily as the ONLY db in the suite.
Hopefully this situation will improve with time as we in hsqldb.org work
towards meeting more of the community's expectations. That's not to say we
don't have a rock-solid, kickass product that we give away for free,
unencumbered, with full source AND we let you see all the development
processes as they are going on AND let you help direct the development.
Because we do. It's just that we'll be the first to admit the product
'needs improvement.'
4. If you have any questions, please feel free to ask them in the forums or
on the maillists.
Michael J. Cannon
Project Manager and COO
hsqldb.org
http://www.hsqldb.org/
[EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of udi h bauman
Sent: Thursday, May 31, 2001 4:49 AM
To: Orion-Interest
Subject: Altering database table
Hi,
I'm using the Hypersonic database that arrived with Orion.
I've added a field to an entity bean (in the ejb-jar.xml) yet it seem like
Orion didn't update the database structure.
How can I alter the table structure? I there a way to re-create it?
I understand the Hypersonic database is deceased or something, but is there
a live console somewhere?
Thanks,
udi
