vmdd_tech wrote:

> Using odbcjdbc v1.1 b2,

<snip>

Do you mean OdbjJdbc v1.2 (beta)? That's the latest version at:
http://www.ibphoenix.com/main.nfs?page=ibp_60_odbc

I have started using this recently after switching from the free XTG ODBC
driver and found the following problem:

Often the query "select gen_id(my_gen,1) from rdb$database" fails and an
exception is thrown with the message "Unspecified error". The best that I
could determine is that the exception was thrown in the provider.
Occasionally this query works but mostly it doesn't. Regular queries such as
"select my_column from my_table" work fine, and my workaround is to use a
stored procedure "select nextid from myprocedure" which is a pain. After
trial and error the problem seems to be with the table name "rdb$database".

This problem does not occur (select .. from rdb$database works fine) when
using the freely available XTG ODBC driver for Firebird.

Regards,

Jarrod Hollingworth
Domain Name Pro: Find popular domain names in minutes.
Link Popularity: Compare web site link popularity to your competitors.
http://www.mozzle.com