Главная страница | назад





Article #19744: Unable to use IDE tools to access and/or update tables in Informix database

 Question and Answer Database

     FAQ: FAQ4744J - Unable to use IDE tools to access and/or update tables in Informix database
Category: Database (Informix)
Platform: All Windows
 Product: 

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.

8/4/99 2:09:45 PM
 

Last Modified: 01-SEP-99