Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...

Java Forum / Databases / December 2004

Tip: Looking for answers? Try searching our database.

HSQLDB and Jonas clarification please.

Thread view: 
natG - 28 Dec 2004 03:44 GMT
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
IchBin - 28 Dec 2004 08:43 GMT
> Hi;
> I am new to hsqldb, and have been exposed to it mainly via Jonas j2ee
[quoted text clipped - 17 lines]
> 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-su
mmary.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
natG - 28 Dec 2004 15:50 GMT
>> Hi;
>> I am new to hsqldb, and have been exposed to it mainly via Jonas j2ee
[quoted text clipped - 69 lines]
> Sorry, but hope this points you in the right direction?
> IchBin
Sorry? Nothing for. Thank you, much.
-nat

> __________________________________________________________________________
>
> '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


Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.