Firebird: JDBC connection and multiple schemas

From: Alexandr Molochnikov (NOBODY_at_NO_SPAM.com)
Date: 06/16/04 

Date: Wed, 16 Jun 2004 02:41:25 GMT

I've just started playing with Firebird 1.5, and already run into something
I cannot comprehend. It appears to me that in Firebird a JDBC connection is
associated with schema, which is made part of the URL (actually, the URL
requires the name of the physical file, but since there is a one-to-one
correspondence between schema and file, one can say that the association is
done at the schema level).

If this is so, how can one run a SELECT against tables that belong to
different schemas? Normally, one would qualify the table names with their
schemas, but in Firebird a given connection will know only its own schema,
so would this even be possible?

Any clues, as well as pointers to a good on-line info will be appreciated.
(I looked at the docs available from Sourceforge, but the issue of qualified
table names is ignored there. A sign of feature not supported?)

Alex Molochnikov
Gestalt Corporation
www.gestalt.com