The DB2 OTD Wizard Generates a NullPointerException For Any Non-SELECT Statement (Doc ID 1368444.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Sun Integrated Composite Application Network (ICAN) - Version: 5.0.5 and later   [Release: 5.0 and later ]
Information in this document applies to any platform.

Symptoms

When trying to create an OTD for a DB2 prepared statement that is not a SELECT, the OTD Wizard generates a NullPointerException:

java.lang.NullPointerException
at com.SeeBeyond.jdbc.db2.drda.ddp.q(Unknown Source)
at com.SeeBeyond.jdbc.db2.ddg.a(Unknown Source)
at com.SeeBeyond.jdbc.db2base.ddeh.w(Unknown Source)
at com.SeeBeyond.jdbc.db2base.dddb.getMetaData(Unknown Source)
at com.SeeBeyond.jdbcspy.SpyPreparedStatement.getMetaData(Unknown Source)
at com.stc.jdbc.builder.DBMetaData.getPrepStmtResultSetColumns(DBMetaData.java:1833)
at com.stc.jdbc.builder.DBMetaData.getPrepStmtMetaData(DBMetaData.java:784)
at com.stc.jdbc.wizard.PrepStmtsVisualPanel.addPrepStmt(PrepStmtsVisualPanel.java:161)

Changes

This issue occurs when using the DB2 Adapter version 5.0.7.6989606 and connecting to DB2 version 9.7.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms