Subject Re: SQL Dialect 1, was Re: [Firebird-Java] Re: Can InterClient corrupt database?
Author Roman Rokytskyy
Hi Claus,

> Dear Roman we connect to FB103 with a dialect=1 parameter like this
> for jaybird1.5.3 !!!
> jdbc:firebirdsql:j5000.tfx.de/3050:/database/tfx.gdb?
> isc_dpb_sql_dialect=1&useTranslation=translation.hpux is this not
> supported or do you mean literally " the dialect can be dynamically
> changed" with in one session?

I meant exactly that parameter. However, your client dialect is 3 (till now
that was hardcoded in prepareSQL(...) method). Try executing following SQL:

SELECT CAST("now" AS DATE) FROM rdb$database

You should get error "Column NOW is not found" or something similar.

Roman