Hi,

I suspect that sql_dialect connection property does not work. I added
this to my todo list.

Best regards,
Roman

--- In Firebird-Java@y..., "Ian A. Newby" <ian@w...> wrote:
> Hi Roman,
>
> looking in isc_error_msg.properties on sourceforge I found that the
> main error message was "ambiguous field name between {0} and {1}".
>
> I have corrected the sql statement that caused this problem but am
> unclear why it worked in interclient but not the type 4 driver.
>
> The version of interclient I was using was 1.6, which is dialect 1
> only. I must assume that I've connected to my database as dialect
3,
> as I believe that firebird reports ambiguious fields as warnings in
> dialect 1 and errors in dialect 3.
>
> My connection url is as follows:
>
> "jdbc:firebirdsql://localhost/C:/!data/wwwServers/DEV/WEB-
> INF/Interbase/aktiv.fdb?sql_dialect=1"
>
> Can you see any problems with this?
>
> Regards
> Ian Newby