Problem with JBuilder3 & Informix

Posted in 1999

Michael Simons — Tue, 17 Aug 1999 14:26:48 +0200 — source: Informix-list mailing list archive (1991-1998)

Hello, I've got the following problem: Opening the JDBC-Explorer of JBuilder Opening a connection Displaying list of tables Picking a table XY, list of columns is shown on the right part of the window. Switching to display data tab in the right window part ==> Error: Table XY doesn't exist. I get the same error when doing a select * from XY within the JDBC Explorer or within an application created with JBuilder. I tried several JDBC (IfxJDBC V1.5 & V2.0) and ODBC (together with the JDBC-ODBC-Bridge) drivers for Informix and always get the same problem. But connecting to any other DB (Oracle, Interbase) works. Anyone out there havin' the same problem or similar problems with Informix? I know that Informix doesn't support ResultSetMetaData.getTableName() and some more, maybe that causes the problem. bye michael