On Tue, 09 Mar 2004 14:09:09 +0100, you wrote:

>i've then used Squirrel SQL with the same database and i've found that
>it works and, looking at the code, it doesn't seem that it adds double
>quotes around table names...
>

Found it!

dbmd.getIdentifierQuoteString();

from the Javadoc:

Retrieves the string used to quote SQL identifiers. This method returns
a space " " if identifier quoting is not supported.

In Firebird/Interbase case it returns " or space depending on the table
name (case sensitive or not).

ciao
--
Seti@Home Java Applets
http://maruko.webhop.net/