Re: [Hsqldb-developers] Re: SEQUENCES DO NOT WORK IN HSQLDB 1.8.0.4

[Nitin U. <nit...@gm...>]

Thanks Fred:

WIll inform the posts that I have found.

What is the SEQUENCE_CATALOG field? When I added a sequence using:

CREATE SEQUENCE utility_content_SEQ
AS INTEGER
START WITH 1
INCREMENT BY 1;

I get null as the SEQUENCE_CATALOG.



On 4/20/06, fredt <fr...@us...> wrote:
>
>  I'm not aware of the groups where such questions have been raised. If yo=
u
> know, please let them know.
>
> Fred
>
>  ----- Original Message -----
> *From:* Nitin Uchil <nit...@gm...>
>  *To:* hsq...@li...
> *Sent:* 20 April 2006 14:02
> *Subject:* Re: [Hsqldb-developers] Re: SEQUENCES DO NOT WORK IN HSQLDB
> 1.8.0.4
>
>
> Thanks Fred - it works.
>
> But in several use groups this question about SEQUENCES not working has
> popped up perhaps because they do not know that INFORMATION_SCHEMA needs =
to
> be prepended.
>
> Best Regards.
>
> Nitin
>
>
> On 4/20/06, fredt <fr...@us...> wrote:
> >
> >  You need to use:
> >
> > SELECT * FROM INFORMATION_SCHEMA.SYSTEM_SEQUENCES
> >
> > Please read the docs on SCHEMA and SEQUENCE support. Also note that you
> > do not use the above query in order to access the sequences. The expres=
sion
> > used is "NEXT VALUE FOR a_sequence"
> >
> > Fred
> >
> >  ----- Original Message -----
> > *From:* Nitin Uchil <nit...@gm...>
> > *To:* fr...@us... ; hsq...@li...=
.net.
> >
> >  *Sent:* 20 April 2006 12:32
> > *Subject:* SEQUENCES DO NOT WORK IN HSQLDB 1.8.0.4
> >
> >
> >  Hi Fred:
> >
> > Looks like sequnces still do not work in version 1.8.0.4. I tried:
> >
> > SELECT * FROM SYSTEM_SEQUENCES
> >
> > and it gives a table not found error. We are migrating our databases
> > from Oracle and mySQL and this is one thing that is holding us back.
> >
> >
> > Nitin Uchil
> >
> >
> >
>
>
> --
> Nitin Uchil
> (734)945-6463
>
>


--
Nitin Uchil
(734)945-6463