You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Bruno Pierre <br...@yahoo.fr> on 2003/06/25 23:58:21 UTC
cocoon interface for HSQLDB
Hi everybody,
I'm looking for a cocoon interface (mounted subsitemap) for managing a HSQLDB like phpmyadmin for mysql.
Has anyone heard about this? Do I have to do it by myself?
if i have to, does someone have a good reference for the SQL of HSQLDB because everything i found is really not complete.
Thanks.
Re: cocoon interface for HSQLDB
Posted by Christian Haul <ha...@dvs1.informatik.tu-darmstadt.de>.
On 26.Jun.2003 -- 10:12 AM, Bruno PIERRE wrote:
> Thanks,
>
> It was already in my favorites, but it is not clear.
> i don't know how to list all the table, all the column of a table with their
> type (in SQL).
Most DBMS have special tables for the meta data. I don't know how
hsqldb does it. Anyway, I would suggest to go the jdbc route and use
the metadata api to query the dbms. Have a look at
java.sql.Connection#getMetaData() and friends for a start.
In addition, you could try to leverage
org.hsqldb.util.DatabaseManager. It contains code to read all the meta
data from the database. I've not looked at the exact code but I
believe it will provide good insight into using the meta data api of
jdbc and which parts are supported by hsqldb.
Chris.
--
C h r i s t i a n H a u l
haul@informatik.tu-darmstadt.de
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org
Re: cocoon interface for HSQLDB
Posted by Bruno PIERRE <br...@yahoo.fr>.
Thanks,
It was already in my favorites, but it is not clear.
i don't know how to list all the table, all the column of a table with their
type (in SQL).
and some stuff like that.
Bruno
----- Original Message -----
From: "Christian Haul" <ha...@dvs1.informatik.tu-darmstadt.de>
To: <co...@xml.apache.org>
Sent: Thursday, June 26, 2003 9:39 AM
Subject: Re: cocoon interface for HSQLDB
> On 25.Jun.2003 -- 11:58 PM, Bruno Pierre wrote:
> > Hi everybody,
> >
> > I'm looking for a cocoon interface (mounted subsitemap) for managing a
HSQLDB like phpmyadmin for mysql.
> >
> > Has anyone heard about this? Do I have to do it by myself?
>
> None that I am aware of.
>
> > if i have to, does someone have a good reference for the SQL of HSQLDB
because everything i found is really not complete.
>
> See http://hsqldb.sourceforge.net/doc/hsqlSyntax.html but it's quite
> picky on the syntax.
>
> Chris.
> --
> C h r i s t i a n H a u l
> haul@informatik.tu-darmstadt.de
> fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org
Re: cocoon interface for HSQLDB
Posted by Christian Haul <ha...@dvs1.informatik.tu-darmstadt.de>.
On 25.Jun.2003 -- 11:58 PM, Bruno Pierre wrote:
> Hi everybody,
>
> I'm looking for a cocoon interface (mounted subsitemap) for managing a HSQLDB like phpmyadmin for mysql.
>
> Has anyone heard about this? Do I have to do it by myself?
None that I am aware of.
> if i have to, does someone have a good reference for the SQL of HSQLDB because everything i found is really not complete.
See http://hsqldb.sourceforge.net/doc/hsqlSyntax.html but it's quite
picky on the syntax.
Chris.
--
C h r i s t i a n H a u l
haul@informatik.tu-darmstadt.de
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org