JDBC 3.00.JC3 DatabaseMetaData getColumns DATETIME bug

Posted in 2007

Doug Lawry — Tue, 2 Jan 2007 14:31:05 -0000 — source: Usenet: comp.databases.informix

If a table contains a DATETIME HOUR TO MINUTE/SECOND/FRACTION column, the latest version of the IBM Informix JDBC driver returns inconsistent meta data depending on the method used: Code: st = con.createStatement(); ResultSet rs = st.executeQuery("SELECT * FROM test_table"); ResultSetMetaData md = rs.getMetaData(); System.out.println(md.getColumnType(1)); Output: 92 (java.sql.Time) Code: DatabaseMetaData md = con.getMetaData(); ResultSet rs = md.getColumns("", "", "test_table", ""); rs.next(); System.out.println(rs.getString("DATA_TYPE")); Output: 93 (java.sql.Timestamp) In our opinion, Time is the correct corresponding Java data type, and the second case is a bug. Would someone be able to submit a request to get this fixed? -- Regards, Doug Lawry www.douglawry.webhop.org