Re: JDBC ResultSet MetaData getTableName Informix SE
Posted in 2004
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