Hi,

The IBM Informix JDBC Driver 2.21.JC5 has a bug that I would like to find
out if there is a patch for and/or has been reported. I am using it against
INFORMIX-SE. The ResultSetMetaData.getTableName() method works fine when
doing a select from one table. But if there are two or more tables in the
query, the getTableName() method returns null. Anyone else encountered this,
know if it has been reported, etc etc?

Jim

sending to informix-list

As per IBM Informix JDBC Programmers manual
http://publibfi.boulder.ibm.com/epubs/pdf/ct1utna.pdf
Page - 3-20
"
ResultSetMetaData.getTableName()
Returns the table name for SELECT, INSERT, and UPDATE statements
SELECT statements with more than one table name and all other
statements return a String object containing one blank space."

However behaviour JDBC driver
seems to be diffrent from as documented in manual.
Per documentation getTableName() should not return a null in any case.

This is a reported problem.



Jim Miani <miani@icanon.com> wrote in message news:<bv67si$k1k$1@terabinaries.xmission.com>...
> Hi,
>
> The IBM Informix JDBC Driver 2.21.JC5 has a bug that I would like to find
> out if there is a patch for and/or has been reported. I am using it against
> INFORMIX-SE. The ResultSetMetaData.getTableName() method works fine when
> doing a select from one table. But if there are two or more tables in the
> query, the getTableName() method returns null. Anyone else encountered this,
> know if it has been reported, etc etc?
>
> Jim
>
> sending to informix-list