IV16885: CACHEDROWSETSWRITER.INSERTNEWROW() THROWS SQLEXCEPTION

APAR status

• Closed as program error.

Error description

• Error Message: java.sql.SQLException: Invalid column name
  .
  Stack Trace: java.sql.SQLException: Invalid column name
          at
  com.sun.rowset.CachedRowSetImpl.getColIdxByName(CachedRowSetImpl
  .java
  :1643)
          at
  com.sun.rowset.CachedRowSetImpl.getObject(CachedRowSetImpl.java:
  3023)
          at
  com.sun.rowset.internal.CachedRowSetWriter.insertNewRow(CachedRo
  wSetW
  riter.java:847)
          at
  com.sun.rowset.internal.CachedRowSetWriter.writeData(CachedRowSe
  tWrit
  er.java:346)
          at
  com.sun.rowset.CachedRowSetImpl.acceptChanges(CachedRowSetImpl.j
  ava:8
  75)
          at
  com.sun.rowset.CachedRowSetImpl.acceptChanges(CachedRowSetImpl.j
  ava:9
  34)
          at TestRowset2.performTest(TestRowset2.java:116)
          at TestRowset2.main(TestRowset2.java:125)
  .
  This problem occurs when the CachedRowSet object is created with
  a query which excludes primary key as the primary key is
  declared as autoincrement.
  

Local fix

Problem summary

• Problem was caused as the algorithm to check the duplicate
  primary keys was not considering the fact that primary key can
  be autoincrement and need not be present in the CachedRowSet
  object.
  

Problem conclusion

• This defect will be fixed in:
  6.0.0 SR11
  6.0.1 SR3
  7.0.0 SR2
  .
  JVM code has been updated to handle the scenario when primary
  key is autoincrement.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  JAVA CLASS LIBS

• Fixed component ID

  620700130

Applicable component levels

• R600 PSY

     UP

• R700 PSY

     UP