Question:
I am unable to access my Informix database via most of the IDE database
tools (e.g. JDBC Explorer, SQL Builder, and Browse Table funtionality is lost)
Answer:
It appears that with older Informix JDBC drivers (problem reported against 1.22.JC1
specifically), there is a communication breakdown that causes an invalid
schema name, "informix", to be returned on the table. As most of the
IDE database tools rely on the schema name when internally querying the table, this
results in poor behavior:
1) one will experience errors of the type: "the specified table (informix.) is not
in the database" when attempting to open the table via JDBC Explorer's
"Data" page
2) the table will appear to have no columns defined when inspecting via
the "browse tables" dialog or the database tree in the left-hand pane of
the JDBC Explorer
Note that queries can still be performed successfully either via code or via the
"Enter SQL" page of JDBC Explorer.
The workaround for this problem is to update your JDBC driver to the latest
available from the vendor. Visit the download area of Informix's website (http://www.informix.com),
or go directly to http://www.intraware.com:81/shop/product.html?PLNE=000148
for more information on the latest JDBC drivers for Informix.