Re: HSQLDB and Jonas clarification please.

From: IchBin (weconsul_at_ptd.net)
Date: 12/28/04


Date: Tue, 28 Dec 2004 03:43:03 -0500

natG wrote:
> Hi;
> I am new to hsqldb, and have been exposed to it mainly via Jonas j2ee
> server, which includes it. I have since researched it a bit, but I need
> some clarifications, please.
>
> I see that there are different modes of setting it up.
> Which mode does Jonas utilize? Is it in memory embedded in the same jvm
> as the rest of the j2ee server?
>
> In Jonas, where is the data persisted to? Can I configure it?
> When is the data written to disk?
>
> How do I connect to it, outside of Jonas? (via plain jdbc.)
>
> And what is this DatabaseManagerSwingClass? Can I utilize it even when
> Jonas is somehow encapsulating the db?
>
> (Is DatabaseManagerSwingClass unique to HSQLDB?)
>
> Thank you all;
> -nat
Nat,

The better place to submit this question, on HSQLDB, is on the HSQLDB
support user group at:
http://sourceforge.net/forum/forum.php?forum_id=73674

and for JOnAS at their support user group at:
jonas@objectweb.org (JOnAS General Mailing List).

To understand HSQLDB go to:
http://hsqldb.sourceforge.net/web/hsqlDocsFrame.html

JOnAS API for HSQLDB at:
http://jonas.objectweb.org/current/jdoc/org/objectweb/jonas/db/hsqldb/package-summary.html

Having said this I am not familiar with JOnAS. I can answer some
questions but again post to the fore mention support groups above. You
could just cut and paste you question to their support groups.

DatabaseManagerSwing class is unique to HSQLDB. This is their front end
interface to HSQLDB. It can also work with most other DBMS in the same
sense that say 'SQuirreL SQL' Client Version works for most DBMS's.

If you download HSQLDB, for your own use, you will find a demo
subdirectory with predefine bat and sh files to use some of the
utilities for HSQLDB.

Currently there is none for DatabaseManagerSwing. It will be there once
all of my changes are accepted at the HSQLDB developer group. They will
incorporate in to the distribution product jar file. But you can just
copy the runManager.bat to runManagerSwing.bat and change the call from
org.hsqldb.util.DatabaseManager to org.hsqldb.util.DatabaseManagerSwing
until then.

I would guess that you would connect to JOnAS using a server connection.
I am not familiar with there server connection string.

The HSQL JDBC driver is 'org.hsqldb.jdbcDriver'. HSQL connection strings
are as follows:

Memory: jdbc:hsqldb:mem:.
Standalone: jdbc:hsqldb:file:«database/path?»
Server: jdbc:hsqldb:hsql://localhost:<port>/
Web Server: jdbc:hsqldb:http://«hostname/?»

You could make a request to add a URL to DatabaseManager and
DatabaseManagerSwing login screen for JOnAS at;
https://sourceforge.net/tracker/?atid=454228&group_id=23316&func=browse

Sorry, but hope this points you in the right direction?
IchBin
__________________________________________________________________________

'The meeting of two personalities is like the contact of two chemical
substances: if there is any reaction, both are transformed.'
- Carl Gustav Jung, (1875-1961), psychiatrist and psychologist



Relevant Pages

  • Re: HSQLDB and Jonas clarification please.
    ... >> server, which includes it. ... >> Which mode does Jonas utilize? ... >> (Is DatabaseManagerSwingClass unique to HSQLDB?) ... > Currently there is none for DatabaseManagerSwing. ...
    (comp.lang.java.databases)
  • HSQLDB and Jonas clarification please.
    ... I am new to hsqldb, and have been exposed to it mainly via Jonas j2ee ... server, which includes it. ... Which mode does Jonas utilize? ...
    (comp.lang.java.databases)
  • Re: Newbie seeks advice on choice of database...
    ... PointBase is a hit on all your requirements. ... There exists two other choices too: IBM's cloudscape, and HSQLDB. ... open source, free, can run embedded and as server. ...
    (comp.lang.java.databases)
  • Re: Anmeldung an Outlook Web Access
    ... Der OWA ist nur um den offiziellen Server zu entlasten. ... > Jonas schrieb: ... >> Exchange Server 2003, den ich als FrontEndServer verurteilt habe, den die ...
    (microsoft.public.de.exchange)
  • Re: SBS 2000 Shares Disappear
    ... I *always* have a secondary DNS server. ... the Jonas app is VERY chatty. ... locks and opens had to be tweaked and I am thinking ...
    (microsoft.public.windows.server.sbs)