Informix - Problem description
Problem IT30336 | Status: Closed |
NULLPOINTEREXCEPTION FROM GETTABLES WHEN USING IFX_PAD_VARCHAR=TRUE | |
product: | |
INFORMIX SERVER / 5725A3900 / 450 - Informix 4.50 | |
Problem description: | |
getTables() throws an NullPointerException exception if IFX_PAD_VARCHAR is set to 'true'. To avoid the error use the expected values 0 or 1 for the IFX_PAD_VARCHAR variable. To see the problem compile and run the following code against a 14.10 engine: D:InfxworkJava>grep IFX e.java String url="jdbc:informix-sqli://:/sysmaster:informixse rver=i ds1410;user=informix;password=;IFX_PAD_VARCHAR=true"; D:InfxworkJava> D:InfxworkJava>java com.informix.jdbc.Version IBM Informix JDBC Driver Version 4.50.JC2 D:InfxworkJava>javac e.java D:InfxworkJava>java e Connected D:InfxworkJava>javac e.java D:InfxworkJava>java e Connected java.lang.NullPointerException java.lang.NullPointerException at com.informix.jdbc.IfxDatabaseMetaData.getTables(IfxDatabaseMetaD ata.java:2677) at e.main(e.java:22) D:InfxworkJava> It works with 4.10.JC11 D:InfxworkJava>set CLASSPATH=..informix-jdbc_410jc11.jar;. D:InfxworkJava>java e Connected D:InfxworkJava>java com.informix.jdbc.Version IBM Informix JDBC Driver Version 4.10.JC11 D:InfxworkJava> // -------- e.java ------------ import java.sql.*; public class e { private static Connection m_connection; static { try { Class.forName("com.informix.jdbc.IfxDriver"); } catch (Exception ex) { System.err.println(ex); System.exit(1); } } public static void main(String[] args) { String url="jdbc:informix-sqli://:/sysmaster:informixse rver=i ds1410;user=informix;password=;IFX_PAD_VARCHAR=true"; try { m_connection = DriverManager.getConnection(url, "informix", "ximrofni"); System.err.println("Connected"); DatabaseMetaData databaseMetaData = m_connection.getMetaData(); databaseMetaData.getTables(null, null, null, null); System.in.read(); System.in.skip(System.in.available()); } catch (Exception ex) { System.err.println(ex); ex.printStackTrace(); System.exit(1); } } } // -------- e.java ------------ | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix JDBC prior to 4.50.JC3. * **************************************************************** * PROBLEM DESCRIPTION: * * NULLPOINTEREXCEPTION FROM GETTABLES WHEN USING * * IFX_PAD_VARCHAR=TRUE * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix JDBC 4.50.JC3. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix JDBC prior to 4.50.JC3. * **************************************************************** * PROBLEM DESCRIPTION: * * NULLPOINTEREXCEPTION FROM GETTABLES WHEN USING * * IFX_PAD_VARCHAR=TRUE * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix JDBC 4.50.JC3. * **************************************************************** | |
Comment | |
Problem fixed in Informix JDBC 4.50.JC3. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 20.09.2019 02.12.2019 02.12.2019 |
Problem solved at the following versions (IBM BugInfos) | |
4.50.JC3 | |
Problem solved according to the fixlist(s) of the following version(s) |