To create tables and Generate Reports using Hypersoonic SQL>>>>>>>>>>>>

[Narayanan Natarajan <na...@nonhp-sg.exch.hp.com>]

Websphere Portal Server - The next step after LoginHi,
Can you please help me out how to create tables using Hypersonic SQL and generate reports from that?
Write me in detail about the information to create the new database using Hypersonic SQL also.


Thanks,
Kind Regards,
Natarajan

RE: To create tables and Generate Reports using Hypersoonic SQL>>>>>>>>>>>>

[David Sean Taylor <da...@bluesunrise.com>]

Websphere Portal Server - The next step after LoginThe Jetspeed distribution
includes a Hypersonic SQL database populated with some minimal rows for
users and related information.
You can run the Hypersonic SQL Administrator from /WEB-INF/db/manageDB.bat
 I will check in a UNIX version as soon as I test it on Linux)
>From there, its pretty easy. Just type your SQL and execute it.
As for report writers, sorry but I don't know of any open source report
writers.
There are  several commercial report writers available that work with any
JDBC-compliant driver, including Hypersonic SQL's driver.

As for general Hypersonic SQL questions, try here:
http://sourceforge.net/projects/hsqldb/
-------------------------------------
David Sean Taylor
taylor@apache.org
-------------------------------------
http://jakarta.apache.org/jetspeed
-------------------------------------




  -----Original Message-----
  From: Narayanan Natarajan
[mailto:natarajan_narayanan@nonhp-sg.exch.hp.com]
  Sent: Monday, June 25, 2001 11:17 PM
  To: jetspeed-dev@jakarta.apache.org;
jetspeed-user-help@jakarta.apache.org; jetspeed-dev-help@jakarta.apache.org
  Subject: To create tables and Generate Reports using Hypersoonic
SQL>>>>>>>>>>>>


  Hi,
  Can you please help me out how to create tables using Hypersonic SQL and
generate reports from that?
  Write me in detail about the information to create the new database using
Hypersonic SQL also.


  Thanks,
  Kind Regards,
  Natarajan