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:
>
> supportsSchemasInDataManipulation()
> supportsSchemasInIndexDefinitions()
> supportsSchemasInPrivilegeDefinitions()
> supportsSchemasInProcedureCalls()
> supportsSchemasInTableDefinitions()
>
> 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.opengroup.org/bookstore/catalog/elec_free.htm ) to interpret
some parts of the spec (especially the scalar functions and the escape
syntax)

--
Mark Rotteveel <Avalanche1979@...>