My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
  Symptoms
  Changes
  Cause
  Solution
  References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.