Re: HSQLDB and Jonas clarification please.
From: IchBin (weconsul_at_ptd.net)
Date: 12/28/04
- Next message: Jan Jansen: "Re: RowSet vs Hibernate, JDO, etc."
- Previous message: natG: "HSQLDB and Jonas clarification please."
- In reply to: natG: "HSQLDB and Jonas clarification please."
- Next in thread: natG: "Re: HSQLDB and Jonas clarification please."
- Reply: natG: "Re: HSQLDB and Jonas clarification please."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Next message: Jan Jansen: "Re: RowSet vs Hibernate, JDO, etc."
- Previous message: natG: "HSQLDB and Jonas clarification please."
- In reply to: natG: "HSQLDB and Jonas clarification please."
- Next in thread: natG: "Re: HSQLDB and Jonas clarification please."
- Reply: natG: "Re: HSQLDB and Jonas clarification please."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|