Thank you very much ! To everybody who have replied, and especially to Roman.

We are fixing now DbSchema for Firebird.
In case you have interests for DbSchema, I can send you a license key, just let me know.

Best regards,
Dragos Pruteanu




________________________________
From: Mark Rotteveel <Avalanche1979@...>
To: Firebird-Java@yahoogroups.com
Sent: Tuesday, October 21, 2008 9:44:26 PM
Subject: Re: [Firebird-Java] Re: jdbc driver issue


Thomas Kellerer wrote:

> --- In Firebird-Java@ yahoogroups. com, Roman Rokytskyy <roman@...> wrote:
>>> In our case bought methods returns empty lists. Is this the
> correct behavior ?
>> It was my understanding of the JDBC specs when I implemented those
>> methods. But if you read it differently, please comment.
>
> I would expect that the result of that call is consistent with the
> return values of:
>
> supportsSchemasInDa taManipulation( )
> supportsSchemasInIn dexDefinitions( )
> supportsSchemasInPr ivilegeDefinitio ns()
> supportsSchemasInPr ocedureCalls( )
> supportsSchemasInTa bleDefinitions( )
>
> If any of those methods return true, I would expect that getSchemas()
> returns at least one entry. If none of them return true, I would think
> returning nothing in getSchemas() is perfectly OK (although I do not
> have a real JDBC spec available only, the Javadocs).
> The same goes for catalogs.

If you are interested, the full JDBC spec is downloadable from
http://java. sun.com/products /jdbc/download. html
Unfortunately the spec itself says nothing about what getSchemas()
should return if schemas are not supported, but I believe the default
reaction specified is to return an empty resultset (at least that is
specified for the example of getUDTs() in paragraph 16.7.3, paragraph
7.5 says that getSchemas() is of the same 'class of metadata' as getUDTs())

You probably also need the X/Open SQL CLI spec (C451) from the open
group (freely available as a PDF on
http://www.opengrou p.org/bookstore/ catalog/elec_ free.htm ) to interpret
some parts of the spec (especially the scalar functions and the escape
syntax)

--
Mark Rotteveel <Avalanche1979@ gmx.net>





[Non-text portions of this message have been removed]